Code

Re: Filtering and retrieving sharepoint list data

arcad — Mon, 31 May 2010 13:55:32 GMT

I am trying to set conditions when filtering. I am using the string-length function to determine if strings exist or not (FilterModel and FilterManufacturer are 2 drop downs). However, i am getting an "expression must evaluate to a node-set" error. Is there another way to determine the existence of a string when filtering? Thanks in advance!

XPathNavigator secDSNav = DataSources["SP_Data"].CreateNavigator();

string FilterModel = MainDataSource.CreateNavigator().SelectSingleNode("/my:myFields/my:Car/my:Car_Model", NamespaceManager).Value;

string FilterManufacturer = MainDataSource.CreateNavigator().SelectSingleNode("/my:myFields/my:Car/my:Car_Manufacturer", NamespaceManager).Value;

XPathNodeIterator rows = secDSNav.Select("/dfs:myFields/dfs:dataFields/dfs:group[(@Cat = 'Car' and @Car_Model = '" + FilterModel + "' and @Car_Manufacturer = '" + FilterManufacturer + "') or (@Cat = 'Car' and @Car_Manufacturer = '" + FilterManufacturer + "' and string-length('" + FilterModel + "') = 0) or (@Cat = 'Car' and string-length('" + FilterManufacturer + "') = 0 and string-length('" + FilterModel + "') = 0 )]", NamespaceManager);

Re: Filtering and retrieving sharepoint list data

arcad — Thu, 27 May 2010 17:23:14 GMT

Thanks a lot! My syntax was wrong.

Re: Filtering and retrieving sharepoint list data

Hilary Stoupa — Thu, 27 May 2010 16:39:30 GMT

When you use the variable test, your XPath looks like this, right?

"/dfs:myFields/dfs:dataFields/dfs:SPData[@Car_Model_SP = '" + test + "']"

Filtering and retrieving sharepoint list data

arcad — Thu, 27 May 2010 15:32:33 GMT

Hello all,

I am trying to retrieve specific rows from sharepoint only when a specific value in infopath equals a specific value in SharePoint.

Here is a piece of code

XPathNavigator secDSNav = DataSources["SharePoint Data"].CreateNavigator();

string test = MainDataSource.CreateNavigator().SelectSingleNode("/my:myFields/my:Car/my:Car_Model"_IP", NamespaceManager).Value;

// Retrieve the rows of the secondary data source

XPathNodeIterator rows = secDSNav.Select("/dfs:myFields/dfs:dataFields/dfs:SPData[@Car_Model_SP = 'test']", NamespaceManager);

It works fine if i change the[@Car_Model = 'test']", by a real value that exists in the list, e.g [@Car_Model = 'bmw']", but I cant filter using the variable test.

Do you have any ideas?

Thanks