User:Dustin Loup/Sandbox: Difference between revisions

Latest revision as of 23:44, 3 December 2020

{{#cargo_query:tables=Event

|fields=DATE_FORMAT(Start, '%M %e, %Y'),_pageName,
|where=DATEDIFF(End,NOW()) >= 0
|order by=Start ASC
|limit=5
|format=template
|template=HomepageEvents
|order by=Start ASC

}}

@@ Line 1: / Line 1: @@
-==Civil Society Actors==
-{{#cargo_query:tables=Actor|where=Stakeholder_Group HOLDS "Civil Society"|fields=Logo,_pageName|format=template|template=ActorDisplay|named args=yes}}
-===Access===
-{{#cargo_query:tables=Actor|where=Issue_Areas HOLDS "Access"|fields=Logo|format=template|template=ActorDisplay|named args=yes}}
-===Privacy===
-{{#cargo_query:tables=Actor|where=Issue_Areas HOLDS "Privacy"|fields=Logo|format=template|template=ActorDisplay|named args=yes}}
-==Business Sector Actors==
-{{#cargo_query:tables=Actor|where=Stakeholder_Group HOLDS "Business"|fields=Logo|format=template|template=ActorDisplay|named args=yes}}
 {{#cargo_query:tables=Event
-  |fields=_pageName=Event,DATE_FORMAT(Start, '%M %e, %Y')=Start
+  |fields=DATE_FORMAT(Start, '%M %e, %Y'),_pageName,
   |where=DATEDIFF(End,NOW()) >= 0
   |order by=Start ASC
@@ Line 18: / Line 7: @@
   |format=template
   |template=HomepageEvents
- |named args=yes
+  |order by=Start ASC
-  |order by=Start DESC
 }}