Concatination

Hi.

Does anyone know how to do CONCAT in Connectivity6?

for ex. in read data in Fields to retrieve:
CONCAT_WS( ' ', Haupt.gattung , Haupt.art , Haupt.autor):Article.title

and in VIEW table list:
Article.title:Artname

Hi Fredolino,

Thank you so much for this. One question. Where did "Artname" from you string, "Article.title:Artname" came from?

Also, I notice in your example, you're using "Haupt." inside "CONCAT_WS()" and "Article." outside. Are they separate Models from separate "Read Data" instances?

:-) "Artname" is only the Aliasname in this example.

So, effectively, it can be anything and doesn't have to be someone from any thing created or established somewhere else before?

You can name the alias whatever you want

Thank you very much, Fredolino. It is it working.

BTW, any idea on formatting DateTime (YYYY-MM-DD HH:mm:ss)? I would like 2023-02-28 08:32:52 to read as 28 Feb 2023? It would be nice to have a calendar for updating the same which would save it in the DB in the YYYY-MM-DD HH:mm:ss format.

YYYY-MM-DD
{date:d.m.Y$(var:Model.datefield)}
= 00.00.0000 format