hello team,
I have a grid where there is a column status and we need to disable selection for the rows whose status is completed
using a!foreach() i am able to filter all the status column
code:-
local!data:status:Completed,clientID:1,productName:Treasury Net,clientName:SAUL BERG,taskCompletedDateTime:,taskUpdatedDateTime:1/13/2020 5:50 PM PST,taskCreatedDateTime:9/10/2019 6:53 AM PDT,createdBy:,owner:vputchal,taskAction:Approve,taskStatus:Approved,wfExecAuditID:1447,taskName:Pre-Operations Perform-Validation Steps,wfFormTaskInstanceID:268460627,wfTaskAuditID:3]; [status:Completed,clientID:1,productName:Treasury Net,clientName:SAUL BERG,taskCompletedDateTime:,taskUpdatedDateTime:1/13/2020 5:50 PM PST,taskCreatedDateTime:9/10/2019 7:07 AM PDT,createdBy:,owner:vputchal,taskAction:Approve,taskStatus:Approved,wfExecAuditID:1448,taskName:Pre-Operations Perform-Validation Steps,wfFormTaskInstanceID:268460768,wfTaskAuditID:4]; [status:Completed,clientID:1,productName:Treasury Net,clientName:SAUL BERG,taskCompletedDateTime:,taskUpdatedDateTime:1/13/2020 5:50 PM PST,taskCreatedDateTime:9/10/2019 7:07 AM PDT,createdBy:,owner:vputchal,taskAction:Approve,taskStatus:Approved,wfExecAuditID:1448,taskName:Pre-Operations Perform-Validation Steps,wfFormTaskInstanceID:268460768,wfTaskAuditID:5]; [status:Completed,clientID:1,productName:Treasury Net,clientName:SAUL BERG,taskCompletedDateTime:,taskUpdatedDateTime:1/13/2020 5:50 PM PST,taskCreatedDateTime:9/10/2019 7:07 AM PDT,createdBy:,owner:vputchal,taskAction:Approve,taskStatus:Approved,wfExecAuditID:1448,taskName:Pre-Operations Perform-Validation Steps,wfFormTaskInstanceID:268460768,wfTaskAuditID:6]; [status:In Progress,clientID:1,productName:Treasury Net,clientName:SAUL BERG,taskCompletedDateTime:,taskUpdatedDateTime:1/13/2020 5:50 PM PST,taskCreatedDateTime:9/10/2019 6:53 AM PDT,createdBy:,owner:vputchal,taskAction:Approve,taskStatus:Approved,wfExecAuditID:1447,taskName:Pre-Operations Perform-Validation Steps,wfFormTaskInstanceID:268460627,wfTaskAuditID:2]
a!forEach( items: index( index( local!data, "data", {} ), "status", {} )
from above code I am able to find (Completed; Completed; Completed; Completed; In Progress)
now in disable parameter i have written
disabled : a!forEach( items: index( index( local!data, "data", {} ), "status", {} ), expression: if( fv!item[fv!index] = "Completed", false, true ) ),
but it is disabling all the rows and not just completed once
screenshot attached
Discussion posts and replies are publicly visible
In the legacy paging grid it's not possible to disable rows individually, and it appears that's what you're using. What Appian version are you on?
never mind, I am using validation as to whenever the selected identifier status is completed show a validation message. Thanks for your response
Thanks for confirming.
And just in case you or anyone else reading this find this helpful, the "new" paging grid available in Appian 19.2 and later, allows you pretty easily to disable selection on individual rows (and makes a bunch of other things better & easier too).