I'm trying to delete using a delete action inside interface using a stored procedure because I also need to delete related data from other tables. However, I'm facing an issue: the entity is successfully deleted from the database, but it still appears in Appian.
I have a subprocess that runs after the stored procedure to sync all the updated tables, but the entity remains visible in Appian until I manually trigger a sync—after which it disappears as expected.
Does anyone have any idea what could be causing this issue? Any insights would be greatly appreciated!
here u can see the main subprocess sync :
and an example of one subprocess sync:
Discussion posts and replies are publicly visible
hamzas0003 said:but it still appears in Appian
What exactly does this mean?
If you use a separate expression to query data, this expression uses local variables, and you use that expression from your interface, this expression typically caches query results as long as the query parameters do not change. You can alter this behaviour using a!refreshVariables.
Do you call this process synchronously?
-but it still appears in Appian
i mean when i try to delete something it s being delted form db but it remains in appian even if i refresh the page ,it disspaears only when i sync manually the recordtype ,and yes im calling it synchronously.
OK. This is important to know.
This is a lot of chaining. Are you sure you are within the 50 nodes limit?
I do not remember trying to delete data directly in DB, and then trying to remove deleted rows from the synced record cache. I am not sure this is a supported use case and can't find it in the documentation just now.