michael62 - Wednesday, February 1, 2012 10:21 AM:
Hi,
A question on AML queries: I have an item that has a property "internal" that can be 0 or 1, but is not a required field. Now I want to get all items, where this flag is not 1. Hence, Ithought that either <internal condition="ne">1</internal> or <not> <internal>1</internal> </not> would return all the items I'm looking for. But it doesn't, as it does no list the items, where the internal flag is not set at all. It requires a query like this <or> <internal>0</internal> <internal condition="is null" /> </or> to get the full list. Is this intended behaviour? Is there a better or more efficient way to request all those items? Any comments appreciated. Cheers, Michael
Brian - Thursday, February 9, 2012 5:57 AM:
Hi Michael,
That query is correct.
Remember that this is only the AML being sent to the server. In turn this is interpreted into an SQL statement so this is not an inefficient query.
Since XML normally only contains the data where there is data then you have to ask for the "is null" values explicitly.
Cheers,
Brian.
michael62 - Thursday, February 9, 2012 12:19 PM:
Hi Brian,
thanks for the info. IF that's the way to, I'll just do it. :-)
Cheers, Michael
