User:Ttenbergen/Relationship Diagram: Difference between revisions

Revision as of 14:09, 2023 April 12

	wiki housekeeping Considering Extension Mermaid and Extension FlexDiagram. Both have bugs in how they implement the ER Diagram for now. Need to review. https://www.mediawiki.org/wiki/Extension_talk:Flex_Diagrams https://github.com/SemanticMediaWiki/Mermaid/issues/79 https://github.com/SemanticMediaWiki/Mermaid/issues/78	added: no added date action: no action date

see examples
BPMN:Test Mermaid:Test Page Mermaid:Test does not exist.

Mermaid seems unsupported, trying FlexDiagrams instead
Mermaid Documentation: https://github.com/SemanticMediaWiki/Mermaid/blob/master/docs/USAGE.md Explicit call Mermaid ER diagram xxx yyy "L_Log

@@ Line 7: / Line 7: @@
 === Cargo query to generate a line ===
-{{#cargo_query:
+<!--{{#cargo_query:
 tables=Data_Element
 |fields=tables
 |group by=tables
+}}-->
+{{#cargo_query:
+tables=foreign_keys
+|fields= CONCAT(foreign_key_table,"-->{{!}} ",foreign_key_field," to #8734; ", primary_key_field, "\"{{!}} ", primary_key_table)
+|delimiter=<br>
+}}
+{{#cargo_query:
+tables=foreign_keys
+|fields=CONCAT("click ", foreign_key_table, "\"https://ccmdb.kuality.ca/index.php?title=", foreign_key_table, "\"")
+|group by=foreign_key_table
+|delimiter=<br>
 }}
 {{#cargo_query:
 tables=foreign_keys
-|fields=
+|fields=CONCAT("click ", primary_key_table, "\"https://ccmdb.kuality.ca/index.php?title=", primary_key_table, "\"")
-    foreign_key_table,
+|group by=primary_key_table
-    foreign_key_field,
+|delimiter=<br>
-    primary_key_table,
-    primary_key_field,
 }}