Hello,Is it possible to filter om more than 1 value if you have a xml dataconnection like this:http://server/_vti_bin/owssvr.dll?Cmd=Display&List={GUID}&XMLDATA=TRUE?I want to filter my sharepoint list down to only the rows where the ID is a certain value to speed up my form. I know the ID's to filter on and sometimes it's 1 id (that works) but most of the time it's more than 1 (2 or 3 of more)i've tried:1.https://server/_vti_bin/owssvr.dll?Cmd=Display&List={GUID}&XMLDATA=TRUE&FilterField1=ID&FilterValue1=71,3302.https://server/_vti_bin/owssvr.dll?Cmd=Display&List={GUID}&XMLDATA=TRUE&FilterField1=ID&FilterValue1=71&3303.using a rule with filterowssvr doesn't do the trick also (it only works with 1 value)but that does not workIs there another way to do it?
Another question i have is if you can filter on a range. For example only the rows which are created between Date1 and Date2.
Thank you very much.
It doesn't appear that there is a way to do this. You wouldn't happen to be using ShP 2010 are you? If so, you could use its OData features to construct a more complex query.
Hi,Yes we have SP2010. Does that also work for people using infopath 2007 or newer?I guess i have to learn how to use the OData stuff.
OData utilizes a REST webservice like owssvr, so in IP2007, you'll either need code or you can use qRules as I describe in this blog post:
http://www.infopathdev.com/blogs/jimmy/archive/2012/01/04/query-rest-webservices-from-infopath-2007-with-qrules.aspx
You can have a look at Hilary Stoupa's Channel9 video to get up to speed on OData:
http://channel9.msdn.com/Blogs/donovanf/Infopath-2010-OData-and-Cascading-Filtering-in-Forms