Integrated Query not returning data

DecisionsTraining

I have integrated a query into one of my projects. The query does not return any data, but does not fail when I run it using the integration. However, when hardcoding the parameter I pass into the query, I get results as expected. What could be causing this? Query below:

SELECT Field1

FROM dbo.TableName

where Field2 like '%@Parameter%'

group by Field1

Robert_Decisions

You need to specify the variables and can remove the single quote.

https://youtu.be/jUeULLRTzZ0 See 16:05