Portal Engine Questions on portal engine and web parts.
Version 6.x > Portal Engine > Displaying Grouped data, in order View modes: 
User avatar
Member
Member
sammy - 3/5/2013 9:42:08 AM
   
Displaying Grouped data, in order
Hi All,
I'm a complete kentico noob, and this was thrown at me. Basically, I need to fix a page in Kentico.

The company has 100s of office locations, around the world. I need to display all the offices, in the following ordered format:

I need to display the following
Continent < -- this is a heading
Country Name < -- this is a heading
State Name <-- this is a heading
Then, all businesses are listed below, ordered by Name, City.
For each business the complete address/contact information is output.


I can get all this data, out of the database, and ordered correctly.

What control, would be the easiest to use, to group this data (by Continent, Country, State), and then businesses in the correct order?

Thanks a bunch!

User avatar
Member
Member
sammy - 3/5/2013 9:54:51 AM
   
RE:Displaying Grouped data, in order
btw,here is a screenshot of what I want the data to look like.

The only difference, is that, it's possible for there to be more than 1 row of companies per state.

screenshot

In that example, Arizona has 2 locations, but its possible to have 20 locations. So, you would see 6 rows of 3, and then the last (7th row) of 2.

They would be ordered horizontally. So, businesses starting with "A" would be listed first, and go across the screen. Like reading a book.

Thanks!

User avatar
Kentico Support
Kentico Support
kentico_filipl - 3/14/2013 5:17:05 AM
   
RE:Displaying Grouped data, in order
Hello,

The most suitable way to achieve such a hierarchy would be to use hierarchical transformations for that document type. Supported web parts for these transformations are Hierarchical viewer and Universal viewer. You can take a look at the example on the sample Corporite Site in the Examples -> Web Parts -> Listings and viewers -> Documents -> Universal viewer section of the content tree. Further details can be found in the Developer's Guide - Hierarchical transformations

Another way would be to use nested repeaters. This can be done by setting Nested controls ID property which should contain IDs of all repeaters used within the configured repeater.

Best regards,
Filip Ligac