InfoPath Dev

It seemed to be not enough for our web browser form, we have a couple secondary data connections pulling in thousands of rows of data. I wonder whether other people is having similar problem, and what is the best solution besides increasing the Response Size.

Thanks,

Wei

 

 

Where is the data being pulled from.  Do you need all of the thousands of rows in those data sources, or only a portion of them for any given document?

The data could be from sharepoint list or database. Right now we are pulling everything from them as we need to filter them based on User Input at run time.

Based on my search around this site, it seemed we need to have custom code if we cannot get around this 1500k limit, right?

Thx

Hello again,

You are correct that InfoPath's built-in functions do not support filtering.  Since the need to filter is an extremely common requirement for people, Qdabra has come up with some ready-made solutions to ease this pain, speed up your form and get around these limits.

DBXL is web service that resides on the server and allows you to perform filtered queries of SQL Server database and SharePoint list/library data, along with some other hefty features like mapping your XML data out to an SQL Server database.

qRules is managed code that resides in your InfoPath form and provides a whole slew of helpful features, one of them being a command that allows you to perform filtered queries of SharePoint list/library data.

Are you using the 2010 versions of both InfoPath and SharePoint?  If so, you may be able to use a REST webservice to do a filtered query of SharePoint lists if you're looking to go completely codeless.

Thanks for the info, i will take a look into the REST web services first, if we could not get around it still, will take a look at Qdabra tools.

I did a very brief test of the RESTful API, quite unfortunate for us is that the lists we are pulling data from are *External Lists*, and it seems that the Restful API are not including those lists.

Any comment on this? thx

 

Wei