Base query functions and Group By not available in V6.2.1.2

Tried to create a Base Query and when trying to select a function there was only COUNT in the pulldown list.

Also, couldn’t see how to group fields.


Do not see any problem with LO on Mint 18.3 with either Firebird embedded or HSQLDB embedded.

There is a problem in this regard with SqLite → Bug 114602 - Query-Editor: No functions available for Sqlite 3 odbc.

So a lot depends upon what you are using as you haven’t specified.