GROUP BY in sql query

[Anonymous]

Hello !

Try to create some simple query.
I need to sum some parametrs and use GROUP by command
But when I try to execute - fail.

unexpected token: GROUP в [строка: 1, столбец: 70]

My query:

select h.PARAMETERS.name   from flat( OBJECTS,PARAMETERS) as h 
group by h.PARAMETERS.name 

It is working?

And one more question.
How I can storage queries in project ?

[Mihaly Palenik]

Hello,

maurice72 wrote:
I need to sum some parametrs and use GROUP by command
But when I try to execute - fail.

as Ákos Somorjai said in this topic (archicad-talk.graphisoft.com/viewtopic.php?t=57029),
the SQL queries are not supported any more officially (the last supported version was ARCHICAD 18 ), so don't rely on them.

maurice72 wrote:
How I can storage queries in project ?

Could you explain exactly what would you like to store in project file? Just the string of queries or something else?

Best,
Mihály