Bugzilla – Full Text Bug Listing
| Summary: | facing problem in creating null parameter or optional parameter | ||||||
|---|---|---|---|---|---|---|---|
| Product: | z_Archived | Reporter: | Eswar <eswaramoorthy.rockers> | ||||
| Component: | BIRT | Assignee: | Birt-Data-inbox <Birt-Data-inbox> | ||||
| Status: | RESOLVED WORKSFORME | QA Contact: | Xiaoying Gu <bluesoldier> | ||||
| Severity: | normal | ||||||
| Priority: | P3 | CC: | bluesoldier, zqian | ||||
| Version: | unspecified | ||||||
| Target Milestone: | 3.7.0 | ||||||
| Hardware: | PC | ||||||
| OS: | Windows 7 | ||||||
| Whiteboard: | Obsolete | ||||||
| Attachments: |
|
||||||
Hi, Which BIRT version were you using? I can not reproduce this issue in the 2.6.0 RCP release build. Please refer to the attached report design which is same to the design you described. Created attachment 179087 [details]
sample report
Set as worksforme based on comment #1. Please feel free to reopen if these is any issues. |
Build Identifier: Version: 3.4.2 Build id: M20090211-1700 Hi. I have focused to create optional parameter .such that if i didn't give the values of the parameters the default query has to run. here is my query : select * from APPA.APPA_JOURNAL_VOUCHERS where APPA.APPA_JOURNAL_VOUCHERS.JV_DATE > = ? and APPA.APPA_JOURNAL_VOUCHERS.JV_DATE < = ? and APPA.APPA_JOURNAL_VOUCHERS.BRANCH_CODE is NULL andd i have used beforeopen script for dataset as : if(params["branch_code"].value) { this.queryText = " select * from APPA.APPA_JOURNAL_VOUCHERS where APPA.APPA_JOURNAL_VOUCHERS.JV_DATE > = ? and APPA.APPA_JOURNAL_VOUCHERS.JV_DATE < = ? and branch_code = " + params["branch_code"]; } error i got is : org.eclipse.birt.report.engine.api.EngineException: Cannot get the result set metadata. SQL statement does not return a ResultSet object. SQL error #1: ORA-00904: "HYD": invalid identifier Reproducible: Always