Jobs: Difference between revisions
(Created page with "{{#cargo_query: tables=Jobs |fields=Start_date, End_date, _pageName=Job,Description |format=dynamic table }} __NOCACHE__") |
No edit summary |
||
| Line 1: | Line 1: | ||
<div class="section-container auto" data-section> | |||
<div class="section"> | |||
<p class="title" data-section-title>Current vacancies</p> | |||
<div class="content" data-section-content> | |||
{{#cargo_query: | {{#cargo_query: | ||
tables=Jobs | tables=Jobs | ||
|fields= | |fields= _pageName=Job,Description, Posted, Closes | ||
|format=dynamic table | |format=dynamic table | ||
|where=(Closes >= NOW() or Closes IS NULL) AND Active=1 | |||
}} | }} | ||
</div> | |||
</div> | |||
<div class="section"> | |||
<p class="title" data-section-title>Expired</p> | |||
<div class="content" data-section-content> | |||
{{#cargo_query: | |||
tables=Jobs | |||
|fields= _pageName=Job,Description, Posted, Closes | |||
|format=dynamic table | |||
|where=Closes < NOW() or Active=0 | |||
}} | |||
</div> | |||
</div> | |||
__NOCACHE__ | __NOCACHE__ | ||
Revision as of 23:20, 6 November 2015
Current vacancies
Function: CargoSQLQuery::run Query: SELECT `wm_cargo__Jobs`.`_pageID` AS `cargo_backlink_page_id_Jobs`,`_pageName` AS `Job`,`Description` AS `Description`,`Posted` AS `Posted`,`Closes` AS `Closes`,`Posted__precision` AS `Posted__precision`,`Closes__precision` AS `Closes__precision` FROM `wm_cargo__Jobs` WHERE (Closes >= NOW() or Closes IS NULL) AND Active=1 ORDER BY `wm_cargo__Jobs`.`_pageID`,`_pageName`,`Description`,`Posted`,`Closes` LIMIT 100
Expired
Function: CargoSQLQuery::run Query: SELECT `wm_cargo__Jobs`.`_pageID` AS `cargo_backlink_page_id_Jobs`,`_pageName` AS `Job`,`Description` AS `Description`,`Posted` AS `Posted`,`Closes` AS `Closes`,`Posted__precision` AS `Posted__precision`,`Closes__precision` AS `Closes__precision` FROM `wm_cargo__Jobs` WHERE Closes < NOW() or Active=0 ORDER BY `wm_cargo__Jobs`.`_pageID`,`_pageName`,`Description`,`Posted`,`Closes` LIMIT 100