InfoPath Dev

One last thing as I know you've been very helpful (as always) and need to move on. What Xpath formula can I write using the "does not contain" action? As always thank you very much

So I can't really do that as the column in that table numbers in the thousands. I really need to find a DBA to clean it up : ) But just a question if the second list box does work using all of those does not contain doesn't that also mean that the data does match up?

Yes they are, actually. That make a difference in the expression now?

Unfortunately it did not. I see you removed Value at the start of the string. Can I ask what did you replace it with exactly?

I have the listbox in there three times. The second one is the one I put my filters in and the third one is the one being compared to the SP list with the Xpath Expression you gave me.

Sure here you go.

OK so I created my XPath Expression using your example and not getting any errors on that. But it's not filtering. I apologize as I'm unfamilar with this form and am trying to reverse engineer what was done. So it looks like what they're doing is using a udcx file to get the info from the SQL table. Next there's a text box that is ...

Hi Hilary, I apologize I mispoke there is no item limit on the list itself. What I initially meant is I'm using a filter on a listbox that is pulling data from a SQL table. I'm filtering that view using the "does not contain" filter with text. The text being the software names in the previously mentioned SP list. So in the SQl ...

Hello everyone is there any answer to this question?

Hello, so I have a 2010 form that is pulling from a SQL table a list of software and putting the information in a List Box (called Compare_Data) based on an entered computer name placed into a text box on same form (this is manually done by the user) and consequently there's a seperate SharePoint list with almost 120 entries of software names ...