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!
OR:
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….
AC 20, Win 7, mac