pepperstreet VIP
Total posts: 3,837
07 Сен 2012 14:55

(moved topic from C7 category to C8)

Grouping list results

Is there any possibility to group list results by field values ? I mean something like you can achieve with "SQL group by". I also have seen this feature in Drupal Views module, which gives really cool and versatile results. Also "Fabrik" has advanced SQL joins and groups...

I know, this might be custom SQL related, and it is no Cobalt filter feature...

Maybe something similar can be achieved by pre-filtered lists or records module and fields?! Does grouping by categories make any sense? If all this is to special for Cobalts filter... what about manipulating and re-arranging the results with javascript?

Just guessing...

Any thoughts are much appreciated.

Thanks for listening.

PS: Also seeking and accepting hints for ME Resources!!

What if all items are differentiated by field values? The source data is not organized in categories! It might be simple selects, maybe MultiLevelSelect values...

Simple example output, sorted and displayed in groups and 2 sublevels:

First_Group_Name_1 ( <== no category, its a field value )

-> Gold items ( <== no category, its a field value )

  --> Item1

  --> Item2

  --> Item3

  --> ...

-> Silver items

  --> Item1

  --> Item2

  --> Item3

  --> ...

-> Bronze items

  --> Item1

  --> Item2

  --> Item3

  --> ...

Second_Group_Name_2

-> Gold items

  --> Item1

  --> Item2

  --> Item3

  --> ...

-> Silver items

  --> Item1

  --> Item2

  --> Item3

  --> ...

-> Bronze items

  --> Item1

  --> Item2

  --> Item3

  --> ...

etc.

Последние изменения: 10 Май 2016


Sergey
Total posts: 13,748
08 Сен 2012 05:51

Yes that was discussed for resources also. Something like

Montana - Vendor 1 - Vendor 2

Texas - Vendor 1 - Vendor 2

Where Tesax is the field value.

Grouping is good thing. Although I believe that еры may be don on the level of template, we will try to add something to our table template.


pepperstreet VIP
Total posts: 3,837
22 Сен 2012 11:10

Sorting:

Maybe a similar logic and feature? Is it possible to sort by more than one criteria? Cascading like:

=> 1. by a Date
==> 2. by TitleABC
===> 3. field-XYZ

Remember this is possible in CommunityBuilder user lists.
I guess, its easier in CB because of the table/field structure.


Sergey
Total posts: 13,748
30 Окт 2012 23:14

Not now.


pepperstreet VIP
Total posts: 3,837
20 Янв 2013 17:12

I'll add parameter to template for Cobalt 8

Any news?


Sergey
Total posts: 13,748
21 Янв 2013 21:10

:) Now it is in the list of issues on github. So it will be done as soon as it will be prioritise. But at least it will not get lost again.


Sergey
Total posts: 13,748
10 Май 2016 05:43

Yes, I know. I remember about this every day. I desided to concentrate on Emerald 10 rekease this week and then concentrate on Cobalt 9.

Работает на Cobalt