Loading...

qSelector Filter for unique values

qSelector Filter for unique values

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • #3960
      Anonymous
      Anonymous
      Participant

      I have a list view where the manager is listed one column and the employee is listed in another.  Each manager may have 20 different employees.  I am using the qSelector to try and filter the manager and display all the employees for that manager.  The CBTs cover the Connections Provide Row To>but that is now obsolete.  I have configured the qSelctor to Sent Row Row To>?qListForm and then selcted Manager, but each manager shows up the same number of times in the qselector that is in the list.  I am trying to get it to only show one instance per manager.

      Thanks for your help,

    • #4769
      Anonymous
      Anonymous
      Participant

      Hello ,

      I would suggest that instead of using the Provider/Consumer web part connections, try this using session variables to filter employess by the selected manager instead. In qSelector, you need to provide a Session Name and enable Refresh Page When Selection Changed checkbox. In qListView, you can create a CAML filter condition that filters the rows based on the Session Name you gave to qSelector.

      Unfortunately we do not yet support rendering unique values in a qSelector that is configured to a list which contains duplicate values for the display column. As a workaround, you could create a custom list that holds the unique names of all the managers, and configure qSelector to this custom list, so that you do not see duplicate options in the dropdown.

      Thanks,

      Yuan

Viewing 1 reply thread

You must be logged in to reply to this topic.