Qdabra qRules

Re: Help with filtering on multiple parameters

neile120 — Wed, 29 Jun 2011 14:36:05 GMT

That worked perfectly thanks.

Neil

Re: Help with filtering on multiple parameters

Hilary Stoupa — Tue, 28 Jun 2011 16:39:04 GMT

This part of your formula needs to change:

userid, prod_code

You're not passing in comma separated values here, instead you're concatencating those two values. Try this instead:

userid, ", ", prod_code

Help with filtering on multiple parameters

neile120 — Tue, 28 Jun 2011 16:17:57 GMT

Hello

I'm trying to filter a single SharePoint list using the FilterOwssvr command. I've got it to work fine when filtering against a single parameter but I can't get it to run when using multiple fields.

I've tried using concat("FilterOwssvr /dsname=FilterOwssvr /filter=Rep_x0020_Logon, Product_x0020_Code /value=", userid, prod_code) but this doesn't filter and I get the error message "Parameter count mismatch for filter and value. Please verify each parameter has the same number of comma-separated values."

Any ideas on where i'm going wrong?

Thanks in advance

Neil Elliker