Newbie Questions

Re: Help Filtering

Jimmy — Wed, 25 Feb 2009 16:13:49 GMT

I'm guessing it would be:

For Each queryResultRow As XPathNavigator In queryDataFields.Select("*[my:Machine_Name = 'LRD1CTX16']")

Though you may need a different namespace prefix (if that doesn't work try replacing my: with dfs:

XML node selection uses a language called XPath, not SQL. I recommend reading up on it a bit. It'll help your InfoPath experience in the long run:
http://www.w3.org/TR/xpath

Help Filtering

doctorcpu — Wed, 25 Feb 2009 15:49:12 GMT

I'm trying to filter using XPathNavigator. The first statement returns all rows and I'm trying to change it so that it only return rows where the Machine Name field is equal to a predetermine value ("LRD1CTX16").

For Each queryResultRow As XPathNavigator In queryDataFields.Select("*")

For Each queryResultRow As XPathNavigator In queryDataFields.Select("* where Machine_Name = LRD1CTX16")

Any help is appreciated.