XPath constraint - 2 conditions

1
I'm struggling with how to do the following: (there is an association 1-* as a User can rent more than 1 cars) [Rencars.Cars._User=$currentUser] AND [Rencars.Cars._User.CarReturned is empty] //pseudo code The first condition is fine and identifies associated user but I need to select only records where particular field is empty.
asked
2 answers
2

Michael

I assume you are selecting from the Cars entity. If so, try something like this:

[Rencars.Cars._User=$currentUser and CarReturned = empty]

Since CarReturned is an attribute of the entity you are selecting from, there is no need to qualify it.

Hope that works - Mike

answered
0

You can do this using the NOT operator, see https://world.mendix.com/display/refguide4/XPath+not

answered