delete the data from record

 Hello,

I'm a beginner, I have created a form and connected it to the data store and successfully writing the data to data store. Now in records I have many duplicates, I hate to delete them. How to do it? I've also come across using a  Delete from "Data Store Entities" but in my CDT I have an ID and primary key for it. But its never showcased under records. Thus how to delete a record now. 

Please refer to below screen shot

 

None of them are represented by an ID, but in Name hyperlink there is the Summary, though how can I delete the record. It should also be totally deleted from mysql DB.

Any suggestion would be highly appreciated...!!

  Discussion posts and replies are publicly visible

Parents
  • Hi,

    Not sure if I understood your requirement correctly, For the duplicates to not show up on the record, you can delete it from the mySQL DB right. Whichever table/entity is populating the record, that should have the primary keys, you can get that using a query entity and pass it into a process model to delete them via the Delete from data store entities.

    Thanks.
Reply
  • Hi,

    Not sure if I understood your requirement correctly, For the duplicates to not show up on the record, you can delete it from the mySQL DB right. Whichever table/entity is populating the record, that should have the primary keys, you can get that using a query entity and pass it into a process model to delete them via the Delete from data store entities.

    Thanks.
Children
No Data