Last Week's Events: Difference between revisions

Revision as of 09:22, 7 June 2025

Event Date	Case	Event Summary	Case Summary	Case Topic The prepared statement allPastEvents is not set up for the database ID CaseData.

@@ Line 1: / Line 1: @@
-{| class="wikitable"
+{| class="wikitable sortable"
   ! Event Date
+ ! Case
   ! Event Summary
- ! Case
   ! Case Summary
+ ! Case Topic
   {{#for_external_table:
    |{{!}}-
-   {{!}} {{{futureEventDateFiled}}}
+   {{!}} {{{eventDateFiled}}}
-   {{!}} {{{futureEventSummary}}}
+   {{!}} [[{{{eventCase}}}]]
-   {{!}} [[{{{futureEventCase}}}]]
+   {{!}} {{{eventSummary}}} {{#if: {{{eventDocumentLink}}} | [{{{eventDocumentLink}}} SOURCE] | }} {{#if: {{{eventNewsLink}}} | [{{{eventNewsLink}}} NEWS] | }}
-   {{!}} {{{futureEventCaseSummary}}}
+  {{!}} {{{eventCaseSummary}}}
+   {{!}} [[{{{eventCaseTopic}}}]]
    |source = CaseData
    |query = allPastEvents
-   |data = futureEventID=event_id, futureEventLink=event_link, futureEventDocumentNumber=event_documentnumber, futureEventDateFiled=event_datefiled, futureEventSummary=event_summary, futureEventCase = case_title, futureEventCaseSummary = case_summary
+   |data =
+   eventDateFiled=event_datefiled,
+   eventSummary=event_summary,
+   eventCase = case_title,
+   eventCaseSummary = case_summary,
+   eventDocumentLink = event_documentlink,
+   eventNewsLink = event_newslink,
+   eventCaseTopic = case_topic
    |parameters = -7
   }}
 |}