Set parameter to Source query using DTS Parameter

Hi All,

This is for Scribe Insight and Dynamics CRM Adapter.I would like to set a parameter in the source query. I would like to set using formula as well as using DTS parameter. I am lokking for both solutions.

In my case, I have to retrieve data based on current year from Dynamics 365 CRM. Please check the attachment. I have hard coded the year in this but i would like to pass this dynamically using formula or using DTS parameter (from Scribe Console)? Any suggestions would be highly appreciated. Thank you!



File scribeinsight.docx92.93 KB