Hi All,
Below is my Array.
{ { Id:"A", Value: 123 }, { Id:"B", Value: 345 }, { Id:"C", Value: 678 } }
1.I want to check if list contains items with Id apart from "A" and "B".
2.Also I want to filter the items whose Id is not equal to "A" and "B".
Discussion posts and replies are publicly visible
You can implement that using the filter() function, or foreach(). And as this is a very frequently asked question, you will find plenty examples in other conversations.
If you could help in writing an expression would be appreciated.
Just like I said, this forum has a search engine that helps you to find threads like this one: https://community.appian.com/discussions/f/rules/29517/problem-filtering-null-values-from-record/117017#117017
Ok you were referring this. Now i understood. Thanks It works!!
a!localVariables( local!array : { { Id:"A", Value: 123 }, { Id:"B", Value: 345 }, { Id:"C", Value: 678 } }, local!idsnotIncludedforfilter :{"A","C"}, local!filteredData: remove(local!array,wherecontains(local!idsnotIncludedforfilter,touniformstring(index(local!array,"Id",{})))), local!filteredData )