Skip to main content
swapnar6405
February 17, 2023
Question

Readonly Grid, Delete functionality

  • February 17, 2023
  • 7 replies
  • 0 views

Hi,

I have an interface with a read-only grid. I am loading the data into read-only grid using RECORD TYPE and also I have used selectable, selectionValue, selectionSaveInto properties.

I would like to implement delete functionality, where I need to allow multiple rows to be selected and click on "DELETE" button so that those selected rows of data should be deleted from the database table.

7 replies

amans0009
February 17, 2023

go through this  - delete from data store entity here you can find two ways   
you can use a process model - > on saveinto parameter of "DELETE" button you can start a process and pass parameter(selected rows to be deleted) 
or you can use direct expression in interface also

jasonb1005
February 17, 2023

A solution could be to have the selectable rows populate an list with the row identifier. Then use that list as the input for a multinode instance in a process model to delete the desired rows based on the IDs

harshitb6843
February 17, 2023

There are 2 ways of doing it and you can decide based on your requirement. 

  1. Store all the selected row's identifiers in a variable and then use a!deleteRecords directly from the interface in a dynamicLink's saveInto. 
  2. Store all the selected row's identifiers in a variable and then start a process on dynamicLink's saveInto in which you call the same smart service.

Now if you want to generate the memory footprint and so some more operations in addition to deleting the data, you can use the second option or else first option should be fine. 

swapnar6405
February 17, 2023

I am trying with the option-1, but I did not find a!deleteRecords.

I am using version 21.4, I am not sure a!deleteRecords is available after 21.4 version.

amans0009
February 19, 2023

you can use a!deleteFromDataStoreEntity [emoticon:c4563cd7d5574777a71c318021cbbcc8]

gayathris111098
February 17, 2023

This is not exactly what you are expecting. But this implementation can give you some idea for your usecase implementation.

[View:https://docs.appian.com/suite/help/22.4/recipe-use-selection-for-bulk-actions-in-an-inline-editable-grid.html]