How to pass the variable in Data Integration - Query?

Hi,

We are trying to pass the variable in Data Integration - Query but our attempt unsuccessful.

We wrote the select statement in Query but it has been hardcoded with specific parameters. We would like to pass the variable for the parameters,

Eg: Select * from Tablename where co = 'X' and FY = '24' and Period = 'JAN';

Questions:

1. Where do we need to define the Variable?
2. If the Variables are to be defined as 'User defined' or 'Substitution Variable' and how to notify in Query which we are calling User/Substitution variable?

Test cases, we tried so far -

1. Defined Substitution Variable as 'FY' and tried calling this in Query mentioning