I want to use SQL to export a list of data without having to make a spreadsheet every time.
I asked for “SELECT LIBRARY_PART_NAME, parameters FROM objects” ->works fine, but as soon as i want to look for just one parameter f.e. “NAME”
“SELECT P.Library_part_name , OP.name FROM Objects P, objects.parameters OP”
I get an error: unexpected token
grrr. does anyone has a documentation of usable SQL in Archicad? I tried to use Count and group.
” SELECT LIBRARY_PART_NAME, OP.PARAMETERS.NAME, COUNT (OP.PARAMETERS.VALUE) FROM FLAT (OBJECTS, PARAMETERS) AS OP
WHERE LIBRARY_PART_NAME=’Arbeitsplatz 001′ AND OP.PARAMETERS.NAME =’MA 52′
GROUP BY OP.PARAMETERS.NAME ”
But it doesn’t work. Error ” the function COUNT is not defined ” OR ” unexpected token: GROUP ” Pleas help! I just want to have this short way to count different objects when I’m asked without the need of spreadsheets all the time!
Is there a way to export all generated data and put them into a database where I can use proper SQL? Maybe directly AC -> Database without an csv. in between….