Unable to access field filter with join query

Get Help
1

SELECT referrer
FROM "datalake".participants a join "datalake".projects b on a.projectid=b._id
WHERE 1=1 [[AND {{referrer}}]]
LIMIT 5;

it works standalone but not in join query, ends with error

image
image1190×458 28.6 KB

2

As you’re using a table alias, you need to fill in the “Table and field alias” field in the filter settings with the new name of the column. In your case it should be set to a.referrer.