BI Publisher RTF. xml - how can I return the proper data?
Hi,
This is for JDE BI Publisher.
I have an XML file in this format (unnecessary fields are removed).
When the value of "NameRemarkExplanation_ID39" is equal to the value of "Component_2nd_Item_Number_ID3" the corresponding value of "DescriptionLine1_ID7" should be returned. So when the value is N84246, "Panel, skirt panel mid 1h rh" should be returned.
This code is returning the "DescriptionLine1_ID7" field but the data is returned in the order is appears in the xml file. If the rows in "Manufacturing_Work_Order_Part_List_S65" are reversed the returned DescriptionLine_ID7 is incorrect.