I have main data store entity that comes from CDT, in this CDT has 2 related CDT's. I am currently trying to delete from main data store entity to then have impacts on the related ones. When I made a process model that takes user input that then results in "delete from data store entities" node to delete, it was working for a few unique identifiers before not working anymore. It has ConstraintViolation as the error that it's giving. I am just trying to clear all of the data that are within my DSE's but keep the structure there.
Discussion posts and replies are publicly visible
adamn696785 said:I am just trying to clear all of the data that are within my DSE's but keep the structure there.
If you try to clean up your DB tables, why not directly from the DB UI?
Its better to delete from database directly using sql queries. Delete rows from child tables first then the main table rows.
Thank you, I was unsure if the data would've stuck in Appian and be outdated but that worked