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