I have an expression box with the value...
xdXDocument:GetDOM("GetWhosWho")/dfs:myFields/dfs:dataFields/ns3:GetListItemsStrResponse/ns3:GetListItemsStrResult/Rows/row/Email[../Region = xdXDocument:get-DOM()/my:myFields/my:FormCalculationsGroup/my:TopNonBlankRegionalGroup and ../Role = "Regional EVP"]
And this brings me the correct value (email) from my secondary data source GetWhosWho
I have a field with the same xml...
xdXDocument:GetDOM("GetWhosWho")/dfs:myFields/dfs:dataFields/ns3:GetListItemsStrResponse/ns3:GetListItemsStrResult/Rows/row/Email[../Region = xdXDocument:get-DOM()/my:myFields/my:FormCalculationsGroup/my:TopNonBlankRegionalGroup and ../Role = "Regional EVP"]
The field does not bring me back any value.
I think the xml for the TopNonBlankRegionalGroup (a field) is fully defined (ie.starts at the root). I can't see why it does not return a value.
Can someone please point me in the right direction.
Thank you
Catharine.