User:Ttenbergen/Flex Diagram testing: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
Created page with "Trying to output results of a Cargo query to Flex Diagrams. === Set of Cargo queries === {{#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 pa..."
 
mNo edit summary
 
(4 intermediate revisions by the same user not shown)
Line 1: Line 1:
Trying to output results of a Cargo query to Flex Diagrams.  
Trying to output results of a Cargo query to [https://www.mediawiki.org/wiki/Extension:Flex_Diagrams Extension Flex Diagrams].  


=== Set of Cargo queries ===  
=== Set of Cargo queries ===  
Line 27: Line 27:


=== Cargo ===
=== Cargo ===
[[Mermaid:Test w Cargo]] Test with Cargo query doesn't expand the query
[[Mermaid:Test w Cargo]] Test with Cargo query.
<big>''' This shows as error in "edit diagram", and as the Mermaid code in preview here, but then resolves properly upon saving. "</big>
 
{{#display_diagram:Mermaid:Test w explicit}}
{{#display_diagram:Mermaid:Test w explicit}}



Latest revision as of 14:01, 12 April 2023

Trying to output results of a Cargo query to Extension Flex Diagrams.

Set of Cargo queries

Identifier must not contain quote, dot or null characters
Identifier must not contain quote, dot or null characters
Identifier must not contain quote, dot or null characters

explicit

Mermaid:Test w explicit Test with explicit code works

%% Test with explicit code works graph LR%% Test with explicit code worksgraph LR %% L_ tables L_Log[L_Log table] click L_Log "https://ccmdb.kuality.ca/index.php?title=L_Log_table" L_Log -->|"D_ID/Pat_ID to #8734; D_ID/Pat_ID"| L_PHI[L_PHI table] click L_PHI "https://ccmdb.kuality.ca/index.php?title=L_PHI_table" L_Log -->|"D_ID/Pat_ID to #8734; D_ID/Pat_ID"| L_CCI_Component[L_CCI_Component table] click L_CCI_Component "https://ccmdb.kuality.ca/index.php?title=L_CCI_Component table" L_CCI_Component -->|"CCI_1_Code to #8734; CCI_1_Code"| s_CCI_1[s_CCI_1 table] click s_CCI_1 "https://ccmdb.kuality.ca/index.php?title=s_CCI_1 table" L_CCI_Component -->|"CCI_2_Code to #8734; CCI_2_Code"| s_CCI_2[s_CCI_2 table] click s_CCI_2 "https://ccmdb.kuality.ca/index.php?title=s_CCI_2 table" s_CCI_1 -->|"CCI_1_code to #8734; CCI_code"| s_CCI_Categories_Collection_Mode[s_CCI_Categories_Collection_Mode table] s_CCI_2 -->|"CCI_2_code to #8734; CCI_code"| s_CCI_Categories_Collection_Mode[s_CCI_Categories_Collection_Mode table] s_CCI_1 -->|"CCI_1_code to #8734; CCI_code"| s_CCI_Categories[s_CCI_Categories table] s_CCI_2 -->|"CCI_2_code to #8734; CCI_code"| s_CCI_Categories[s_CCI_Categories table] L_Log -->|"D_ID/Pat_ID to #8734; D_ID/Pat_ID"| L_CCI_Picklist[L_CCI_Picklist table] click L_CCI_Picklist "https://ccmdb.kuality.ca/index.php?title=L_CCI_Picklist_table" L_CCI_Picklist -->|"CCI_Picklist_Code to #8734; CCI_Picklist_Code"| s_CCI_Picklist[s_CCI_Picklist table] s_CCI_Picklist -->|"CCI_Picklist_code to #8734; CCI_code"| s_CCI_Categories_Collection_Mode[s_CCI_Categories_Collection_Mode table] click s_CCI_Picklist "https://ccmdb.kuality.ca/index.php?title=s_CCI_Picklist_table" s_CCI_Picklist -->|"CCI_Picklist_code to #8734; CCI_code"| s_CCI_Categories[s_CCI_Categories table] click s_CCI_Categories_Collection_Mode "https://ccmdb.kuality.ca/index.php?title=s_CCI_Categories_Collection_Mode_table" L_Log -->|"D_ID/Pat_ID to #8734; D_ID/Pat_ID"| L_ICD10[L_ICD10 table] click L_ICD10 "https://ccmdb.kuality.ca/index.php?title=L_ICD10_table" L_ICD10 -->|"ICD10_code to #8734; ICD10_code"| s_ICD10[s_ICD10 table] click s_ICD10 "https://ccmdb.kuality.ca/index.php?title=s_ICD10_table" s_ICD10 -->|"ICD10_code to #8734; ICD10_code"| s_ICD10_Categories[s_ICD10_Categories table] click s_ICD10_Categories "https://ccmdb.kuality.ca/index.php?title=s_ICD10_Categories_table" L_Log -->|"D_ID to #8734; D_ID"| L_Labs_DSM[L_Labs_DSM table] click L_Labs_DSM "https://ccmdb.kuality.ca/index.php?title=L_Labs_DSM_table" L_Labs_DSM -->|"ICD10_code to #8734; ICD10_code"| s_group[s_group table] L_Labs_DSM -->|"ICD10_code to #8734; ICD10_code"| s_mapping_lab[s_mapping_lab table] L_Log -->|"D_ID/Pat_ID to #8734; D_ID/Pat_ID"| L_Labs_Flowsheet[L_Labs_Flowsheet table] click L_Labs_Flowsheet "https://ccmdb.kuality.ca/index.php?title=L_Labs_Flowsheet_table" L_Log -->|"D_ID/Pat_ID to #8734; D_ID/Pat_ID"| L_Labs_pre_2014_Aug[L_Labs_pre_2014_Aug table] click L_Labs_pre_2014_Aug "https://ccmdb.kuality.ca/index.php?title=L_Labs_pre_2014_Aug_table" L_Log -->|"D_ID/Pat_ID to #8734; D_ID/Pat_ID"| L_Pharm_Flowsheet[L_Pharm_Flowsheet table] click L_Pharm_Flowsheet "https://ccmdb.kuality.ca/index.php?title=L_Pharm_Flowsheet_table" L_Log -->|"D_ID to #8734; D_ID"| L_Pharmacy_pre_2012[L_Pharmacy_pre_2012 table] click L_Pharmacy_pre_2012 "https://ccmdb.kuality.ca/index.php?title=L_Pharmacy_pre_2012_table" L_Log -->|"D_ID to #8734; D_ID"| L_TISS_Item[L_TISS_Item table] click L_TISS_Item "https://ccmdb.kuality.ca/index.php?title=L_TISS_Item_table" L_TISS_Item -->|"TISS_ITEM to #8734; TISS_ITEM_NO"| L_TISS_Reference[L_TISS_Reference table] click L_TISS_Reference "https://ccmdb.kuality.ca/index.php?title=L_TISS_Reference_table" L_Log -->|"D_ID to #8734; D_ID"| L_TISS_Form[L_TISS_Form table] click L_TISS_Form "https://ccmdb.kuality.ca/index.php?title=L_TISS_Form_table" L_Log -->|"D_ID to #8734; D_ID"| L_TISS76[L_TISS76 table] click L_TISS76 "https://ccmdb.kuality.ca/index.php?title=L_TISS76_table" L_Log -->|"D_ID/Pat_ID to #8734; D_ID/Pat_ID"| L_TmpV2[L_TmpV2 table] click L_TmpV2 "https://ccmdb.kuality.ca/index.php?title=L_TmpV2_table" L_TmpV2 -->|"D_ID/Pat_ID to #8734; D_ID/Pat_ID"| s_Tmp[s_tmp table] click s_Tmp "https://ccmdb.kuality.ca/index.php?title=s_Tmp_table" L_Log -->|"D_ID to #8734; D_ID"| L_Dxs[L_Dxs table] click L_Dxs "https://ccmdb.kuality.ca/index.php?title=L_Dxs_table" L_Dxs -->|"DiagnosisCodeto #8734; DiagnosisCode"| s_AllDiagnoses[s_AllDiagnoses table] click s_AllDiagnoses "https://ccmdb.kuality.ca/index.php?title=s_AllDiagnoses table" L_Dxs -->|"DiagnosisCode to #8734; PathogenSubCode"| s_Pathogens[s_Pathogens table] click s_Pathogens "https://ccmdb.kuality.ca/index.php?title=s_Pathogens" L_Log -->|"D_ID to #8734; D_ID"| L_Como[L_Como table] click L_Como "https://ccmdb.kuality.ca/index.php?title=L_Como_table" L_Como -->|"ComorbidCode #8734; DiagnosisCode"| s_AllDiagnoses[s_AllDiagnoses table] L_Como -->|"ComorbidCode #8734; DiagnosisCode"| s_charlson_dxs[s_charlson_dxs table] click s_charlson_dxs "https://ccmdb.kuality.ca/index.php?title=s_charlson_dxs" L_Log -->|"D_ID to #8734; D_ID"| L_Communication_Notes[L_Communication_Notes table] click L_Communication_Notes "https://ccmdb.kuality.ca/index.php?title=L_Communication_Notes_table" L_Log -->|"D_ID to #8734; D_ID"| L_Hospitalization[L_Hospitalization table] click L_Hospitalization "https://ccmdb.kuality.ca/index.php?title=L_Hospitalization _table" L_Log -->|"D_ID to #8734; D_ID"| L_Problem[L_Problem table] click L_Problem "https://ccmdb.kuality.ca/index.php?title=L_Problem_table" L_Log -->|"D_ID to #8734; D_ID"| L_Problem[L_Problems_D_ID table] click L_Problems_D_ID "https://ccmdb.kuality.ca/index.php?title=L_Problems_D_ID_table" %%s_ tables L_Log -->|"R_Province to #8734; Code"| s_Provinces click s_Provinces "https://ccmdb.kuality.ca/index.php?title=s_Provinces_table" L_Log -->|"RecordStatus to #8734; RecordStatus_value"| s_RecordStatus click s_RecordStatus "https://ccmdb.kuality.ca/index.php?title=s_RecordStatus_table" L_Log -->|"dispo_ID to #8734; Pre-admit Inpatient Institution"| s_dispo L_Log -->|"dispo_ID to #8734; Previous Location"|s_dispo L_Log -->|"dispo_ID to #8734; Dispo"| s_dispo[s_dispo table] click s_dispo "https://ccmdb.kuality.ca/index.php?title=s_dispo_table" L_Log -->|"ADL_Bathing to #8734; ADL_Bathing"| s_ADLOptions[s_ADLOptions table] L_Log -->|"ADL_Dressing to #8734; ADL_Bathing"| s_ADLOptions[s_ADLOptions table] L_Log -->|"ADL_Toileting to #8734; ADL_Bathing"| s_ADLOptions[s_ADLOptions table] L_Log -->|"ADL_Transfering to #8734; ADL_Bathing"| s_ADLOptions[s_ADLOptions table] L_Log -->|"ADL_Continence to #8734; ADL_Bathing"| s_ADLOptions[s_ADLOptions table] L_Log -->|"ADL_Feeding to #8734; ADL_Bathing"| s_ADLOptions[s_ADLOptions table] click s_ADLOptions "https://ccmdb.kuality.ca/index.php?title=s_ADLOptions_table" L_Log -->|"D_ID/Pat_ID to #8734; D_ID/Pat_ID"| s_AP_AdmitType[s_AP_AdmitType table] click s_AP_AdmitType "https://ccmdb.kuality.ca/index.php?title=s_AP_AdmitType_table" L_Log -->|"D_ID/Pat_ID to #8734; D_ID/Pat_ID"| s_AP_Chronic[s_AP_Chronic table] click s_AP_Chronic "https://ccmdb.kuality.ca/index.php?title=s_AP_Chronic_table" L_Log -->|"D_ID/Pat_ID to #8734; D_ID/Pat_ID"| s_FIO2[s_FIO2 table] click s_FIO2 "https://ccmdb.kuality.ca/index.php?title=s_FIO2_table" L_Log -->|"AP_Eye to #8734; full_text"| s_GCS[s_GCS table] L_Log -->|"AP_Motor to #8734; full_text"| s_GCS[s_GCS table] L_Log -->|"AP_Verbal to #8734; full_text"| s_GCS[s_GCS table] click s_GCS "https://ccmdb.kuality.ca/index.php?title=s_GCS_table" L_Log -->|"Pre_Acute_Living_Situation to #8734; pre_acute_living_situation_ID"| s_pre_acute_living_situation[s_pre_acute_living_situation table] click s_pre_acute_living_situation "https://ccmdb.kuality.ca/index.php?title=s_pre_acute_living_situation_table" L_Log -->|"Previous_Service to #8734; previous_service"| s_previous_service[s_previous_service table] click s_previous_service "https://ccmdb.kuality.ca/index.php?title=s_previous_service_table"

Cargo

Mermaid:Test w Cargo Test with Cargo query. This shows as error in "edit diagram", and as the Mermaid code in preview here, but then resolves properly upon saving. "

%% Test with explicit code works graph LR%% Test with explicit code worksgraph LR %% L_ tables L_Log[L_Log table] click L_Log "https://ccmdb.kuality.ca/index.php?title=L_Log_table" L_Log -->|"D_ID/Pat_ID to #8734; D_ID/Pat_ID"| L_PHI[L_PHI table] click L_PHI "https://ccmdb.kuality.ca/index.php?title=L_PHI_table" L_Log -->|"D_ID/Pat_ID to #8734; D_ID/Pat_ID"| L_CCI_Component[L_CCI_Component table] click L_CCI_Component "https://ccmdb.kuality.ca/index.php?title=L_CCI_Component table" L_CCI_Component -->|"CCI_1_Code to #8734; CCI_1_Code"| s_CCI_1[s_CCI_1 table] click s_CCI_1 "https://ccmdb.kuality.ca/index.php?title=s_CCI_1 table" L_CCI_Component -->|"CCI_2_Code to #8734; CCI_2_Code"| s_CCI_2[s_CCI_2 table] click s_CCI_2 "https://ccmdb.kuality.ca/index.php?title=s_CCI_2 table" s_CCI_1 -->|"CCI_1_code to #8734; CCI_code"| s_CCI_Categories_Collection_Mode[s_CCI_Categories_Collection_Mode table] s_CCI_2 -->|"CCI_2_code to #8734; CCI_code"| s_CCI_Categories_Collection_Mode[s_CCI_Categories_Collection_Mode table] s_CCI_1 -->|"CCI_1_code to #8734; CCI_code"| s_CCI_Categories[s_CCI_Categories table] s_CCI_2 -->|"CCI_2_code to #8734; CCI_code"| s_CCI_Categories[s_CCI_Categories table] L_Log -->|"D_ID/Pat_ID to #8734; D_ID/Pat_ID"| L_CCI_Picklist[L_CCI_Picklist table] click L_CCI_Picklist "https://ccmdb.kuality.ca/index.php?title=L_CCI_Picklist_table" L_CCI_Picklist -->|"CCI_Picklist_Code to #8734; CCI_Picklist_Code"| s_CCI_Picklist[s_CCI_Picklist table] s_CCI_Picklist -->|"CCI_Picklist_code to #8734; CCI_code"| s_CCI_Categories_Collection_Mode[s_CCI_Categories_Collection_Mode table] click s_CCI_Picklist "https://ccmdb.kuality.ca/index.php?title=s_CCI_Picklist_table" s_CCI_Picklist -->|"CCI_Picklist_code to #8734; CCI_code"| s_CCI_Categories[s_CCI_Categories table] click s_CCI_Categories_Collection_Mode "https://ccmdb.kuality.ca/index.php?title=s_CCI_Categories_Collection_Mode_table" L_Log -->|"D_ID/Pat_ID to #8734; D_ID/Pat_ID"| L_ICD10[L_ICD10 table] click L_ICD10 "https://ccmdb.kuality.ca/index.php?title=L_ICD10_table" L_ICD10 -->|"ICD10_code to #8734; ICD10_code"| s_ICD10[s_ICD10 table] click s_ICD10 "https://ccmdb.kuality.ca/index.php?title=s_ICD10_table" s_ICD10 -->|"ICD10_code to #8734; ICD10_code"| s_ICD10_Categories[s_ICD10_Categories table] click s_ICD10_Categories "https://ccmdb.kuality.ca/index.php?title=s_ICD10_Categories_table" L_Log -->|"D_ID to #8734; D_ID"| L_Labs_DSM[L_Labs_DSM table] click L_Labs_DSM "https://ccmdb.kuality.ca/index.php?title=L_Labs_DSM_table" L_Labs_DSM -->|"ICD10_code to #8734; ICD10_code"| s_group[s_group table] L_Labs_DSM -->|"ICD10_code to #8734; ICD10_code"| s_mapping_lab[s_mapping_lab table] L_Log -->|"D_ID/Pat_ID to #8734; D_ID/Pat_ID"| L_Labs_Flowsheet[L_Labs_Flowsheet table] click L_Labs_Flowsheet "https://ccmdb.kuality.ca/index.php?title=L_Labs_Flowsheet_table" L_Log -->|"D_ID/Pat_ID to #8734; D_ID/Pat_ID"| L_Labs_pre_2014_Aug[L_Labs_pre_2014_Aug table] click L_Labs_pre_2014_Aug "https://ccmdb.kuality.ca/index.php?title=L_Labs_pre_2014_Aug_table" L_Log -->|"D_ID/Pat_ID to #8734; D_ID/Pat_ID"| L_Pharm_Flowsheet[L_Pharm_Flowsheet table] click L_Pharm_Flowsheet "https://ccmdb.kuality.ca/index.php?title=L_Pharm_Flowsheet_table" L_Log -->|"D_ID to #8734; D_ID"| L_Pharmacy_pre_2012[L_Pharmacy_pre_2012 table] click L_Pharmacy_pre_2012 "https://ccmdb.kuality.ca/index.php?title=L_Pharmacy_pre_2012_table" L_Log -->|"D_ID to #8734; D_ID"| L_TISS_Item[L_TISS_Item table] click L_TISS_Item "https://ccmdb.kuality.ca/index.php?title=L_TISS_Item_table" L_TISS_Item -->|"TISS_ITEM to #8734; TISS_ITEM_NO"| L_TISS_Reference[L_TISS_Reference table] click L_TISS_Reference "https://ccmdb.kuality.ca/index.php?title=L_TISS_Reference_table" L_Log -->|"D_ID to #8734; D_ID"| L_TISS_Form[L_TISS_Form table] click L_TISS_Form "https://ccmdb.kuality.ca/index.php?title=L_TISS_Form_table" L_Log -->|"D_ID to #8734; D_ID"| L_TISS76[L_TISS76 table] click L_TISS76 "https://ccmdb.kuality.ca/index.php?title=L_TISS76_table" L_Log -->|"D_ID/Pat_ID to #8734; D_ID/Pat_ID"| L_TmpV2[L_TmpV2 table] click L_TmpV2 "https://ccmdb.kuality.ca/index.php?title=L_TmpV2_table" L_TmpV2 -->|"D_ID/Pat_ID to #8734; D_ID/Pat_ID"| s_Tmp[s_tmp table] click s_Tmp "https://ccmdb.kuality.ca/index.php?title=s_Tmp_table" L_Log -->|"D_ID to #8734; D_ID"| L_Dxs[L_Dxs table] click L_Dxs "https://ccmdb.kuality.ca/index.php?title=L_Dxs_table" L_Dxs -->|"DiagnosisCodeto #8734; DiagnosisCode"| s_AllDiagnoses[s_AllDiagnoses table] click s_AllDiagnoses "https://ccmdb.kuality.ca/index.php?title=s_AllDiagnoses table" L_Dxs -->|"DiagnosisCode to #8734; PathogenSubCode"| s_Pathogens[s_Pathogens table] click s_Pathogens "https://ccmdb.kuality.ca/index.php?title=s_Pathogens" L_Log -->|"D_ID to #8734; D_ID"| L_Como[L_Como table] click L_Como "https://ccmdb.kuality.ca/index.php?title=L_Como_table" L_Como -->|"ComorbidCode #8734; DiagnosisCode"| s_AllDiagnoses[s_AllDiagnoses table] L_Como -->|"ComorbidCode #8734; DiagnosisCode"| s_charlson_dxs[s_charlson_dxs table] click s_charlson_dxs "https://ccmdb.kuality.ca/index.php?title=s_charlson_dxs" L_Log -->|"D_ID to #8734; D_ID"| L_Communication_Notes[L_Communication_Notes table] click L_Communication_Notes "https://ccmdb.kuality.ca/index.php?title=L_Communication_Notes_table" L_Log -->|"D_ID to #8734; D_ID"| L_Hospitalization[L_Hospitalization table] click L_Hospitalization "https://ccmdb.kuality.ca/index.php?title=L_Hospitalization _table" L_Log -->|"D_ID to #8734; D_ID"| L_Problem[L_Problem table] click L_Problem "https://ccmdb.kuality.ca/index.php?title=L_Problem_table" L_Log -->|"D_ID to #8734; D_ID"| L_Problem[L_Problems_D_ID table] click L_Problems_D_ID "https://ccmdb.kuality.ca/index.php?title=L_Problems_D_ID_table" %%s_ tables L_Log -->|"R_Province to #8734; Code"| s_Provinces click s_Provinces "https://ccmdb.kuality.ca/index.php?title=s_Provinces_table" L_Log -->|"RecordStatus to #8734; RecordStatus_value"| s_RecordStatus click s_RecordStatus "https://ccmdb.kuality.ca/index.php?title=s_RecordStatus_table" L_Log -->|"dispo_ID to #8734; Pre-admit Inpatient Institution"| s_dispo L_Log -->|"dispo_ID to #8734; Previous Location"|s_dispo L_Log -->|"dispo_ID to #8734; Dispo"| s_dispo[s_dispo table] click s_dispo "https://ccmdb.kuality.ca/index.php?title=s_dispo_table" L_Log -->|"ADL_Bathing to #8734; ADL_Bathing"| s_ADLOptions[s_ADLOptions table] L_Log -->|"ADL_Dressing to #8734; ADL_Bathing"| s_ADLOptions[s_ADLOptions table] L_Log -->|"ADL_Toileting to #8734; ADL_Bathing"| s_ADLOptions[s_ADLOptions table] L_Log -->|"ADL_Transfering to #8734; ADL_Bathing"| s_ADLOptions[s_ADLOptions table] L_Log -->|"ADL_Continence to #8734; ADL_Bathing"| s_ADLOptions[s_ADLOptions table] L_Log -->|"ADL_Feeding to #8734; ADL_Bathing"| s_ADLOptions[s_ADLOptions table] click s_ADLOptions "https://ccmdb.kuality.ca/index.php?title=s_ADLOptions_table" L_Log -->|"D_ID/Pat_ID to #8734; D_ID/Pat_ID"| s_AP_AdmitType[s_AP_AdmitType table] click s_AP_AdmitType "https://ccmdb.kuality.ca/index.php?title=s_AP_AdmitType_table" L_Log -->|"D_ID/Pat_ID to #8734; D_ID/Pat_ID"| s_AP_Chronic[s_AP_Chronic table] click s_AP_Chronic "https://ccmdb.kuality.ca/index.php?title=s_AP_Chronic_table" L_Log -->|"D_ID/Pat_ID to #8734; D_ID/Pat_ID"| s_FIO2[s_FIO2 table] click s_FIO2 "https://ccmdb.kuality.ca/index.php?title=s_FIO2_table" L_Log -->|"AP_Eye to #8734; full_text"| s_GCS[s_GCS table] L_Log -->|"AP_Motor to #8734; full_text"| s_GCS[s_GCS table] L_Log -->|"AP_Verbal to #8734; full_text"| s_GCS[s_GCS table] click s_GCS "https://ccmdb.kuality.ca/index.php?title=s_GCS_table" L_Log -->|"Pre_Acute_Living_Situation to #8734; pre_acute_living_situation_ID"| s_pre_acute_living_situation[s_pre_acute_living_situation table] click s_pre_acute_living_situation "https://ccmdb.kuality.ca/index.php?title=s_pre_acute_living_situation_table" L_Log -->|"Previous_Service to #8734; previous_service"| s_previous_service[s_previous_service table] click s_previous_service "https://ccmdb.kuality.ca/index.php?title=s_previous_service_table"

Template

Mermaid:Test w template Test with Template:ER Mermaid expand the template

%% Test to run w Template:ER Mermaid graph LR L_Log[L_Log table] {{ER Mermaid}}