Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 315579

Summary: Better support for IN clause in SQL
Product: z_Archived Reporter: john mcteague <john.mcteague>
Component: BIRTAssignee: xiaofeng zhang <xiaofeng.zhang>
Status: CLOSED DUPLICATE QA Contact: Xiaoying Gu <bluesoldier>
Severity: enhancement    
Priority: P3 CC: bluesoldier, john.mcteague, mwu
Version: unspecified   
Target Milestone: Future   
Hardware: PC   
OS: Windows XP   
Whiteboard:

Description john mcteague CLA 2010-06-03 09:12:44 EDT 
Build Identifier: Birt 2.5.2

It should be trivial to provide better support for IN clause in queries that are bound to multi select parameters.

It should be possible to connect the fact a multiselect parameter is bound to a parameter in a dataset, and when that is identified, rewrite the query to replace a single ? with a serious of ?'s, one per entry selected in the list and then bind the values from the list.

Reproducible: Always
Comment 1 Xiaoying Gu CLA 2010-08-04 05:11:38 EDT 

*** This bug has been marked as a duplicate of bug 212063 ***