Xpath with a following Count list is not triggering a Count SQL query under water
Hi guys I am doing a little (multiple inner joins) complexe Xpath retrieve with a following count aggregation list, which normally resulted in count without a full retrieve of objects. After some MF and Xpath changes, whereby the Xpath specification is still similar, but in another order, also with a following count aggretion list...I see that is converted under water to a full object retrieve SQL query and not a count query. So I dont get exactyly what did trigger is to do NOT a count query but a full retrieve of objects? Have someone advice? Using OQL is not preferred seens this was working...
You are probably using the list further on. If you do that, Mendix retrieves the entire list, instead of just the count