Unable to pre-filter lists with condition 'IN'

[AlexTCGPro]

Hey there.
I´m trying to use pre-filters on a list, the element is raw numbers, the condition is IN and the value is "SELECT id FROM fabrik_list_test WHERE testing = 1", when I go see the result it always returns "Column 'id' in IN/ALL/ANY subquery is ambiguous". I do need to use id as that's where it matches, what am I doing wrong?

 

[startpoint]

Try this:
in value field

return SELECT id FROM fabrik_list_test WHERE testing = 1;

Type: Eval

 

[troester]

Use a table alias:
value is "SELECT flt.id FROM fabrik_list_test flt WHERE flt.testing = 1"

 

[AlexTCGPro]

Try this:
in value field

return SELECT id FROM fabrik_list_test WHERE testing = 1;

Type: Eval

I don't think that would work, eval is php no?

Use a table alias:
value is "SELECT flt.id FROM fabrik_list_test flt WHERE flt.testing = 1"

It gives the same error. I could swear all of this worked before.

 

[troester]

SELECT flt.id FROM fabrik_list_test flt WHERE flt.testing = 1
Did you use all of these?
Is the error really coming from the prefilter?

 

[AlexTCGPro]

I was able to fix it, the issue was not in the pre-filter but in one of the elements of my table, it has many table joins, I just had to add "{thistable}." before every time I refer to an element of itself. Thank you for your help!