Template:SatelliteEventByDate: Difference between revisions

From Edd's Almanac
Jump to navigation Jump to search
No edit summary
No edit summary
Line 20: Line 20:
{{#cargo_query:
{{#cargo_query:
tables=SatelliteEvents
tables=SatelliteEvents
|where=MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND SideEventType="{{{EventFilter1}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND SideEventType="{{{EventFilter2}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND SideEventType="{{{EventFilter3}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND SideEventType="{{{EventFilter4}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND SideEventType="{{{EventFilter5}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND SideEventType="{{{EventFilter6}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND SideEventType="{{{EventFilter7}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND SideEventType="{{{EventFilter8}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND SideEventType="{{{EventFilter9}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND SideEventType="{{{EventFilter10}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND SideEventType="{{{EventFilter11}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND SideEventType="{{{EventFilter12}}}"
|where=MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory1="{{{EventFilter1}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory1="{{{EventFilter2}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory1="{{{EventFilter3}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory1="{{{EventFilter4}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory1="{{{EventFilter5}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory1="{{{EventFilter6}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory1="{{{EventFilter7}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory1="{{{EventFilter8}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory1="{{{EventFilter9}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory1="{{{EventFilter10}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory1="{{{EventFilter11}}}" OR MainEvent="{{{MainEvent}}}" AND StartDate="{{{Date}}}" AND EventCategory1="{{{EventFilter12}}}"
|fields=MainEvent,SideEventType,City,StartTimeUnixTimestamp,EndTimeUnixTimestamp,StartDate,StartTime,EndTime,EventName,EventType,URL,StartingTicketPrice,CONCAT('[[',LocationName,']]')=LocationName,Address1,Address2,ZipCode,MapLink,RSVP,FBOptions,CONCAT('[[',Host1,']]')=Host1,CONCAT(', [[',Host2,']]')=Host2,CONCAT(', [[',Host3,']]')=Host3,CONCAT(', [[',Host4,']]')=Host4,CONCAT(', [[',Host5,']]')=Host5,CONCAT(', [[',Host6,']]')=Host6,CONCAT(', [[',Host7,']]')=Host7,CONCAT(', [[',Host8,']]')=Host8,CONCAT(', [[',Host9,']]')=Host9,CONCAT(', [[',Host10,']]')=Host10,CONCAT(', [[',Host11,']]')=Host11,CONCAT(', [[',Host12,']]')=Host12,CONCAT(', [[',Host13,']]')=Host13,CONCAT(', [[',Host14,']]')=Host14,CONCAT(', [[',Host15,']]')=Host15,Notes,AddEventID
|fields=MainEvent,SideEventType,City,StartTimeUnixTimestamp,EndTimeUnixTimestamp,StartDate,StartTime,EndTime,EventName,EventType,URL,StartingTicketPrice,CONCAT('[[',LocationName,']]')=LocationName,Address1,Address2,ZipCode,MapLink,RSVP,FBOptions,CONCAT('[[',Host1,']]')=Host1,CONCAT(', [[',Host2,']]')=Host2,CONCAT(', [[',Host3,']]')=Host3,CONCAT(', [[',Host4,']]')=Host4,CONCAT(', [[',Host5,']]')=Host5,CONCAT(', [[',Host6,']]')=Host6,CONCAT(', [[',Host7,']]')=Host7,CONCAT(', [[',Host8,']]')=Host8,CONCAT(', [[',Host9,']]')=Host9,CONCAT(', [[',Host10,']]')=Host10,CONCAT(', [[',Host11,']]')=Host11,CONCAT(', [[',Host12,']]')=Host12,CONCAT(', [[',Host13,']]')=Host13,CONCAT(', [[',Host14,']]')=Host14,CONCAT(', [[',Host15,']]')=Host15,Notes,AddEventID
|format=template
|format=template

Revision as of 21:44, 9 February 2024

This is the "SatelliteEventByDate" template. It should be called in the following format:

{{SatelliteEventByDate
|MainEvent=
|dateanchor=
|Date=
|DisplayDate=
}}