Differences

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

--- kb:archi [2024/05/02 20:06] – 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>
@@ Line 14: / Line 16: @@
 </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.1714680377.txt.gz · Last modified: 2024/05/02 20:06 by yehuda

Back to top