order by the column as Integer type

I want to order by the the column as Integer type, but now it’s sorted by string type.
then debug the code and get the cql contain ‘ORDER BY lower(f_unaccent(activityusers.jsonb->>‘number’))’ , replace to “activityusers.jsonb->‘number’” still get the error, please help how to fix this requirement, thanks.

you may use CQL sortBy number/number to trigger number sort:

1 Like