[SOLVED] Databasejoin element data retrieve

[Puma173]

Good morning.

I have a relation table with two databasejoin elements [department_id | plant_id]. My requirement is to hide the dropdown options that are already in the table.
I tried this setup into the "Data - Where" TAB on the "department_id" element:

WHERE {thistable}.id NOT IN (
SELECT DISTINCT dp.department_id
FROM dsk2app_rel_departments_plants AS dp
WHERE dp.plant_id='{dsk2app_rel_departments_plants___plant_id}'
)

but the hiding doesn't turn on.

Any ideas?
Tks

 

[juuser]

Try removing "WHERE" from the beginning and add _raw like this {dsk2app_rel_departments_plants___plant_id_raw}

 

[Puma173]

Try removing "WHERE" from the beginning and add _raw like this {dsk2app_rel_departments_plants___plant_id_raw}

Your suggestions are, always, correct. TKS