- collection JobCollection
- collection JobAssignCollection
sql : SELECT jobAssigns.*,jobs.jobname FROM jobAssigns LEFT JOIN jobs ON(jobAssigns.jobId=jobs.jobId) WHERE jobs.deletedAt IS NULL;
JobAssignCollection.addLinks({
'job' : {
type: 'one',
collection:JobCollection,
field: 'jobId'
}
});
JobAssignCollection.createQuery({
$filters:{ "job.deletedAt" : null }, // how to add filter
});
how to filter deletedAt for job
Thank you.