libreoffice Text Aggregator

Question

Is it possible to concatenate text from an aggregate function in LibreOffice Base. For example:

column1	Column2	Column3
1	Hello	23
2	World	27

The function would then return "Hello, world"

Answer 1

You didn't say which database you are using.

Please look at the statusbar at the bottom left. If you see something like this, then the built-in Firebird database is being used.

In this case, you can use the LIST() aggregate function. Something similar to

SELECT LIST("Column2") AS string_agg FROM "MyTable"

If you have created an HSQLDB database, you can try to tame the GROUP_CONCAT() function

In case you are using a different database, check the documentation for that particular database - there are similar functions in each SQL dialect, but they differ in syntax.