Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.
Bug 333817 - Data set window does not show synonym and nickname for the selected Data Source
Summary: Data set window does not show synonym and nickname for the selected Data Source
Status: CLOSED FIXED
Alias: None
Product: z_Archived
Classification: Eclipse Foundation
Component: BIRT (show other bugs)
Version: unspecified   Edit
Hardware: PC Windows XP
: P3 normal (vote)
Target Milestone: 3.7.0 M7   Edit
Assignee: Bin Feng CLA
QA Contact: Xiaoying Gu CLA
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-01-09 22:10 EST by Ricky Mising name CLA
Modified: 2011-03-30 00:41 EDT (History)
1 user (show)

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 Ricky Mising name CLA 2011-01-09 22:10:18 EST 
Build Identifier: all

As we know, the TABLE_TYPE has the categories such as "TABLE", "VIEW", "SYSTEM TABLE", "GLOBAL TEMPORARY", "LOCAL TEMPORARY", "ALIAS", "SYNONYM" ,"NICKNAME" and so on..

But in BIRT data set window , user just can see the tables and views listed in the left panel. If I have a synonym representing a table in Oracle, or If I have a nickname pointing to a table in the database which my IFS(Infosphere Federation Server) is linking to, I can not see them. 

I know there is a workaround that we can directly type the object name(synonym or nickname) in the SQL text area, but, it is better to display them.

Reproducible: Always

Steps to Reproduce:
1.Create a data source pointing Oracle or IFS server
2.Create a data set using the above created data source.
3.Try to find the synonyms(for Oracle) or nicknames(IFS) in left panel.
Comment 1 Bin Feng CLA 2011-03-30 00:41:28 EDT 
Add a "Show alias" checkbox to enable list alias and synonyms tables. When it is enabled, alias and synonyms tables are list as other tables/views. Otherwise, alias and synonyms tables are not displayed.