Bug 464091 - Limitation with number of Data Set Elements Returned in Data Explorer
Summary: Limitation with number of Data Set Elements Returned in Data Explorer
Status: NEW
Alias: None
Product: z_Archived
Classification: Eclipse Foundation
Component: BIRT (show other bugs)
Version: 4.4.2   Edit
Hardware: PC Windows 7
: P3 major (vote)
Target Milestone: ---   Edit
Assignee: Birt-ReportDesigner CLA
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-04-07 17:49 EDT by Fritz Kiffmeyer CLA
Modified: 2015-04-07 17:49 EDT (History)
0 users

See Also:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Fritz Kiffmeyer CLA 2015-04-07 17:49:48 EDT 
When getting a list of available data elements from a database schema within the (Exclipse/Birt Report Creator) Data Explorer, only the first 100 entries are returned for any given schema.  This makes it difficult to incorporate these additional elements within the SQL query for creating the report.

If another tool is used (SQL Workbench/J), using the same driver, connection string and user account, a complete listing of all data elements are returned.

The issue was found using the JTDS JDBC driver for MS SQL Server (version 1.3.1).

Steps to reproduce issue:
- Open Eclipse/ BIRT Report Creator
- Navigate to Data Explorer window
- Create Data Source (if one doesn't exist)
- Create Data Set
- Under Edit Data Set, select Query tab
- Select a schema with 100+ database tables or Stored Procedures listed
- Observe that all elements past the 100th are not listed.