The second parameter in query does not get value


#1

Hi,

I have a problem when passing value to parameters in query. Someone could help me plz.

This is my original query:

SELECT
flatOrder.entity_id
FROM
default.magento_sales_flat_order flatOrder
WHERE
flatOrder.created_at >= ‘{{FromDate}}’
AND flatOrder.created_at <= ‘{{ToDate}}’
limit 5

It has id = 1671

Then I query from the above query like this:

SELECT *
FROM query_1671?FromDate=’{{StartDate}}’ & ToDate=’{{EndDate}}’

And it show this error:
Capture

Thanks in advance.