| Data set window does not show synonym and nickname [message #647578] |
Fri, 07 January 2011 02:02  |
Eclipse User |
|
|
|
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 09:23  |
| Eclipse User |
|
|
|
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
|
|
|
Powered by
FUDForum. Page generated in 0.02806 seconds
Home