This example shows two methods to include an ALL parameter for a data set.
Clement Wong
E mod
This is an updated version of this DevShare (http://developer.actuate.com/community/forum/index.php?/files/file/1068-simple-example-of-select-all-parameter/) with a database as a data source.<br />
<br />
The attached design has two examples that illustrates changing the SQL statement in the beforeOpen of the Data Set, and includes another that uses a Filter of the Data Set.<br />
<br />
The advantage of using the first method is that the result set returned from the database will be trimmed down.<br />
<br />
Using the second method of the Filter will return all results to BIRT, and then BIRT will perform the filtering, which, typically, will be less efficient than the first method.<br />
<br />
Please also review this blog (http://birtworld.blo...statements.html) about the possibility of SQL injection.
<br />
The attached design has two examples that illustrates changing the SQL statement in the beforeOpen of the Data Set, and includes another that uses a Filter of the Data Set.<br />
<br />
The advantage of using the first method is that the result set returned from the database will be trimmed down.<br />
<br />
Using the second method of the Filter will return all results to BIRT, and then BIRT will perform the filtering, which, typically, will be less efficient than the first method.<br />
<br />
Please also review this blog (http://birtworld.blo...statements.html) about the possibility of SQL injection.
Warning
No formatter is installed for the format ipb
0
Categories
- All Categories
- 107 Developer Announcements
- 53 Articles
- 104 General Questions
- 141 IM Services
- 43 OpenText Hackathon
- 32 Developer Tools
- 20.6K Analytics
- 4.1K AppWorks
- 8.9K Extended ECM
- 898 Cloud Fax and Notifications
- 76 Digital Asset Management
- 9.3K Documentum
- 29 eDOCS
- 118 Exstream
- 39.8K TeamSite
- 1.7K Web Experience Management