Contains filter on SP2010 list not working

nbarnes — Mon, 16 Jul 2012 08:55:29 GMT

Hi all,

I am trying to create a form to display the data from several SharePoint 2010 custom lists on the same page. The data is to be viewed only, there is no editing required just a search function to filter the main list, which in turn filters the other secondary lists. Unfortunately, Im falling at the first hurdle here as I cant get the 'contains' filter to work for the search function.

My main SP2010 list has a column "SearchCalc" which is a concatenation of all the other columns, I then use a sharepoint workflow to turn this calculated field into a plain single line text field "Searchable".

When I try to set the default value of any field on my form using "Searchable contains SearchText" as the filter, it doesnt work. It will only filter the field correctly if I enter all of the text from the Searchable field into the SearchText box.

So if I enter "Watford" into the SearchText box, nothing happens. However, if I enter "Watford, London, WD18" then the Search succeeds and all the default values are set.

Does anyone have any idea why the 'contains' filter is not working correctly? Currently, it is acting as though I've set the filter to 'is equal to" rather than "contains"?!

I hope that makes sense

Thanks for your help

Nick

SharePoint Integration

Contains filter on SP2010 list not working