TOPIC:

[FIXED] Group By on collection view. 21 Feb 2012 07:53 #1416

christophe
Topic Author
Offline
New Member
Web Integrator
Posts: 16
Thank you received: 3

Hello,

here is my trouble :

I want to create a view on a table with grouping so it will be easier to read for end user.

is is the situation :

I have a table which is a list of department. This table is link to countries table with a foreign key. The countries table is linked to continent table with foreign key.

I would like to group the departements by continent.
To do so, I use the group by -> Countries_Title. If offers me a new choice of Group By to select the Continent->Title.

But when checking the sandbox is does not work.

Maybe I made a mistake on the test values or is is not feasable ?

All you need is Joomla!

Please Log in or Create an account to join the conversation.

Last edit: by admin.

Re: GRoup By on collection view. 21 Feb 2012 09:10 #1417

christophe
Topic Author
Offline
New Member
Web Integrator
Posts: 16
Thank you received: 3

going further on the topic I found some troubles :

created tables :
- Continent
- Countries
- Departments

Foreing keys :
- Continent in Countries
- Countries in Department

When working on the collection vies :

first try :
show department title ; continent title ; country title
=> all is OK and I can see each informations from my dataset

second try :
showing same fields than first try but grouping by country
=> the continent value for each line disappear on the view.
=> the component can't retrieve the value for continent anymore ?

All you need is Joomla!

Please Log in or Create an account to join the conversation.

Re: GRoup By on collection view. 21 Feb 2012 13:13 #1419

admin Offline Administrator Chef Posts: 3711 Thank you received: 986	It was a conflict in the model. Collateral dammage after an evolution ther last week. Fixed. Please regenerate. Coding is now a piece of cake
	Please Log in or Create an account to join the conversation.

Re: GRoup By on collection view. 21 Feb 2012 14:01 #1422

christophe Topic Author Offline New Member Web Integrator Posts: 16 Thank you received: 3	Hi, thanks for the quick reply. Problem is still there. Know, I have some display of my datas but I still can't view the Continent information is the site list. If needed, you can check it on demo1007. Thanks for your attention. All you need is Joomla!
	Please Log in or Create an account to join the conversation.

Re: GRoup By on collection view. 21 Feb 2012 14:57 #1424

admin Offline Administrator Chef Posts: 3711 Thank you received: 986	I see them perfecly in back-end. You don't have any front-end layout defined. That's the point. EDIT : I usually never do that, but because I see it is a test component, I added a continent ('Europe') in order to see this continent label in the group of the 'departement' table. sandbox.cms25.j-cook.pro/administrator/i...007&view=departement Coding is now a piece of cake
	Please Log in or Create an account to join the conversation. Last edit: by admin.

Re: GRoup By on collection view. 21 Feb 2012 15:10 #1425

christophe Topic Author Offline New Member Web Integrator Posts: 16 Thank you received: 3	ok, I think I had troubles with my dataset. I was sure to have added Europe and asia but was not lol Thanks. All you need is Joomla!
	Please Log in or Create an account to join the conversation.

Page:
1

Forum

Debug

Closed tickets.

[FIXED] Group By on collection view.

Time to create page: 0.173 seconds

“

”

Freakin' Awesome!!! J-Cook is simply awesome - whether you're a highly experienced developer or complete novice whether you're building a small inventory component or a complete community solution! The beauty comes from a fast slick and reliable platform that readily provides developers with everything they'll need to build the backbone of a solid and secure component with wizards for authoring access publishing aliasing created/modified by dates... you name it COOK provides it! J-Cook really surpasses all of the 'competition' as far as MVC tools are concerned! Try love it and get cooking!
learnthrusong (JED)