Is there any way to make a kind of notWhereContains from a list ?

Certified Senior Developer

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