Search code examples
databasecloudant

Modify and delete document in Cloudant IBM Database

Is it possible to modify document or delete in Cloudant Database by query?

Solution

  • I assume the questioner is looking for equivalent functionality to SQL's:

    UPDATE db SET x = 10 WHERE y > 100;

    If that is the question then the answer is that Cloudant does not have such functionality, only an atomic update operation.

    The equivalent of the UPDATE statement could be achieved by combining a call to the Cloudant Query API and making updates using the bulk API.

    Another option is to use the couchtato iterator tool which allows bulk changes to be made to Cloudant databases.