Asset listing group by keyword - data source

I have a DB data source that connects to a DB and generates a set of Data Source Record Sets. I have set up an asset listing to turn them into a <select> set, with the display format generating each <option>.


I would like to group the <option>'s using <optgroup>'s based on one of the fields in the Record Set. I have set up custom grouping to group by keyword, used the appropriate keyword (%ds__example%) and edited the group format. Unfortunately it doesn't seem to be actually grouping by that field. Grouping is occurring - it is just that all the sets are ending up in the same group.



The keyword does not generate any content when used in the Group Format bodycopy. Nor do %parent_name% or %group_name% however %group_total_child_asset_count% does generate the correct number.



Any help or clarification on this would be appreciated.



Jeffery

I've come across the very same limitation just recently actually.


The only work around I've had thus far is to just use JS to do the grouping (but obviously that's not the ideal solution for every problem).



Would be nice to see what others have done.

What are the settings that you've used on the Asset Group screen?


Dave

On the Asset Grouping screen of the asset listing the settings are:


Group Level 1: Keyword

Keyword - %ds__XXXX%

Sort Order - Ascending Order

Max Children Per Group - blank

Has anyone found a way to do this other than the suggestion here?
Using the “Record Set Asset Name” isn’t the prettiest solution when trying to group by more than one keyword.



Cheers,

Owen

Did anybody get anywhere with this?