Loading...

Complex Filter Query

Complex Filter Query

  • This topic is empty.
Viewing 4 reply threads
  • Author
    Posts
    • #5230
      Anonymous
      Anonymous
      Participant

      Hi Geof,

        I tried your scenario using QWP 5.7 for SP2010 and it worked for me using the following syntax:

      a. Custom field of type Text called CountryID

      CountryID='CAN'

      b. Custom field of type Number called SecID

      SecID=1

      c. Custom field of type Text called Country ID2

      Country ID2='US'

      Don't replace the space neither add parenthesis to the field name. Use parenthesis only if you have multiple conditions in the complex filter.

      What's your QWP and SP version?

    • #5810
      Anonymous
      Anonymous
      Participant

      Hi there ,

      Hope you’re well!

      Thanks a lot for getting back,

      Ok tried using PARENT ID=1 (which is in the Qpanelmenu as a valid column) and that got rid of the error but now another has appeared in its place:

      The following error occurred: The given key was not present in the dictionary.

      QWP Version is 5.7

      SharePoint 2010 Version is 14.0.6112.5000

      Cheers so far! Now what is going on with that next error?

      G

    • #5811
      Anonymous
      Anonymous
      Participant

      Hi Geoff,

      I don't see the error in my env.

      What happens if you reload the page?

      Are there any duplicates in the list used in the qPanelMenu? Are you aggregating multiple lists?

    • #4194
      Anonymous
      Anonymous
      Participant

      Hi Folks,

      Am trying to construct a simple complex filter but for any field I try in the relevant list I get the error:

      The following error occurred: The field NAMEOFFIELD specified in the filter expression does not exist.

      The field I am trying to use is one of the defaults from qPanelMenu called PARENT ID. I’m trying only to display a section of the menu whose parent id is equal  to 1, so my complex filter variants I have tried (and all of these bring up the same error) are:

      Parent%20ID = 1

      Parent_ID = 1

      [Parent ID] = 1

      ([Parent ID] = 1)

      Please advise where I’m going wrong?

      Cheers

      Geoff

    • #6039
      Anonymous
      Anonymous
      Participant

      Hi there,

      Reloaded the page, same result. There are no dups in the qPanelmenu, in fact, when I remove PANEL ID=1 from the filter the menu list displays with no problems. Will check in another environment whether the problem persists and get back to you…

      Cheers

      G

Viewing 4 reply threads

You must be logged in to reply to this topic.