Issue Area:Number Resources: Difference between revisions
Dustin Loup (talk | contribs) No edit summary |
Dustin Loup (talk | contribs) No edit summary |
||
| Line 5: | Line 5: | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=Event | tables=Event | ||
|fields=_pageName = Event,Start,End,City,Country | |fields=_pageName = Event,DATE_FORMAT(Start, "%M %e, %Y"),DATE_FORMAT(End, "%M %e, %Y"),City,Country | ||
|where=Category HOLDS "Number Resources" AND DATEDIFF(End,NOW()) >= | |where=Category HOLDS "Number Resources" AND DATEDIFF(End,NOW()) >= 0 | ||
|format=dynamic table | |format=dynamic table | ||
}} | }} | ||
Revision as of 17:10, 18 January 2018
Events +Add Event
{{#cargo_query:
tables=Event |fields=_pageName = Event,DATE_FORMAT(Start, "%M %e, %Y"),DATE_FORMAT(End, "%M %e, %Y"),City,Country |where=Category HOLDS "Number Resources" AND DATEDIFF(End,NOW()) >= 0 |format=dynamic table
}}
Actors +Add Actor
{{#cargo_query:
tables=Actor |fields=_pageName = Actor,Stakeholder_Group=Stakeholder Group,Issue_Areas,Region |where=Issue_Areas HOLDS "Number Resources" |format=dynamic table
}}
Resources +Add Resource
{{#cargo_query:
tables=Resources |fields=_pageName=Resource,Issue |where=Issue HOLDS "Number Resources" |format=dynamic table
}}