Bi Publisher: Referring parent/child elements in xdofx

muthu1982

Summary

Bi Publisher: Referring parent/child elements in xdofx

Content

Hi,

I am trying to create an RTF template wherein a field value should use different elements based on a condition. I am using the below construct:

<?xdofx:if SupplierNumber='XXX' then Name else AddressLine1 end if?>

The elements Name and AddressLine1 are at different levels (Payee/Name, Payee/Address/AddressLine1). The condition is working fine but I am not sure if this will cause any issue as the element names are not given complete path and hence might refer to another XML element with the same names.

Could someone tell how we can refer to an element name within xdofx tag ensuring it picks up the correct path - may be using XPath or something?

Thank you,

muthu1982

Hi,

Thanks, but giving XPaths within the xdofx:if is not working.

Thanks,

Venkat Thota - BIP

https://myoracleappsworld.wordpress.com/2015/03/19/to-reference-a-parent-level-element-in-a-child-level-table-bi-publisher/

Venkat Thota - BIP

upload Template

Brajesh Shukla-95078

If you are in child group want to access the parent group element then you can use <.//ELEMENT_NAME> if you are two level down you can use <../../ELEMENT_NAME> and so on(depends on which level you are)

In reverse if you are in Parent tag and want to access the child element then you can specify the number in group e.g. G_DEPT/G_EMP[2]/EMP_NAME  in that under the department group there will be many employees but  it will pick the second employee name since we specified G_EMP[2]