Deleting all rows using delete from data store entity

Hi,

I am trying to delete all the existing rows from the data entity using delete from data store entity smart service. Can anyone please suggest me what to include in identifiers if we want to delete everything without specifying all the identifiers?

Thanks

Yeswanth.

  Discussion posts and replies are publicly visible

Parents
  • Hi ,

    I found a way to delete multiple records in Appian. Below is steps for same:

    1. Create a process model 

    2. Refer attached image for Process Model

    3. Process Model logic: pass 1 input parameter to PP, and then configure delete operation, post increment unique PP value using script task, then check using OR that if PP value is max unique value in table, and accordingly again assign to delete

    4. Run process model in debug mode

    5. It will empty all records 

Reply
  • Hi ,

    I found a way to delete multiple records in Appian. Below is steps for same:

    1. Create a process model 

    2. Refer attached image for Process Model

    3. Process Model logic: pass 1 input parameter to PP, and then configure delete operation, post increment unique PP value using script task, then check using OR that if PP value is max unique value in table, and accordingly again assign to delete

    4. Run process model in debug mode

    5. It will empty all records 

Children