REST: Building dynamic reports(flexible queries) with properties - how?

[tonyy]

At the moment the only way I see to execute tailrored query is to:

 

1. Apply PATCH method to existing report parameters ( which in turn are used by query) E.G. In report unit default CustomerId = 0, we send patch values which change existing parameters to say CustomerId=5 which in turn changes query WHERE clause.

2. Then I ask for report unit execution.

This however invites troubles for dirty reads etc. when multiple clients try to do these two operations.

Question is whether this is the only way and whether there is better approach.