[SOLVED] join filter

[pandolfaccia]

Hi,
I insert a databasejoin in my list, whit the J! usergroups. I'd like to filter the result of the join, selecting only the groups that have a specific group as parent.
i used the data/where tab and inserted in the "Joins where and/or order by statement (SQL)" field this query:
WHERE `joskf__usergroups`.`parent_id` = 21

but after that, when i try to add a new entry, the form hang loading.
what am i doing wrong?


Thanks
alberto

 

[cheesegrits]

Try ...

WHERE {thistable}.parent_id = 21

-- hugh

 

[pandolfaccia]

i can't try that placeholder, because the table i use for the where condition is not the same but the other table involved in the join

alberto

 

[cheesegrits]

Not sure what you mean. What table is the join element to? You said "with the J! usergroups"?

-- hugh

 

[pandolfaccia]

i have a farbik_list table, witch has a dropdown dabasejoin element.
the join is with the joskf__usergroups table, on the id element.

i'd like to fileter the entry shown in the dropdown field, allowing not all usergroups, but only those whit the joskf__usergroups parent_id field set to 21

Thanks
alberto

 

[cheesegrits]

OK, so my suggestion of ...

WHERE {thistable}.parent_id = 21

... should work. As the tooltip explains, that gets replaced with the alias we are currently using for the joined table.

-- hugh

 

[pandolfaccia]

Great, it's working
Thank you a lot hugh

bye
alberto