How to filter a secondary data source in infopath 2010
-
2012年5月3日 上午 10:37
Hi, I've seen similar questions answered here before but i believe i am tackling a slightly different problem.
I have a large sharepoint list as a secondary data source and would like to know if there is a way to filter the results on load time before it can be used in repeating tables, dropdowns etc? I am able to achieve similar results by using the hide rule but this would load lots of unnecessary data which would slow the form down. I'm sure Microsoft have a solution to this but i just cannot find it in the menus. Can anybody advise how this can be done?
Thanks,
Andy
所有回覆
-
2012年5月3日 上午 11:32
Hi,
directly you can't do it.
But you can filter with a view of this list.
You must create a view in SP and, in Infopath, create a xml data conection and add the conection to this view:
http://<site>/_vti_bin/owssvr.dll?Cmd=Display&List={GUIDList}&View={GUIDView}&XMLDATA=TRUEHope to help you!Tomás González. Twitter://@tgmourino
- 已標示為解答 amidgley 2012年5月3日 上午 11:43
-
2012年5月3日 上午 11:43awsome, thanks a lot
-
2012年5月3日 下午 12:27
The owssrv.dll is a great solution that works in SP2010 as well as SP 2007.
I want to mention that InfoPath 2010 works really well with the SharePoint 2010 REST service interface, and you can do all kinds of filtering with the REST secondary data source.
http://johnliu.net/blog/2012/4/26/infopath-2010-query-using-the-rest-interface.html
Check it out. Really cool stuff that's not very well known.
jliu - http://johnliu.net - http://sharepointgurus.net
