Apps10.
We have a fairly simple lobby element that works fine until we add a GROUP BY entry for it. As soon as that is done we get a “not a group by expression” error when previewing or trying to use the element.
We have tried changing the data field and the data field types but the same error every time.
We have tried doing this with no Order By, just the Group by, and the error remains.
I’m sure it’s something simple but can’t figure it out - anyone have any ideas?
Thanks!
Nick
It looks like the issue is that all of the selected columns (except the one that is a function call) needed to be added to the GROUP BY field. It cannot only be grouped by one field or a subset of them.
So in this specific example we needed to add CATALOG_NO, PART_NO, SOURCE_REF1, SOURCE_QTY, PLANNED_SHIP_DATE, and PLANNED_DELIVERY_DATE to the Group By in the desired order.
Hopefully this helps someone else.
Nick
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.