on 03-18-2008 8:15 AM
Hi,
In query template I am getting the column names dynamically, I want to show Alias instead of column names but in Oracle, column Alias has a limit of 30 char.
How can I show the Alias with more than 30 char in Query Template? I need to export the output of Query to Excel and HTML.
Thanks,
Anil
Hi Anil,
You could use an inline transform by applying an XSL stylesheet. You could specify the long alias in the stylesheet itself.
Alternatively, you could use a Business Logic Transaction. It has a Column Alias Action Block. The output of the Column Alias Action Block would be linked to a Transaction Output Property.
The data flow will be as follows:
Datasource - Query Template 1 - Transaction with Column Alias Action Block - Query Template 2 - Excel/HTML
Query Template 1 will be of Type SQL.
Query Template 2 will be of Type Xacute.
Cheers,
Jai.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
8 | |
7 | |
3 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.