databasejoin field with additional join and placeholder

[lke]

Hi,

i would filter the values from a dropdown that was created by a databasejoin element.
on the Tab "Data - where" I have create an additional join rule. That works fine when I use static values but i would use the current user id as placeholder.

LEFT JOIN members_repeat_writepermission ON members_repeat_writepermission.group = group WHERE members_repeat_writepermission.parent_id = '{$my->id}'

Anyone has an idea?

 

[lcollong]

as parent_id is probably a numeric value, I would write ...parent_id = {$my->id} without quotes
If you add &fabrikdebug=1 to your url, you'll be able to see the generated sql and understand what is wrong

 

[lke]

Hi,
when i use the query without quotes, i get an sql error. It looks like {$my->id} would not translated on this place. The SQL query contains {$my->id} and not 4 i.e.

 

[Jaanus]

I would write
where {thistable}.group IN (select members_repeat_writepermission.group from members_repeat_writepermission where members_repeat_writepermission.parent_id = '{$my->id}')

 

[lke]

Thanks,

that's work in where field. So the additional join field is not needed.