How to modify query parameters dynamically at runtime
The source entity and query parameters are available in the data flow properties list. Follow these steps to setup expression:
- Right-click on data flow canvas and select Properties menu.
- Scroll-down and find property named like [Sage].[QueryParameters]. This is the property containing the query parameters.
- Scroll-down and find Expressions property. Setup expression to modify the criteria dynamically.