Filter secondary data based on primary data values

Moumst — Thu, 23 Apr 2009 07:24:24 GMT

Hi there,

Is it possible to use the xdXDocument extension in XPathExpression within managed code function.

Let's say I need to extract some secondary data values for a specific treatment based on values contained in primary data source. In fact I need to get the same values I have in a given dropdown list box to populate a reapeating table.

Here is my problem:

DataSource dsPostes = DataSources["Secondary DataSource"];
XPathNavigator navPostes = dsPostes.CreateNavigator();
XPathNodeIterator listePostesEquipement = navPostes.Select("/dfs:myFields/dfs:dataFields/tns:GetAllDataResponse/tns:GetAllDataResult/ns1:Equipement/ns1:Poste[../ns1:Equipement = xdXDocument:get-DOM()/my:OrdreManoeuvre/my:ListeElementReseau/my:ElementRéseau]", NamespaceManager);

In other terms this is what I have in my combobox source data. But when I execute this query in managed code the xdXDocument is not present in the XsltContext. How can I access nodes of another datasource in my query? my:ListeElementReseau is a repeating field.

If it is not possible I will query the primary data source and loop through the repeating field values to query x times the secondary datasource. But if I can make the xdXdocument extension to work it will be more elegent ;)

I will appreciate any accurate answer ;)

Data Connections

Filter secondary data based on primary data values