/
Database Polling

Database Polling

Owned by Akash Kumar Jaiswal (Unlicensed)
Last updated: Aug 13, 2020Version comment

The Database Polling Service is used to check any changes in the data stored in a database table.

Prerequisites

  • Database Info service must be created before creating Database Polling Service.


Steps to create a database polling:

  1. Click Configure > POLLING > Database.

  2. Click Create Database Polling.




  3. On the Create Database Polling window, enter the name and description of the new Database Polling service in the Name and Description fields.

  4. Select the Database Info service from the Database Info drop-down list.

  5. You can create the database event definition by entering an SQL Query or a database trigger command. By default, SQL Query option is selected. Enter the query in the SQL Query field. For example:

    select * from PurchaseOrder where processingStatus='Ready' 

  6. Select Check Condition checkbox if result of the selected query is to be compared with the conditional value.

  7. Select the operator for the query from the Operator drop-down list. Enter the value to be compared in the query in the Value field. The query should return only one record. If the query returns multiple records, then only the first record is accepted. If the query returns one record, then it will compare the value of the first field with the value specified in the Value field.

  8. Alternately, enter the database trigger command in the SQL Trigger field.

  9. Enter the name of Trigger in the SQL Trigger Name field.

  10. Enter the time interval for Polling in the Polling Frequency field. Enter the digit in the Frequency field and select the unit of time i.e. seconds, minutes or hours etc. from the Duration dropdown list.

  11. Enter the expiry time in the Expiry Time field. After expiry time process flow does not poll for data.

  12. Expand the Advanced Properties section and select the Project from Project drop-down list.

  13. Click Save.