Retrieving selected database columns

[RobertJay]

My database contains hundreds of columns, but let's assume just three (e.g. field1, field2 and field3). What would the service query be to retrieve just field1 and field3. Unless I just missed it, the query docs I looked at did not seem to cover that situation. Thanks very much.

[Tooba Atif]

Have you tried this method?
http://docs.appery.io/tutorials/build...

[RobertJay]

This doesn't seem to be helpful. What I was hoping for was a string I could build at run time to use in the query to have it respond not with all database columns, but just those I was interested in at the moment. It would be similar to a "where" value of e.g. {"field1": "120010002004"} which would limit returned records to those where field1 = "120010002004". But in this case it would be a query that returned records with respect to only a portion of the database fields regardless of any record-filtering. In other words, is there some way of using JavaScript for NOT returning all database columns to save bandwidth?

[Yurii Orishchuk]

Hi Robert.

Unfortunatly currently there is no way to select fields to be returned.

So all of your fields would be returned.

If you have a lot of data and want to decrease it by useless you can create server code which would be translate request to the api, recieve data from api, decrease it and back to the cient.

Regards.

[RobertJay]

Thank you Yurii.