get_linked_beans where clause

[mikesolomon]

How do I use the where clause in get_linked_brans?

I tried the following

$where = 'ischeme' = 1';
$jobs = $so->get_linked_beans('zz_so_zz_job_id','zz_job','','' ,'',0,$where);

But I get the following sql error

Query Failed:SELECT zz_job.id FROM zz_job WHERE zz_job.zz_so_id= '2ae503e5-d1be-7c95-74cc-48fee60192c1' AND zz_job.deleted=0 AND ii'i'::MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''i'' at line 1

How should the where statement be written?

[dlorenzetti]

Hi Mike,

Try this:

$where = array(
'lhs_field' => 'ischeme',
'operator' => '=',
'rhs_value' => '1',
);


I hope this help.

[mikesolomon]

Hi Mike,

Try this:

$where = array(
'lhs_field' => 'ischeme',
'operator' => '=',
'rhs_value' => '1',
);


I hope this help.

Diego thanks works perfectly

is there a way I can do more than one condition?

[DragonflyMaster]

Hi Mike,
sorry to bother you but this forum is meant for Tutorials only.
Please post in Help forum.

[mikesolomon]

Hi Mike,
sorry to bother you but this forum is meant for Tutorials only.
Please post in Help forum.

Yup sorry - posted here by mistake

Could someone please move this thread to Developer help