Template:SatelliteEventFilter: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 3: | Line 3: | ||
Edit the page to see the template text. | Edit the page to see the template text. | ||
{{#cargo_declare:_table=EventCategory1| | {{#cargo_declare:_table=SatelliteEventFilter|EventCategory1=List (,) of String (allowed values=Galleries/Exhibits)|EventCategory2=List (,) of String (allowed values=Presentations/Workshops|EventCategory3=List (,) of String (allowed values=Hackathons/Coworking)|EventCategory4=List (,) of String (allowed values=Live Music/DJs|EventCategory5=List (,) of String (allowed values=Alcohol)|EventCategory6=List (,) of String (allowed values=Food|EventCategory7=List (,) of String (allowed values=Networking)|EventCategory8=List (,) of String (allowed values=Activities/Games|EventCategory9=List (,) of String (allowed values=Poolside)|EventCategory10=List (,) of String (allowed values=Shopping|EventCategory11=List (,) of String (allowed values=Meditation/Self-Care)|EventCategory12=List (,) of String (allowed values=Fashion)}} | ||
</noinclude><includeonly>{{#cargo_store:_table=SatelliteEventFilter}} | </noinclude><includeonly>{{#cargo_store:_table=SatelliteEventFilter}} | ||
| Line 17: | Line 17: | ||
|tables=SatelliteEvents; | |tables=SatelliteEvents; | ||
where=MainEvent="ETHDenver" AND SideEventType="{{{EventCategory2}}}" AND StartDate="2024-02-23"; | where=MainEvent="ETHDenver" AND SideEventType="{{{EventCategory2}}}" AND StartDate="2024-02-23"; | ||
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 | |||
|tables=SatelliteEvents; | |||
where=MainEvent="ETHDenver" AND SideEventType="{{{EventCategory3}}}" AND StartDate="2024-02-23"; | |||
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 | |||
|tables=SatelliteEvents; | |||
where=MainEvent="ETHDenver" AND SideEventType="{{{EventCategory8}}}" AND StartDate="2024-02-23"; | |||
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 04:26, 8 February 2024
This is the "SatelliteEventFilter" template.
Edit the page to see the template text.
Invalid field description - Parentheses do not match: "String (allowed values=Presentations/Workshops"