Hi,
If I need to get the vehicles Data where ID in {1,2,3}, I can do this :
index( ri!vehicles, wherecontains( {1, 2, 3}, ri!vehicles.id ) )
But is there any way to do the same thing with a negation (a kind of notWhereContains) ? I mean I need to get the vehicles data where ID not in {1, 2, 3}.
Of course, I can then use a foreach to get the correct data, or create an exclusion list items, to apply the whereContains on the latter,
but is there any other way to do it with a single simple instruction ?
Discussion posts and replies are publicly visible
You can also simply wrap it into a not().
A foreach() is not directly meant to be used for filtering as it creates a list with an output item for each input item. This is heavily discussed here in case you want to explore that.
Stefan, can you modify my example with a "not()" please ? I'm not sure to see what your mean
I think I was reading your code too fast. Does not make any sense ...
ah ok, that reassures me ;-)