How does one query JobOrder with a specified businessSecordsId? This is an example of our current query (in PHP):
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.
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 ];