Qdabra qRules

Re: passing multiple values to the filterowssvr for a query

Patrick Halstead — Tue, 21 Jun 2011 00:21:02 GMT

Hi Serenity,

We have another tool that supports very complex queries. It's bundled in the DBXL Web service and you will need to install on the ShP server. Easy to use though and we have lots of documentation.

Cheers!

Re: passing multiple values to the filterowssvr for a query

RandomSerenity — Mon, 20 Jun 2011 18:13:45 GMT

That would probably be the issue. We’re in 2007 here still so it sounds like I will find a creative solution to this!

Thanks!

Re: passing multiple values to the filterowssvr for a query

Hilary Stoupa — Mon, 20 Jun 2011 17:59:12 GMT

To my knowledge, owssvr.dll doesn't handle complex queries like that. What version of SharePoint are you using? If 2010, you may want to use the OData service.

Re: passing multiple values to the filterowssvr for a query

RandomSerenity — Fri, 17 Jun 2011 17:16:52 GMT

That somewhat clears it up, but what if Deduction options are Charity OR Medical Price can be 1000 OR 500?

Re: passing multiple values to the filterowssvr for a query

ErnestoM — Fri, 17 Jun 2011 17:04:49 GMT

That command supports multiple filters, like this:

FilterOwssvr /dsname=FilterOwssvr /filter=Deduction,Price /value=Charity,1000

(comma delimit both the filter and value parameters)

Hope this helps.

passing multiple values to the filterowssvr for a query

RandomSerenity — Fri, 17 Jun 2011 16:51:05 GMT

I'm using multi-select list boxes to filter a huge list which I want to use to populate a repeating table with the Insert command. However, I'm unable to find the syntax for the URL protocol that supports multiple values so I can populate my Command field to fire the XML query.

Is this not possible?

Thanks in advance,
Beckie