Code

Re: Using XPath to find a specific node in a secondary datasource

Talvalin — Tue, 07 Dec 2010 16:53:43 GMT

Thank you for your responses. I've since had to abandon this plan and have created another topic regarding the filtering of Sharepoint external lists here: http://www.infopathdev.com/forums/t/17791.aspx

Re: Using XPath to find a specific node in a secondary datasource

Jimmy — Sat, 04 Dec 2010 16:54:02 GMT

There are areas in browser forms where you can't use filters, but you should be able to use them in the value formula of a rule just fine.

Most likely the reason your formula is not working is that it should be:

/dfs:myFields/dfs:dataFields/tns:GetSitesByCompanyIdResponse/tns:GetSitesByCompanyIdResult/q1:Site/q1:AddressLine1[../q1:SiteId = siteId]

not that much longer version you have.

Re: Using XPath to find a specific node in a secondary datasource

Talvalin — Sat, 04 Dec 2010 12:28:55 GMT

From what I've read on the net, this can be achieved using rules and filters but I'm using a browser-enabled form so filters won't work right? I appreciate that I may not have a complete understanding of this problem as I'm very new to Infopath. The other problem I've encountered is that I can use rules to populate my site details, but I can only ever seem to populate details that correspond to the first site in the dropdown. Even if I choose a different site first, I only ever see the details for the first site. As a result of this, I've been trying to do this using code instead, but I'm encountering different problems now. If this can be achieved without code, then I'd love to do so. :)

Re: Using XPath to find a specific node in a secondary datasource

Hilary Stoupa — Fri, 03 Dec 2010 17:54:54 GMT

Hi -- this can be done in code, but ... why? I mean, you could use rules for this. Rules would go on the field that the drop down is bound to, and you could select the field from your main data source as the target and the field you want from your secondary data source as the value. I must be missing a step in your description of your problem that would require code?

Using XPath to find a specific node in a secondary datasource

Talvalin — Fri, 03 Dec 2010 17:44:41 GMT

Hello!

Background first: I've got a form that is receiving data via a WCF webservice and is called GetSitesByCompanyId. The data is run on load (with a hardcoded company id for testing) and used to populate a dropdown box of Site Names. What I'm trying to do is to use code to populate details for the site when a selection is made from the dropdown. I can match the site name with a site id (although this involved the possibly dodgy method of creating a dictionary of site name to site id and populating said dictionary on form load), but I cannot seem to formulate an XPath query that will find the appropriate details in the result set for the given site id.

Here's the code that I have. Any help would be greatly appreciated! If nothing else, a method for shortening the absolute paths I'm using would be good. :)

/////////////////////////////

// Set the site detail fields

DataSource dsSites = this.DataSources["GetSitesByCompanyId"];XPathNavigator xnSites = dsSites.CreateNavigator();

XPathNavigator addressLine1 = MainDataSource.CreateNavigator().SelectSingleNode("/my:myFields/my:SiteDetails/my:group4/my:AddressLine1", ns);

XPathNavigator addressLineResult = xnSites.SelectSingleNode("/dfs:myFields/dfs:dataFields/tns:GetSitesByCompanyIdResponse/tns:GetSitesByCompanyIdResult/q1:Site/q1:AddressLine1[/dfs:myFields/dfs:dataFields/tns:GetSitesByCompanyIdResponse/tns:GetSitesByCompanyIdResult/q1:Site/q1:SiteId=\"" + siteId.ToString() + "\"])", ns);