Static values in Serverconnect Database Query not sorting

I trying to set the paged query $GET variables working from manual/static entries and not using a form input within the server connect properties on a page:

Came across and was able to make it work:

https://community.wappler.io/t/multiple-sortable-with-dropdown-no-table-generator/31737

But it’s not what I need. I want to manually type the field name for sort and ASC for direction. It’s not working, the data is presented as it’s in the database without requested sorting.

Thanks in advance,

Hi.
From the screenshot, it seems like you have put in a BINDING instead of a STRING.
The value should be something like 'markerNumber' and 'ASC'.

Thanks Sid -

I am attempting to bind the markerNumber field and and have the data sorted ascending.

I used the datapicker to attach the field name. I tried typing directly into the code - still no luck.

I have tried just typing the ASC no double or single quotes work.

If its a field, then the binding looks correct. You just need to ensure that this value is actually available. The pickers still have edge cases where it fails to show correct bindings.. although it is much improved.

Typing asc in the properties panel should work fine. No need to go into data picker for that.

Confirmation to doing something correct is appreciated :slight_smile:

Looks like this is one of those edge cases. I’m tried various combinations and still no result. I’m fortunate the sorting application is limited to two fields so I just created a second API.

Workarounds - developer skillsets and applications :grin: