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!