Prefilter a list with data from another table

[kissinger]

Hallo!

I have a list with prefilters, it works ok.

Now I must also prefilter this list with data from another table.

Example:

Table 1 (List 1)
===============
user_id name
5 Bob
6 Fred
7 Anna

Table 2 (List 2)
===============
user_id myfield
5 0
6 1
7 0

Now I want prefilter the List 1:

Show a record in the list only when the user_id in the table 2 is "1".

The prefilter must show in the list only the record with the user_id = 6.

What I can do?

Thank you!

 

[cyberholic]

What happens if you set up two PRE-FILTERS ? I can set up something like filter 1 AND filter 2 - and within the fields, have you tried to use the {name_of_element} solution ?

 

[troester]

You can use MySQL in the condition
WHERE user_id IN
Condition: SELECT user_id FROM table2 WHERE my_field=1
Type: Query

 

[kissinger]

Hallo troester,

thank you. It works fine with your code!