Flowgear SQL Watcher
How do I configure the SQL Watcher trigger in Flowgear? The config options screen does not contain a field where I can enter the actual Query whose results need to be monitored. Here is a screen shot of what I'm seeing.
Also, what is the difference between the "Notify" and the "Poll" options in the "WatchMethod" dropdown?
You'll first create the connection then add an instance of the SQL Watcher to a workflow and select the connection you've just created. There is then a field on the SQL Watcher node in which you can specify the SQL query you'd like to execute.
The Poll option in Watch Method will check the database at the specified WatchPollInterval to check for changes. The Notify method will use Sql Query notification instead https://msdn.microsoft.com/en-us/library/t9x04ed2%28v=vs.110%29.aspx?f=255&MSPPError=-2147217396
- Flowgear send sucess and error response using FgResponseBody and FgResponseStatusCode
- How to return a static/dynamic JSON/XML response in a Flowgear workflow using API binding
- Flowgear Quick Map Results an array typed values in JSON object
- Visibility of custom Flowgear Nodes
- What version of C# is supported by the relevant flowgear nodes?
- Is it tenable to access file metadata using flowgear resources?
- How to deal with arrays in the QuickMap function in Flowgear
- How to get payment percentage from sage evolution database
- How to retrieve the data from Sage Evolution Using flowgear Integration
- Droppoint Error Throws When Testing Sage Evolution Node Connection
- Error not throwing in workflow
- Flowgear endpoint not working
- How to break RegexMatcher loop
- How to make two POST Requests in one session (JSESSIONID)/cookie
- Loop exit not working
- Variable Bar Inputs/Outputs not configurable in HTML5 version
- Flowgear How to send "Any Error" email for a workflow
- When To Use Flowgear Subworkflow
- Flowgear How to map database field to sage evolution userdefine field
- FlowGear Email Watcher Node
- Flowgear SQL Query XML Result
- Flowgear Change default workflow execution time
- Flowgear configurable variable bar for sql query via API
- Flowgear Insert form post data into database
- JSON support in Flowgear's Console
- Flowgear SQL Watcher
- Flowgear access to files on the local file system
- Flowgear running old workflow version