Differences

This shows you the differences between two versions of the page.

--- kb:archi [2024/05/02 19:57] – created yehuda
+++ kb:archi [2024/05/26 08:26] (current) – yehuda
@@ Line 1: / Line 1: @@
 ====== 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 = 'PROD'
+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>

kb/archi.1714679861.txt.gz · Last modified: 2024/05/02 19:57 by yehuda

Back to top