26.07.2021, 10:14
Use this script to log all plan names where a certain object is used:
Code:
id = buslib.encodega('1/1/1')
plans = db:getlist([[
SELECT vf.name FROM visfloors vf
JOIN visobjects vo ON vf.id=vo.floor
WHERE vo.object=?
]], id)
log(plans)