How can I sort by different things depending on which select menu option is clicked?

[Ellen Schlechter]

I followed those steps exactly but it didn't work. I noticed that you have some sort of JS that you run. Do I need that?

Also, no erros in the console.

[Ellen Schlechter]

Does anyone have any advise?

[Illya Stepanov]

Hi -

You need to have only one parameter.
Appery.io DataBase doesn't know about your SortA, B , or anything else, it works with its own implementation "sort".
So, you need to change value for parameter sort every time you changing sort order in your select menu.

[Ellen Schlechter]

How exactly do I do that?

[Alena Prykhodko]

Hello Ellen,

First you should think this logic, then sort data http://devcenter.appery.io/documentat...

[Ellen Schlechter]

I have this sort parameter so if I have the column names in the properties of the select menu, then map it to the sort column, it should work, right? Would I do it in the before send or the success??

[Yurii Orishchuk]

Hi Ellen,

show us datasource "before send" mapping and screen shot of actual service request(where we can see request parameters and headers).

Bruce, Great explanation

Thanks & regards.

[Ellen Schlechter]

This is the mapping:

This is how the variable is set:

These are the properties:

Then this is the service request:

[Yurii Orishchuk]

Hi Ellen,

You use wrong parameter name: "Sort" instead of "sort".

See more info in documentation: http://devcenter.appery.io/documentat...

Details: http://prntscr.com/61kg77/direct

Regards.

[Ellen Schlechter]

I tried that and now it thinks about what it wants to do but it still doesn't sort based on what is selected.