appmixer.mssql.db.WatchRows
1.0.0
Public
| Field | Type | Description |
|---|---|---|
| Storage | select | Select a data store. The data store will be used to store data streamed from mssql so that we can compare them later to detect new/updated rows. If you do not select a data store, one will be automatically created for you when the flow starts and deleted when the flow stops. If you do select a data store manually, you are responsible for clearing/deleting it when you don't need it anymore (note that the data in the data store is populated automatically, so any data left in the store affects the next flow run). |
| SQL Query | textarea | Enter an SQL query. |
| ID field in query result | text | A unique field from the query result set that will be used to check for new vs existing rows. |
| Reference Fields | text | A comma separated list of fields from the query result set that will be used to check for changes in rows. If you do not provide Reference Fields, any change in any field is detected. |
| Field | Type | Description |
|---|---|---|
| Event (insert/update) | - | |
| Updated Row | - | |
| Old Row | - | |
| New Row | - |