Help with filtering on multiple parameters - InfoPath Dev
in

InfoPath Dev

Help with filtering on multiple parameters

Last post 06-29-2011 07:36 AM by neile120. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 06-28-2011 09:17 AM

    Help with filtering on multiple parameters

    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

  • 06-28-2011 09:39 AM In reply to

    Re: Help with filtering on multiple parameters

    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

    Hilary Stoupa

  • 06-29-2011 07:36 AM In reply to

    Re: Help with filtering on multiple parameters

    That worked perfectly thanks.

     Neil

Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.