Get list of objects

[Trond Hoyem]

Hi

I have a need to get a list of objects inside the SL/LM based on the main group. What I would like to do is make a query for all objects in main group 0.

I have tried some different SQL lookup, but due to my restricte knowledge of SQL I am not able to get a list based on the group address, only based on the name. Anyone have a tip how to proceed?

What I have done so far is:

Code:

liste = db:getall('SELECT address FROM objects WHERE name LIKE "%lys set value%"') -- returns a list with all objects containing this string
liste = db:getall('SELECT address FROM objects WHERE address LIKE "%0/0%"') -- returns empty list, as the address in the SQL table seems to be a number, not a string.