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

Bug 333817

Summary:	Data set window does not show synonym and nickname for the selected Data Source
Product:	z_Archived	Reporter:	Ricky Mising name <rickyru01>
Component:	BIRT	Assignee:	Bin Feng <bin.feng>
Status:	CLOSED FIXED	QA Contact:	Xiaoying Gu <bluesoldier>
Severity:	normal
Priority:	P3	CC:	bluesoldier
Version:	unspecified
Target Milestone:	3.7.0 M7
Hardware:	PC
OS:	Windows XP
Whiteboard:

Description Ricky Mising name

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

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.