I have an array of of CDT which have local data stored in it. Now I have to fetch data from the array based on some certain condition.For example, I have a CDT named "Employee" with fields firstName, lastName and employeeId. Now I want to get the firstName of the employee whose employeeId is 12345.How to achieve that?
Perhaps this pattern will help:
index(pv!employees.firstName, wherecontains("Finance", pv!employees.department)) returns the first names of all employees with their department field set to Finance or an empty array if none have it set to Finance
index(pv!employees.firstName, wherecontains("Finance", pv!employees.department))
In your case, you want change:PV -> local, "Finance" -> "12345",.department -> .employeeId
Discussion posts and replies are publicly visible
© 2020 Appian. All rights reserved.