Skip to Main Content
Forums

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Converting RDF to XML attributes?

dsscottJan 13 2022 — edited Jan 13 2022

We have been converting some Reports 12.2.1.4 reports to XML for version control. We noticed that if we modified a query in Report Builder and then converted the RDF to XML some of our columns (from query) had an attribute named columnFlags changed from the previous version. Does anyone know what this attribute is and why it would change?

Comments

rbglossip
Try removing the null from the second query of the union. You have null aliased as DateClosed in the first but a column aliased as DateClosed in the second.
FLROOPENHEAD.DATEOPENED DateOpened,NULL DateClosed,
FLROHISTHEAD.DATEOPENED DateOpened, null, FLROHISTHEAD.DATECLOSED DateClosed,
1 person found this helpful
Umesh Gupta
Please post ur table structure and some sample data for clarifiaction..

Regards

Umi
1 person found this helpful
user639304
Hi OraclePLSQL,

In your union operation, the first select has four columns and the second select has five columns.

Hope this helps.
1 person found this helpful
Achyut K
Hi,

On comparison with 1st query and 2nd query,it can be easily noticed that ,1st query is returning 4 columns and 2nd query returns 5 columns in select clause.
In order to work union ,both of your queries should select equal no of columns.

Hence replace your query

Original query(1st ) :
SELECT FLROOPENHEAD.RONBR RepairOrder,FLROOPENHEAD.DATEOPENED DateOpened,NULL DateClosed, 
 (SELECT FLREPAIRSTAT.DESCRIPTION  FROM FLREPAIRSTAT 
 WHERE FLREPAIRSTAT.REPAIRSTATID = FLROOPENHEAD.REPAIRSTATID) RepairOrderStatus,
....
Relplace with : 
 
SELECT FLROOPENHEAD.RONBR RepairOrder,FLROOPENHEAD.DATEOPENED DateOpened,NULL,/*Here you need missed the comma */
 DateClosed, 
 (SELECT FLREPAIRSTAT.DESCRIPTION  FROM FLREPAIRSTAT 
 WHERE FLREPAIRSTAT.REPAIRSTATID = FLROOPENHEAD.REPAIRSTATID) RepairOrderStatus,
....
Hope this helps

Regards,
Achyut
1 person found this helpful
1 - 4

Post Details

Added on Jan 13 2022
#reports
0 comments
227 views