Ever wanted to give users the ability to limit source records dynamically? How about being able to filter records from in a source query by a date range? Well, I encoutered this situation working on my current project.
Out of the box, Integration Manager offers the ability to retrieve records and set static filters to source records. However, in many cases users may want to dynamically (at runtime) establish a date range or any other range parameter for the records, then have these ranges applied to the source query.
This is possible by using some old fashioned VBScript with Integration Manager. Consider the following records:
In order to make our integration interactive, we must first prompt the user to enter the date restriction in the format required to filter the data:
Now we can apply the user’s input as restrictions to our source query data by invoking the AdditionalCriteria property of the Query object.
Note that the Query.AdditionalCriteria will only work on source queries that use a Text or Simple ODBC DSN. The AdditionalCriteria property will not work on Advanced ODBC queries.
Until next post!
Mariano Gomez, MVP
Maximum Global Business, LLC