Page 1 of 1

Querying JobOrder with businessSectorsId

Posted: Thu Aug 06, 2015 10:16 am
by firestarter
Hey,

How does one query JobOrder with a specified businessSecordsId? This is an example of our current query (in PHP):

Code: Select all

$query_array = [
  'entityName' => 'JobOrder',
  'maxResults' => 20,
  'where' => 'isOpen=1 AND title like \'%c%\' AND employmentType=\'Contract\' AND businessSectors.id IN (99267)',
  'parameters' => [],
  'distinct' => true
];
Unfortunately this doesn't work. It seems as if we need to query the jobs, then for each job check their businessSectors association with the requested ID. Is there any way around this? It seems counter intuitive, especially in relation to pagination.