InfoPath Dev

Hi,

I have some lookup lists on my Moss team Site like states and cities. Now Cities List contains a column as State within it. While fetching data for Cities in Infopath web based form using Secondary datasource, I want to filter tha data for a particular State. I need to show this data in a dropdown.

Can this be done by any chance. It is basically querying the List with a where condition. Till now I am not using and code behind for my form. Can we write some Xpath

Thanks,

Hi,

You can achieve this by connecting to GetListItems data connection. To know how to connect to this data connection, go through this blog.

http://www.infopathdev.com/blogs/agni/archive/2006/05/15/Query-for-Items-in-SharePoint-Form-Library-Using-GetListItems-Web-Method.aspx

Hi Santoshp,

Thanks for your quick reply. I have not used code behind till now and this is the only thing left in my form. Is there any other way without writing code to achieve this.

Hi Guptasourav and welcome to the forum,

You can filter the results after you download them. There are built in filter controls in InfoPath that will let you specify a value or a field. The only limitation is that you have to download everything so make sure your default view is not limited to 100 items (for example). We have a web service that supports filtering SharePoint lists on the server and it also does not require code, but it's not free either.... :)

I hope this helps you. If you are interested in learning about filtering, just search for it in the forum. You'll want to set up a data connector to your SharePoint list (sounds like you already have this), then add a dropdown to your form and set it to use values from the secondary data source (the SharePoint list connection) by double clicking and editing properties. When you select the node from the SharePoint list data source it will give you the option to filter.

Good luck!

 Hi Patrick,

Thanks for your reply. I am using a web enabled form and it does not support filter that you are talking about.