Forum | Appery.io

Hi!

I am trying to return the most recent record from my database by sorting with _updatedAt and putting a limit of 1. I am not sure I have the correct syntax.

I am placing the javascript below in the where clause of the database request. It does not seem to function.

Any thoughts on how to get this working?

codereturn '{ $and:[ {"owner":"'+value+'"}, {"sort":"-_updatedAt"}, {"limit":"1"} ] }'; /code

Thanks!

Hello! sort and limit shouldn't be in where parameter, they are separate parameters. Please take a look at the screenshot:

That's not what I see for my service listing. Check out the screen shot from the test section of my query_service set-up. Why is mine different from yours? I do not have a sort or a limit request box.

Hello! You have to add these parameters on Request tab.

I see now. It is necessary to enter the new parameters in the Request section of the service.

Thank you!