03.04.2020, 18:48
Does anybody know if the SQL language in LUA scripts for LM5 support inner joins? If "yes", where can I find the syntax?
Example: I want to read all entries from the object log for all objects having a tag called (say) 'MYTAG'
I have already built a script that first uses grp.tag to create a table with all objects and then I loop through each entry in the table and use SQL SELECT from the objectfile.
This works fine, but it would be more elegant to do it all in one SQL SELECT, joining the tables "objects", "objecttags" and "objectlog" (via objects.id, objecttags.object and objectlog.address)
Thanks
Example: I want to read all entries from the object log for all objects having a tag called (say) 'MYTAG'
I have already built a script that first uses grp.tag to create a table with all objects and then I loop through each entry in the table and use SQL SELECT from the objectfile.
This works fine, but it would be more elegant to do it all in one SQL SELECT, joining the tables "objects", "objecttags" and "objectlog" (via objects.id, objecttags.object and objectlog.address)
Thanks