Catch up wih the Appery.io community on our forum. Here you'll find information on the lastest questions and issues Appery.io developers are discussing.
https://forum.appery.io/
I'm using Tiggzi database and I can query my database by using {"ROI":{"$gt":14}}
How can I limit/filter the results of my service :
/[object_id],in]https://api.tiggzi.com/rest/1/db/coll... the application builder?
You tried the query in web console and want to set it up in the service?
yes , I'm looking to show a sub set of the data that I have in my tiggzi database in the app screen base on criteria
To test the service, simply enter {"ROI":{"$gt":14}} for where request parameter.
When you map the service, set this up in JavaScript function:
code
return "{'ROI':{'$gt':14}}"
/code
you could also replace 14 with the 'value' mapped from the page.
I am attempting something similar. When I enter this in the tiggzi db Query ; {'mycat':{'$gt':'C'}}, I get the proper results.
Now in the restservice request parameter, I add where as a request parameter and {'mycat':{'$gt':'C'}} as default value. When I hit Test, it does not provide the same results. What am I missing? further to your suggestion above to add this to Javascript function. I am mapping this to a label in a grid; so does the javascript go to the grid javascript or the label javascript. I tried at both places and did not have any success.
This should work:
Request name: where
Value: {'mycat':{'$gt':'C'}}