appmixer.mssql.db.DeletedRow
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 deleted 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 deleted rows. |
| Field | Type | Description |
|---|---|---|
| Deleted Row | - |