Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » How to display table based on dynamic table name
How to display table based on dynamic table name [message #893378] Tue, 03 July 2012 14:47 Go to next message
Tomas Greif is currently offline Tomas Greif
Messages: 52
Registered: September 2010
Member
Hi,

I have created data warehouse documentation and I'm using BIRT (2.6) as a presentation layer. I would like to give the user the opportunity to preview some rows from each table. However, I need to make this dynamically, because there is a lot of tables. I do have name of the table stored in database (FullTableName).

Is there a way how to use this a parameter and show table content to the user?

Thank you for any ideas.

Tomas

Report message to a moderator

Re: How to display table based on dynamic table name [message #893791 is a reply to message #893378] Thu, 05 July 2012 09:43 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member
Tomas

Are you saying that the parameter FullTableName, is the name of a table
that contains a field with names of other tables you want to show?

Jason

On 7/3/2012 2:47 PM, Tomas Greif wrote:
> Hi,
>
> I have created data warehouse documentation and I'm using BIRT (2.6) as
> a presentation layer. I would like to give the user the opportunity to
> preview some rows from each table. However, I need to make this
> dynamically, because there is a lot of tables. I do have name of the
> table stored in database (FullTableName).
> Is there a way how to use this a parameter and show table content to the
> user?
>
> Thank you for any ideas.
>
> Tomas

Jason Weathersby

BIRT Exchange

Report message to a moderator

Re: How to display table based on dynamic table name [message #894445 is a reply to message #893791] Mon, 09 July 2012 05:26 Go to previous messageGo to next message
Tomas Greif is currently offline Tomas Greif
Messages: 52
Registered: September 2010
Member
Jason,

I do have name of the table stored in table (dw_description_table) in the column named physical_table_name. I also do have list of columns in table dw_description_column. Im attaching:
- sample data (Note that there is foreign key in dw_description_column (table_description_key) that links to table in dw_description_table)
- screenshot of current report - it might help you to understand my problem better.

Regards,

Tomas

[Updated on: Mon, 09 July 2012 05:27]

Report message to a moderator

Re: How to display table based on dynamic table name [message #895108 is a reply to message #894445] Wed, 11 July 2012 13:16 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member
In the tables that you are looking up do they all have the same column
metadata?

Jason

On 7/9/12 5:26 AM, Tomas Greif wrote:
> Jason,
>
> I do have name of the table stored in table (dw_description_table) in the column named physical_column_name. I also do have list of columns in table dw_description_column. Im attaching:
> - sample data (Note that there is foreign key in dw_description_column (table_description_key) that links to table in dw_description_table)
> - screenshot of current report - it might help you to understand my problem better.
>
> Regards,
>
> Tomas
>

Jason Weathersby

BIRT Exchange

Report message to a moderator

Re: How to display table based on dynamic table name [message #895211 is a reply to message #895108] Thu, 12 July 2012 02:44 Go to previous messageGo to next message
Tomas Greif is currently offline Tomas Greif
Messages: 52
Registered: September 2010
Member
Not sure I understand your question - all the metadata are stored in two tables, the metadata columns are the same for every table. Of course, values are different for every table as tables have different number of columns, different names of columns and different data types too.

Report message to a moderator

Re: How to display table based on dynamic table name [message #895390 is a reply to message #895211] Thu, 12 July 2012 12:44 Go to previous message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member
I assume you want to create the inner table in the report dynamically.
The only way I know how to do this is to call the data engine api in the
beforeFactory to make design changes. The beforeFactory or onPrepares
are the only location where the design can be altered in that fashion.
Take a look at this thread.

http://www.eclipse.org/forums/index.php/m/892804/

Jason


On 7/12/12 2:44 AM, Tomas Greif wrote:
> Not sure I understand your question - all the metadata are stored in two
> tables, the metadata columns are the same for every table. Of course,
> values are different for every table as tables have different number of
> columns, different names of columns and different data types too.

Jason Weathersby

BIRT Exchange

Report message to a moderator

Previous Topic:How to pass a parameter with in the page??
Next Topic:Return a byte[] array from Java extension function to JavaScript
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 23 18:37:14 EDT 2013

Powered by FUDForum. Page generated in 0.02422 seconds