Build bip template when xml have nested levels

Chez

Summary

Build bip template when xml have nested levels

Content

Hi All

I am trying to build an age analysis template from the Aging from the Aging - 7 Buckets - By Account Report. The xml is attached and the template thus far built. The results of the template as it stands now is correct however I only want data extracted for two of the INV_TID. I am getting all the records for all INV_TID's (Accounts).

The problem is that the INV_TID values lies in an upper level in the xml layout and it is only presented once for each INV_TID (Account)

You will see there are multiple INV_TID's and for each one the listed customers and there balances. As example I only want all the customer data as in my template that relate to INV_TID 01 00 00 000 60150 000 000 and 01 00 00 000 60154 000 000.

All other records should not pull into the data results.

How can I achieve this?

Any help would be most appreciated.

 

Thanks

 

Cheryl

 

 

 

 

Version

BIP 12.2.1.4.0

User910243567

You can try Conditional Formatting and use IF Condition to display only values corresponding to INV_TID values you desire. Though INV_TID is at higher level you can fetch value for the same into your for each group.

Something like this...

<?for-each@section:TEST1?>
<?if:INV_TID =’01 00 00 000 60150 000 000’?>

Fields you want to display
<?end if?>
<?end-for-each ?>

Refer below for this

https://docs.oracle.com/middleware/12212/bip/BIPRD/GUID-04477E49-F671-4BF1-8353-06A7CDEAD2CC.htm#BIPRD2481

Chez

Thank you for your post Suresh. I was however able to achieve what I wanted with the following command. <?if:number(../../SORT_FIELD2)<2000 and TOTAL_CUST_AMT != ''?>

Regards

 

Cheryl