Data Connections

Re: Filter on more than 1 value - owssvr - filterowssvr ?

Jimmy — Tue, 10 Jan 2012 14:03:51 GMT

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

Re: Filter on more than 1 value - owssvr - filterowssvr ?

djasp — Tue, 10 Jan 2012 13:54:49 GMT

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.

Re: Filter on more than 1 value - owssvr - filterowssvr ?

Jimmy — Tue, 10 Jan 2012 13:41:14 GMT

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.

Filter on more than 1 value - owssvr - filterowssvr ?

djasp — Tue, 10 Jan 2012 13:31:57 GMT

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,330
2.
https://server/_vti_bin/owssvr.dll?Cmd=Display&List={GUID}&XMLDATA=TRUE&FilterField1=ID&FilterValue1=71&330
3.
using a rule with filterowssvr doesn't do the trick also (it only works with 1 value)

but that does not work

Is 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.