Xpath with a following Count list is not triggering a Count SQL query under water
1
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...
asked
Rapido
1 answers
6
You are probably using the list further on. If you do that, Mendix retrieves the entire list, instead of just the count