Mermaid:Test w Cargo: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
Line 1: Line 1:
%% Test to run w Template:ER Mermaid
%% Test to run w Cargo query
graph LR
graph LR
L_Log[L_Log table]
L_Log[L_Log table]

Revision as of 14:41, 2023 April 12

%% Test to run w Cargo query graph LR L_Log[L_Log table] {{#cargo_query: tables=foreign_keys |fields= CONCAT(foreign_key_table,"[", foreign_key_table," 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, "\" \"open table page\"<br>") |group by=foreign_key_table |delimiter= }} {{#cargo_query: tables=foreign_keys |fields=CONCAT("click ", primary_key_table, " \"https://ccmdb.kuality.ca/index.php?title=", primary_key_table, "\" \"open table page\"<br>") |group by=primary_key_table |delimiter= }}
%% Test to run w Cargo query
graph LR
L_Log[L_Log table]

{{#cargo_query:
tables=foreign_keys
|fields= CONCAT(foreign_key_table,"[", foreign_key_table," 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, "\" \"open table page\"<br>")
|group by=foreign_key_table
|delimiter=
}}

{{#cargo_query:
tables=foreign_keys
|fields=CONCAT("click ", primary_key_table, " \"https://ccmdb.kuality.ca/index.php?title=", primary_key_table, "\" \"open table page\"<br>")
|group by=primary_key_table
|delimiter=
}}