A Lobby element's data source works fine until a GROUP BY is added, at which point it fails with a "not a group by expression" error, even after trying different fields.

All FAQ questions / Platform, Aurena, and customization

Answer

Every selected column that isn't itself an aggregate function call needs to be included in the GROUP BY clause — grouping by only one field, or a subset of the non-aggregate columns being selected, produces exactly this error; list all the plain (non-aggregated) selected columns in the GROUP BY, in the same order they're selected, and the error resolves.

Documentation-based answer. Confirm the product and release before applying it. This answer has not been verified in an IFS environment.

← Browse Platform, Aurena, and customization questions