Cases: Difference between revisions

@@ Line 1: / Line 1: @@
-List of all cases in database:
+List of all cases:
 {| class="wikitable"
-  ! Case Title !! Case Summary !! Case Status !! Case Topic
+  ! Case Title
-  {{#for_external_table:
+ ! Case Summary
-    |{{!}}-
+ ! Case Status
-    {{!}} [[{{{caseTitle}}}]] {{!}}{{!}} {{{caseSummary}}} {{!}}{{!}} {{{caseStatus}}} {{!}}{{!}} [[{{{caseTopic}}}]]
+ ! Case Topic
- |source = CaseData
+ {{#for_external_table:
- |query = cases
+  |{{!}}-
- |data=caseID=case_id, caseTitle=case_title, caseSummary=case_summary, caseStatus=case_status, caseTopic = case_topic
+  {{!}} [[{{{caseTitle}}}]]
-  }}
+  {{!}} {{{caseSummary}}}
+  {{!}} {{{caseStatus}}}
+  {{!}} [[{{{caseTopic}}}]]
+  |source = CaseData
+  |query = cases
+  |data = caseID=case_id, caseTitle=case_title, caseSummary=case_summary, caseStatus=case_status, caseTopic = case_topic
+ }}
 |}