Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Data set window does not show synonym and nickname(Seems just show table and view)
Data set window does not show synonym and nickname [message #647578] Fri, 07 January 2011 07:02 Go to next message
Ricky Missing name is currently offline Ricky Missing name
Messages: 6
Registered: January 2011
Junior Member
Dear friends,

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 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. Is this a bug of BIRT?

I know there is a workaround that we can directly type the object name(synonym or nickname) in the SQL text area, but, customer wants to see them in the left panel.

Thanks,
Ricky
Re: Data set window does not show synonym and nickname [message #647642 is a reply to message #647578] Fri, 07 January 2011 14:23 Go to previous message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Can you open a bugzilla request for this?

Jason

On 1/7/2011 2:02 AM, Ricky wrote:
> Dear friends,
>
> 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 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. Is this a bug of BIRT?
>
> I know there is a workaround that we can directly type the object
> name(synonym or nickname) in the SQL text area, but, customer wants to
> see them in the left panel.
>
> Thanks,
> Ricky
Previous Topic:Shared development environment - rptlibrary, styles
Next Topic:Proper aggregated file sizes
Goto Forum:
  


Current Time: Thu Sep 18 13:46:54 GMT 2014

Powered by FUDForum. Page generated in 0.29947 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software