Filtering & sorting query dynamically

Thomas Bonfils

Hi Guys,

I would like to let my user filtering my query by firstname, lastname and choose which sorting (descending or ascending)

I need to chain condition but i don't know how to do it

If filter = firstname & sort = descending
Then query with firstname descending
Else query with firstname ascending

OR

if filter = lastname & sort = descending 
Then query with lastname descending
Else query with lastname ascending

Etc etc..

Thanks for your help

Thomas

Sean Montgomery

You can handle this in your frontend and pass the configuration to xano.

https://docs.xano.com/working-with-data/functions/database-requests/query-all-records/external-query-manipulation/external-filtering

It is also possible to do this logic in xano but may be easier in your frontend depending on the controls you allow in your UI. Definitely give this a try.