Question

XPath expression -where id in( 1,2,3,4)- possible?

1

Hi everybody, In SQL I often used a where-clause like this SELECT * FROM questions WHERE id in(1,4,22,29) Is this construction (or something similar) also possible in Mendix-Xpath-constraints? I sometimes (often in java-actions) need to retrieve the mendix-records with a specific ID (or all records exept those). Of course it is possible to do the following in xpath [id=1 or id=4 or id=22 or id=29] but I wonder if there are other (pehaps better performing?) ways.

asked 2011-08-02

Roberto Postma

1 answers

Michel Weststrate · Accepted Answer · 2011-08-02

I expect that an 'or' query on the indexed 'id' attribute yields the same performance as a native 'in' query. The information they have to look is basically the same.