Discuss.FOLIO.org is no longer used. This is a static snapshot of the website as of February 14, 2023.

order by the column as Integer type

judelawlee
27 Aug '19

Hi,
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.

julianladisch
27 Aug '19

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