GroupJive Events custom fields

Sorry if I was not explaining very well...

All storage and display for GJ Events is working very well and I correctly display a formatted string depending on the value stored.

So for group owners with events everything is perfect.

The question was referring to a CB field used to display subscribed events by another user.

The field is a query dropdown field with single select and the query is :
then the options are
The problem is to get the correct formatting output for params in the value displayed in the drop down.

For now it shows the grouping as {"dropdown":"10"} and I cannot see how to format this in the CB field.

Any idea ?

You won't be able to generate a query select from a params column. The params column is always null or a JSON string. CB Query Field doesn't have any specific behavior for handling JSON stored params columns.

That's not what I wrote, we generate the query from the id/title columns and want to make a grouping by params.

This is working very well except that the output displays as I mentioned {"dropdown":"10"} and I then need to change {"dropdown":"10"} to show Category 1 for instance.

Can I do this with layout substitution and how ? knowing that this is only the group name that I want to substitute

You can't group by a value in the params column. CB Query Field has no functionality to parse out JSON stored params columns. That's why you're getting the raw JSON display of {"dropdown":"10"}.

Ok maybe a future feature ?

Any other ideas for now ?

Even if it was accessible with params_dropdown it'd just output 10 instead of Category 1, which will likely be supported in a future release but doesn't really solve your issue. I don't have a solution aside from using a Code Select provided by CB Code Field which lets you use PHP to output a dropdown selection instead of strictly SQL.