====== Archi ======

[[https://github.com/archimatetool/archi/wiki/Label-Expressions| Archi Label-Expressions]]

<code sql>
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'
</code>


<code sql>
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'
</code>


<code sql>
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'
</code>