Qdabra qRules

Re: QRules Error - Parameter Count Mismatch

Hilary Stoupa — Mon, 03 Oct 2011 19:59:32 GMT

concat("FilterOwssvr /dsname=FilterOwssvr /filter=EvaluatorFilter /value=", ., " /delimiter=~")

for example...

Re: QRules Error - Parameter Count Mismatch

Lolly — Mon, 03 Oct 2011 19:54:28 GMT

What would be the syntax then? I'm not sure how to do this.

Re: QRules Error - Parameter Count Mismatch

Lolly — Mon, 03 Oct 2011 17:44:11 GMT

I will try changing the delimiter and will let you know my results. Thanks for responding so quick.

Re: QRules Error - Parameter Count Mismatch

Hilary Stoupa — Mon, 03 Oct 2011 15:16:28 GMT

Hi - FilterOwssvr command has an optional "delimiter" parameter that you can use for specifying what delimiter you wish to use instead of commas. That way you can use something that doesn't appear in your text (like "~") for a delimiter and your commas should be okay.

Re: QRules Error - Parameter Count Mismatch

Jimmy — Mon, 03 Oct 2011 14:23:00 GMT

Hello Lolly,

As the error message indicates, the most likely issue is that the value referred to by the dot in your formula most likely has one or more commas in it. Can you see if that is the case?

Or maybe the issue is that EvaluatorFilter is a field in your form that has commas in it, but you have it here as text in your command instead of concatenating it in?

Re: QRules Error - Parameter Count Mismatch

ErnestoM — Mon, 03 Oct 2011 12:59:37 GMT

Hi!

The rule pasted above looks ok but it would be helpful to look at it in the context of the form. Can you attach your form via the Options tab when you reply?

Thanks!

QRules Error - Parameter Count Mismatch

Lolly — Sun, 02 Oct 2011 01:09:13 GMT

I'm trying to filter a single SharePoint list using the FilterOwssvr command. It worked with no problem when I created a test list with City and State. However, now in trying to filter on an actual list, I am getting the error "Parameter count mismatch for filter and value. Please verify each parameter has the same number of comma-separated values." I have confirmed that both parameters have the same number of values. I have removed 'show only entries with unique values' and that does not help. Here's what I'm using for the rule: concat("FilterOwssvr /dsname=FilterOwssvr /filter=EvaluatorFilter /value=", .) Any help would be appreciated.