Jobs: Difference between revisions
No edit summary |
No edit summary |
||
| Line 17: | Line 17: | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=Jobs | tables=Jobs | ||
|fields= _pageName=Job,Description, Posted, Closes | |fields= _pageName=Job,Description, Posted, Closes=Closed | ||
|format=dynamic table | |format=dynamic table | ||
|where=Closes < NOW() or Active=0 | |where=Closes < NOW() or Active=0 | ||
Revision as of 23:22, 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 `Closed`,`Posted__precision` AS `Posted__precision`,`Closes__precision` AS `Closed__precision` FROM `wm_cargo__Jobs` WHERE Closes < NOW() or Active=0 ORDER BY `wm_cargo__Jobs`.`_pageID`,`_pageName`,`Description`,`Posted`,`Closes` LIMIT 100