Archi

Archi Label-Expressions

SELECT name FROM Elements e 
INNER JOIN Properties p ON e.id = p.conceptid 
WHERE e.type = 'Node' AND p.propkey = 'env' AND p.propvalue = 'DEV'

SELECT name FROM Elements e 
INNER JOIN Properties p ON e.id = p.conceptid 
WHERE e.type = 'SystemSoftware' AND p.propkey = 'env' AND p.propvalue = 'DEV'

SELECT Elements.name, Properties.propvalue AS softwareProdVersion  FROM Elements
INNER JOIN Properties
ON Elements.id=Properties.conceptid
WHERE Elements.type='SystemSoftware' 
AND Properties.propkey = 'softwareProdVersion'