Additional field in query service

[Mantas Kamarauskas]

Hi,

I have collection with columns A, B, C. While retrieving data with query I would like to have additional column D, which value is B+C. Also, D column I want to use for retrieved records sorting.

Is that possible? I can not find appropriate example how can I add additional field to query and make calculations in that field.

[Evgene Karachevtsev]

Hello Mantas,

In this case, you should first get the data using read_service:
http://devcenter.appery.io/documentat...
carry out the necessary calculations and update data using update_service:
http://devcenter.appery.io/documentat...