Show items without record in jointable

Question

I'm building an application with CakePHP on which you can fill in surveys. The problem i came up with is the following:

I have two tables:

Surveys / SurveysUsers (HABTM)

When somebody fills in a survey a record will be made in SurveysUsers and when the Survey is accepted the survey shouldn't be visible anymore. So i want to select the surveys from the surveys table which don't have a record in the SurveysUsers table.

Hope u all can help me!

Thanks

Dwayne

score 0 · Answer 1 · answered May 10 '11 at 08:56

Just off the cuff, try this:

$this->Survey->bindModel(array('hasOne'=>array('SurveysUsers')));
$surveys = $this->Survey->find('all',array(
    'conditions'=>array('SurveysUsers.survey_id NOT'=>'Survey.id');
));

The principle is that you bind the habtm model as hasone and then you can use the fields in your conditions. Have a look in the Docs

Show items without record in jointable

1 Answers1