Update a db value based on the current value (value +1)?

General
1

Is it possible to do the equivalent of -

update products
set quantity = quantity + 1
where id = 123

Thanks,
Tim

2

Yes, it is. Please see this chapter in the documentation:

https://backendless.com/docs/rest/data_inline_update_backendlessexpre.html

3

Cool. Thanks @mark-piller

Is there a way to add or modify a value if it is JSON?

UPDATE t 
SET json_col = JSON_SET(json_col, '$.name', 'Knut') 
WHERE id = 123

Tim

4

You are welcome. The only supported JSON “update” operations are the ones documented here:
https://backendless.com/docs/rest/data_updating_json_data.html

Regards,
Mark

5

Thanks again @mark-piller