Need help with sorting result by descending order

Need help
1

hi , I am trying to figure out how to get result from nocoDB search to be sorted in descending order.
I have made a search action that give me several results. all by ascending order of the ID.
what I would like is to take the last result at every search action (which is the highest ID number) and use it in another action.
if I have the results in descending order then I can simply use the first result /output every time. I have this sorting option but it doesnt give me the flexabiltiy to change the initial result to descending order.
image

any suggestions? maybe a workaround ? how to extract the ID of the latest found result so I can use it in the next action .

2

Hello @igalg2024, you can use the -Id field in the Sort property and set the limit property to 1 to fetch the ID with the highest number, as shown in the image.

image
image717×297 15.9 KB

1 Like
3

awesome thanks! it works exactly as I want it now :slight_smile:

4

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.