Data Connections

Re: Create query form with data connection to SharePoint list

Patrick Halstead — Wed, 03 Dec 2008 00:40:31 GMT

Sorry I missed this last week. SharePoint lists can be queried with our Web Service http://www.infopathdev.com/files/folders/dbxldownload/entry34123.aspx . Comes with a query builder tool that makes it easy to build custom queries. After installing the Web Service, just create a UDC connection in your connection library to the Web Service and add that to your form. Then, the data will come into your secondary data source and you can copy it to your primary data source. Contact us to see a demo. I believe we will be creating a video of this soon.

Re: Create query form with data connection to SharePoint list

clawrence — Mon, 24 Nov 2008 14:28:33 GMT

Okay, but can I create a connection library in SharePoint containing the information from the list, and create a primary data source that way?

Re: Create query form with data connection to SharePoint list

Clay Fox — Sun, 23 Nov 2008 02:49:53 GMT

That is correct Sharepoint lists cannot be queried.

Your choices are setup a secondary data conenction, which will load the whole list, then jsut filter a repeating section to only show the one they wanted or "queried". The drop back is performance of loading all records.

Or put the data in a database instead, you have SQL on the Sharepoint server, and then you can create a form based on the data and perform queries on it.

The very best is to database you enterprise solutions and then use web services like qdabra provides. Then you can query and submit to multiple tables and query and submit to sharepoint.

Create query form with data connection to SharePoint list

clawrence — Fri, 21 Nov 2008 19:29:50 GMT

I'm trying to create a query form - basically, I want a user to be able to type in a customer account number, hit search, and other boxes will auto-poulate with company, address, phone, etc.

I've got all the customer information in a SharePoint list - can I connect to this for a query? Everything I've been able to find suggests that a SharePoint list can't be set up as a primary data source, only a secondary, and that a query can't be run off a secondary data source...

Thanks for any advice!