Newbie Questions

Re: Filter Data to exclude certain items in sharepoint list

ErnestoM — Wed, 10 Apr 2013 15:44:59 GMT

In InfoPath/Sharepoint 2010 you can set the queryField to filter the data on the server. That's the best option - faster performance.

If you bring in all the items into the data connection (without a filter), then you will need to filter in the dropdown itself, when configuring the dropdown properties, in the Entries box.

Re: Filter Data to exclude certain items in sharepoint list

Doreen — Wed, 10 Apr 2013 15:44:11 GMT

You could put the items (e.g. a textbox control or any other kind of control) in its own section control, then set a condition in the properties of the section control to hide it based on some other value in the form. I use a "Status" field quite a bit to control what is visible or not visible during the life of the form....

Re: Filter Data to exclude certain items in sharepoint list

callaway59 — Wed, 10 Apr 2013 15:38:13 GMT

Thank you for your response. I am not quite sure what you mean by filter the data on the canvas. I am already returning all the data from the list. I just want to exclude 3 items from showing.

Re: Filter Data to exclude certain items in sharepoint list

ErnestoM — Wed, 10 Apr 2013 15:24:44 GMT

I don't believe filters allow excluding, only including.

So if you have 10 list items with Column1=A and 3 list items with Column2=B, you could filter to return only the items where Column1=A (thus excluding the 3 items with Column2=B).

However, you cannot filter (a default data connection) with a filter like Column2 is not equal to B.

One alternative might be to return ALL items in the list, and then filter the data on the canvas. A dropdown list box will allow a filter on the selection made in "Entries".

Good luck!

Filter Data to exclude certain items in sharepoint list

callaway59 — Wed, 10 Apr 2013 15:17:00 GMT

I have created an Infopath form in 2010 that has a repeating table with a dropdown list box that displays items from a particular SharePoint list. I have been asked to ensure that when the form is displayed (Browser Based) that 3 of the items in the list be removed. I am unsure how to do this and any help would be greatly appreciated.

Thanks.