Set parameter to Source query using DTS Parameter
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!