)]}'
{"doc/source/webapi/v2.rst":[{"author":{"_account_id":10987,"name":"Igor Degtiarov","username":"tovstun","inactive":true},"change_message_id":"2c8c0a279d86d8302425c6045de56d5dabb3d661","unresolved":false,"context_lines":[{"line_number":191,"context_line":"operators can be used: *and* *or* and *not*. The field names are validated"},{"line_number":192,"context_line":"against the database models. See :ref:`api-queries` for how to query the API."},{"line_number":193,"context_line":""},{"line_number":194,"context_line":".. note:: The *not* operator has different meaning in Mongo DB and in SQL DB engine."},{"line_number":195,"context_line":"   If the *not* operator is applied on a non existent metadata field then"},{"line_number":196,"context_line":"   the result depends on the DB engine. For example if"},{"line_number":197,"context_line":"   {\"not\": {\"metadata.nonexistent_field\" : \"some value\"}} filter is used in a query"}],"source_content_type":"text/x-rst","patch_set":1,"id":"fa1b9901_57debf6d","line":194,"updated":"2015-08-26 09:03:13.000000000","message":"it would be nice if you make improvements in all appropriate places.","commit_id":"2df0db5b934149baaddae017edfa7867b137722a"},{"author":{"_account_id":10987,"name":"Igor Degtiarov","username":"tovstun","inactive":true},"change_message_id":"2c8c0a279d86d8302425c6045de56d5dabb3d661","unresolved":false,"context_lines":[{"line_number":196,"context_line":"   the result depends on the DB engine. For example if"},{"line_number":197,"context_line":"   {\"not\": {\"metadata.nonexistent_field\" : \"some value\"}} filter is used in a query"},{"line_number":198,"context_line":"   the MongoDB will return every Sample object as *not* operator evaluated true"},{"line_number":199,"context_line":"   for every Sample where the given field does not exists. See more in the Mongod DB doc."},{"line_number":200,"context_line":"   On the other hand SQL based DB engine will return empty result as the join operation"},{"line_number":201,"context_line":"   on the metadata table will return zero rows as the on clause of the join which"},{"line_number":202,"context_line":"   tries to match on the metadata field name is never fulfilled."}],"source_content_type":"text/x-rst","patch_set":1,"id":"fa1b9901_975457c6","line":199,"range":{"start_line":199,"start_character":75,"end_line":199,"end_character":84},"updated":"2015-08-26 09:03:13.000000000","message":"ditto and further if it is needed","commit_id":"2df0db5b934149baaddae017edfa7867b137722a"}]}