Question about pre-filtering

[sasha199]

Hello everyone, I would like to use a pre-filter with a query

SELECT sbrh2_datebase.name,sbrh2_datebase.familia, sbrh2_datebase.otchestvo, sbrh2_motivacia.* FROM sbrh2_datebase LEFT JOIN sbrh2_motivacia ON sbrh2_datebase.id = sbrh2_motivacia.familia;

Please tell me how I can add it?

 

[troester]

This is no pre-filter query.
A pre-filter (set in list settings/Data/Pre-filter) is something like
WHERE
one-of-your-Fabrik-elements
Condition: (Equals, Greater etc)
Value: your-prefilter-query
Type: Query

Your prefilter query must always return exactly one column
In case of Condition= Equals etc it must return exacty one record
In case of Condition = IN it must return at least one record