Pre-filter value from external table

[nerio]

I need a tip. I need to apply a pre-filter to a list where the value is equal to that contained in a field of a table with only one record. I tried to insert {table___fieldname} but it doesn't work, maybe because I should tell it to go to record n. 1?

 

[lcollong]

you chan choose the type "query" then use a subquery in the value field to catch the data you need to compare to ie : SELECT myvalue FROM myOtherTable WHERE id=1 (or whatever is the id of you one row table)

 

[nerio]

Thank you but maybe I need to explain myself better:
I have a list (A) with 1 record with id = 1 and year field = 2019-2020
I have a list of people (B) with a year field which can contain '2019-2020' or '2020-2021' etc.
I want to filter only the records of people who have the same year field as the one in the list.

 

[lousyfool]

@lcollong's reply was already good.

In a bit more detailed way, set the pre-filter for list B as follows:
Field: select the year field of list B
Condition: CONTAINS
Value: SELECT yearfield_a* FROM list_a_table** WHERE id = 1
Type: Query

* replace with column name of year field in list A.
** replace with table name of list A.
http://fabrikar.com/forums/index.php?wiki/list-pre-filters/

 

[nerio]

Susa il ritardo. Grazie.