Trouble with variables and CTE

Get Help
1

Hi,
I am trying to run a CTE with variables and am unfortunately not having any luck.

Here is an example of what I am trying:

WITH some_list AS (
    SELECT column_1, 
     column_2
    FROM some_table
    WHERE
       column_2 LIKE 'begin'
),
some_other_list as (SELECT column_A, column_B
[[ WHERE column_B {{ location }} ]]
)
select location.column_B,  participant_list.*
from some_list 
inner join some_other_list on column_A = column_1

The {{ location }} is a variable that is a field filter built on a view. When I run this query, I get the following error:
Could not set parameter at position 2

Are field filters meant to work in CTEs ? Is there a place I can look and see just what sql is actually getting run?

2

The field filter should be use like WHERE xxx and not WHERE column xxxx. Try removing the column