Conditional Delivery of Upserted Objects¶
Description¶
This operation allows registering a conditional event listener for a specific data table. The condition is expressed using the where clause syntax. The listener is triggered only when the upsert operation is invoked and the specified condition is met. The event listener will receive only those objects which are being upserted in the database.
Method¶
where:
| Argument | Description |
|---|---|
whereClause |
Optional parameter. String value. Sets the condition for an event listener which gets triggered every time the condition is met when the upsert operation is invoked for a specific data table. For more information about the whereClause syntax, see the Condition Syntax section of the guide. |
Return Value¶
None.
Example¶
The example below registers a new event listener in the "Person" data table. The listener is triggered when the where clause condition is met, specifically when a new object is updated/inserted in the data table and the value in the "age" property is greater than 30.
Codeless Reference¶
where:
| Argument | Description |
|---|---|
id |
Unique identifier of the new event listener. |
table name |
The name of the data table where a conditional event listener must be registered. |
where clause |
Optional parameter. Sets the condition for an event listener which gets triggered every time the condition is met when the upsert operation is invoked for a specific data table. For more information about the where clause syntax, see the Condition Syntax section of the guide. |
object |
When a listener gets triggered, the Backendless delivers a callback object containing the upserted object to the listener. |
The example below registers a new event listener for the "Person" data table. The listener is triggered when the where clause condition is met, specifically when a new object is upserted in the data table and the value in the "age" property is greater than 30.
Assume the where clause condition is met, and the Codeless logic below executes a custom block of code; First the following sentence is printed: "Upsert operation has triggered the listener.", then the value of the property objectId is retrieved from the object variable and also gets printed.
