Hi,
We have a process that calls a stored procedures to modify some data records. These data are used by a SYNC Record Type in the application.
To make synchonize and refresh automatically the RecordType from the Appian application, we added in the process a Smart service (Write to Datastore Entity) that updates a field of the concerned records, this works fine.
Now, we have a stored procedure that cleans the DB (deleting a lot of rows of many tables). So how would you tell to Appian that the data have been deteled ?
(the Record types still display the same data because they did not have been synchonized)
Discussion posts and replies are publicly visible
The way I would do it is have the stored proc update a table and have a process that runs every 5 mins monitoring that table and trigger a write to data store if something pops up.
This might get addressed in 22.2 though. Stay tuned.
True, 22.2 will get you covered with a smart service to be used in a process model and an API endpoint you can call from external to update certain records.