AA Using the IN Clause in the Report Filter - Understanding 'Array Arguments'
Uploaded on Aug 16, 2013 / 180 views / 380 impressions / 0 comments
Description
Video for UX_V12--57 and RPT_V12--6
Alpha Five V12 Reports in clause arg arrays
When you use Action Javascript to display a report, you specify the report filter. In the case of reports that are based on SQL data sources, you can now use the SQL IN clause in your filter expression. When you use the IN clause, the arguments you pass into the SQL statement must be configured as an "array argument". In this video, we show how you can easily configure the Action Javascript to display a report to use an IN clause and how you can make your argument into an array argument (Requires a connection string called "Northwind" to sample Northwind database; Also applies to the Grid and UX Component).