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?
Discussion posts and replies are publicly visible
Hi -
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))
Finance
In your case, you want change:PV -> local, "Finance" -> "12345",.department -> .employeeId