Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
6 replies
Subscribers
5 subscribers
Views
2590 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Process
Let's say we are inserting a new row in DB table. Is it possible to create a
Manikandan Ganapathy
over 11 years ago
Let's say we are inserting a new row in DB table. Is it possible to create a process in Appian, whenever a new row gets added to a DB by any means? Is it achievable?...
OriginalPostID-105402
OriginalPostID-105402
Discussion posts and replies are publicly visible
Parents
0
Michael Tan
Appian Employee
over 11 years ago
One option for the listener process is to launch a process model periodically based on a timer. The first node will be to query this database table for any new rows (which could be denoted by a Boolean flag) and launch a process for each new row. After the rows have had their processes generated you can update the Boolean flag in the table so the next time the poller runs it will only create processes for new table rows. The frequency at which the process runs can be determined in the timer node.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Michael Tan
Appian Employee
over 11 years ago
One option for the listener process is to launch a process model periodically based on a timer. The first node will be to query this database table for any new rows (which could be denoted by a Boolean flag) and launch a process for each new row. After the rows have had their processes generated you can update the Boolean flag in the table so the next time the poller runs it will only create processes for new table rows. The frequency at which the process runs can be determined in the timer node.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data