Is there a SELECT command in REST like in SQL ?

[bahar.wadia]

I only want to return certain fields from a REST query. Is there a SELECT command/parameter like in SQL, to limit the fields/columns that are returned.

Thanks in advance.

[maxkatz]

There is no option right now to return only specific columns when using Appery.io database. You can invoke the service in Server Code and then filter and only return the data that you need to the client.

[bahar.wadia]

How do I do that?

Can you provide me with an example.

Thanks

[maxkatz]

https://getsatisfaction.com/apperyio/...

[bahar.wadia]

Thank you this was very helpful. Works like a charm!

[bahar.wadia]

Thank you this was very helpful. Works like a charm!

[bahar.wadia]

I believe Appery use Mongodb. Correct?

I found the following in their reference documents. The "Projection" parameter allows selection of fields, like SELECT in SQL. This eliminates the need for me to run server side scripts to emulate SELECT like behavior, to strip data server side, to reduce payload and speed up the app/process.

http://docs.mongodb.org/manual/refere...

1) Can you please confirm Appery support this?

2) How would I implement this in Appery?

Thank you.

[maxkatz]

No support for this yet.

[bahar.wadia]

This would be very valuable. Any idea how soon this could be made available?

Can we make a community request to raise the level of importance?

[maxkatz]

I already added it to our todo list. You can also create an Idea topic, other users can vote/comment on it.