AA Using the IN Clause in the Report Filter - Understanding 'Array Arguments'

Uploaded on Aug 16, 2013 / 180 views / 384 impressions / 0 comments

alpha01803

More from this user

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).

Tags

  • Alpha Five V12
  • ftp