Can you merge SQL parameters with COGNOS Parameters to work together? Or how would you adapt the below SQL to work with COGNOS.
Example:
SELECT
Var1,
Var2,
Var3
FROM
Table_1
WHERE
ITEM_DT >= TO_DATE(:qDateFrom,'MM/DD/YYYY') AND
ITEM_DT <= TO_DATE(:qDateTo,'MM/DD/YYYY') AND
You have to use Macro function Prompt
Example:
Prompt that appends text to the value
https://www.ibm.com/support/knowledgecenter/en/SSEP7J_10.2.2/com.ibm.swg.ba.cognos.ug_cr_rptstd.10.2.2.doc/t_prompt_that_appends_text_relational.html#prompt_that_appends_text_relational (https://www.ibm.com/support/knowledgecenter/en/SSEP7J_10.2.2/com.ibm.swg.ba.cognos.ug_cr_rptstd.10.2.2.doc/t_prompt_that_appends_text_relational.html#prompt_that_appends_text_relational)