The field is there. In fact the query runs, but it no longer sorts by the aggregate field - well it does, but by an additional field which of course means the sort order is incorrect.
The change I made was to add the aggregate (count) field manually, here:
. and that worked. Now it doesnât - [quote=ânshkrsh, post:17, topic:13025, full:trueâ]
that warning looks like in DB you do not have that field any more.
and it shouldnât look like that. it should look proper like a modal - not all curled up.
[/quote]
an additional field is added to the ORDER BY statement, perhaps because Wappler doesnât recognise the field I added, so it includes what it considers a valid value. I imagine another result of not recognising the field is the broken query builder display.
In any case, it would be really good if this were fixed. Itâs one of those strange issues which is potentially a serious omission, but hasnât been acknowledged or commented on by the Wappler team (AFAIK).