Forum | Appery.io

How can I update columns of some registered users (for example all users who's favorite color is blue get 10 points) in the database? In SQL I would use an UPDATE statement (UPDATE users SET user_points = 10 WHERE favorite_color = blue)

Hello,

This doc should help:
http://docs.appery.io/documentation/b...

Thanks for your quick reply! Basically I want to update points of users who answered a question correctly.
1.But I cannot update columns of several rows with a 'where' parameter (for example all users who's favorite color is blue get 10 points).

1. What default value do I have to type in the Database Service if I want to increase the number of a column? When I type in +25 it sets the number to 25 instead of increasing it by 25.
2. And how can I import the Users collection service? I can only import custom collection services.

Hi Bil,

You can update objects only one by one: http://docs.appery.io/documentation/b...
You can't import collection 'Users' - just paste records one by one.

Why is that? So is there any other way how I coud create a highscore and update the points of every user who answered correctly? I can't update by one if there are for example 100 users who answered correctly and 100 who didn't.

You can do it just one by one. E.g. read list of users and call update service for each one.