Over the update or any query action how is used the column Condition?? Is any documentation?
It works as a condition, as its name says.
The value will be inserted/updated in the database when the expression used in the condition is true.
This is a wonderful feature - Query Builder would be very much less useful without it. I have some queries which include over a 100 conditions, to enable a range of dynamic queries.
2 Likes
Do you have an example to illustrate?
In this example, there is a keyword search (which searches multiple fields for multiple keywords), and an advanced search for more specfic searches. You can also search within catalogues (via the Catalogues menu). All this is done with a single SC api, created with Query Builder, and a single results page.
2 Likes