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
That would indicate that something is perhaps wrong with your sync expression. Can you share it?
this is the main sync procees configuration :
adn this is one how one of it s sub procees expression:
getIds Output:
index( rule!SLC_getProgettoDiConnessioneByFilters( idRegione: pv!idRegione, pagingInfo: a!pagingInfo( startIndex: pv!startIndex, batchSize: cons!SLC_INT_BATCH_SIZE_CSV, sort: a!sortInfo(field: "id",ascending: true) ) ),"id",{} )
What is that rule querying? Is it querying the record type or your database directly (like through a!queryEntity())?
Why are you doing a query to find the ids that were removed?