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.091 seconds

“

”

Real time saver and great Component Builder tool ! I have been developing with J-Cook Pro Component Builder for several months now and can say with all honesty that this product/service is second to none. The product is feature rich and is being improved and added to all the time. Do yourself a favor if you need to build a Joomla! Component then you can do no wrong in trying the product. You will save on time and effort while being able to deliver your project on time. J-Cook pro does the hard work for you you then have the freedom to fully customise the end result for your own needs.

One word: Awesome.
Edwardcox (JED)