Multi-Select filter option for non-picklist fields

edited June 25, 2020 in Ideas
In the new Superbank release, there's now the option to add a multi-select filter to a table. This is great but only seems to allow picklist fields to be used. We really need to be able to use fields like "OwnerId" (for multiple user filtering) and "RecordTypeId" (for multiple record type filtering). Could we not provide a model for the selectable options like we can currently with a regular "select option"Β filter?

It would also be great if the new automatic condition table filtering could use non-picklist fields.
4
4 votes

Implemented Β· Last Updated

Comments

  • Zach McElrathZach McElrath Principal Software Engineer Chattanooga, TN πŸ’ŽπŸ’ŽπŸ’Ž
    edited March 2, 2017
    Oliver, we are working to expand the scenarios where Multi-Select filters are available --- didn't make it into the initial Superbank release, but it may appear soon, stay tuned!
  • Pat VachonPat Vachon πŸ’ŽπŸ’ŽπŸ’Ž
    edited June 25, 2020
    I second this.
  • Pat VachonPat Vachon πŸ’ŽπŸ’ŽπŸ’Ž
    edited June 25, 2020
    Got this work without issue by manually setting the table filter type to "multiselect" and conditions to multiple specified values.
    image
    image

    Resulting queries work as expected.
    image
  • Rob HatchRob Hatch πŸ’ŽπŸ’ŽπŸ’Ž
    edited September 1, 2016
    You may have discovered a feature we didn't specifically build. Cool!
  • Zach McElrathZach McElrath Principal Software Engineer Chattanooga, TN πŸ’ŽπŸ’ŽπŸ’Ž
    edited June 25, 2020
    As of the GA Superbank release, which has been pushed to all Production and Sandbox orgs as of last Friday night, Multi-Select filters are available on Picklist, Multipicklist, and Reference (lookup/master-detail) fields. So you shouldn't have to use Pat Vachon's hack to get this to work, we spent a lot of time working on adding in Reference field support over the past month.
  • Pat VachonPat Vachon πŸ’ŽπŸ’ŽπŸ’Ž
    edited January 5, 2016
    Maybe I'm missing something but I can't figure out how to get it to work. I don't get "Pick Options and Conditions" when selecting "Multi Select Option" as the filter type.

    I want the options to only be from another model I set up where the records are related to the current "Job".
  • Zach McElrathZach McElrath Principal Software Engineer Chattanooga, TN πŸ’ŽπŸ’ŽπŸ’Ž
    edited December 21, 2016
    Pat, some mis-communication here --- you are correct, there is not a "supported" way to do a Multi-select Filter where you "Pick Options and Conditions", so your method works for this approach. What I was referring to is the ability to do Multi-selects on Reference fields where Pick Options and Conditions is "Automatically" --- this is the new capability. So no, there's no supported way to do it manually on Reference fields where you pick a Model source to use, but you can do it Automatically.
  • Pat VachonPat Vachon πŸ’ŽπŸ’ŽπŸ’Ž
    edited January 5, 2016
    I'm still missing something then.



  • Rob HatchRob Hatch πŸ’ŽπŸ’ŽπŸ’Ž
    edited September 1, 2016
    Pat - what version of Skuid are you running in this org?Β 
  • Pat VachonPat Vachon πŸ’ŽπŸ’ŽπŸ’Ž
    edited January 5, 2016
    6.8.1
  • Rob HatchRob Hatch πŸ’ŽπŸ’ŽπŸ’Ž
    edited September 1, 2016
    Weird, Β cuz I can get the type ahead to populate values for reference fields in aggregate models.. Both directly on the object and on the parent object.Β 

    We recognize that the type ahead is not as intuitive as the classic multiselect control. Β But we are worried about large volumes of relation values. Β It seems the type ahead allows for more easy finding. Β We are still looking at some Ux optimization here.Β 
  • Pat VachonPat Vachon πŸ’ŽπŸ’ŽπŸ’Ž
    edited January 5, 2016
    I'm ok with type ahead, but I don't get the option to limit which values are available like I can when I specify that the values come from a model.
  • Pat VachonPat Vachon πŸ’ŽπŸ’ŽπŸ’Ž
    edited June 25, 2020
    The multiselect doesn't seem to hit the nail on the head. Here are the results of the two.

    1. Built in functionality

    image

    2. Hacked method

    image
  • Rob HatchRob Hatch πŸ’ŽπŸ’ŽπŸ’Ž
    edited September 1, 2016
    As I said earlier, Β the hacked method is going to be problematic when you have 100 records in your reference. Β We might set some boundary like we do on option select filters, Β but that's what it is... Β Β 

    How else would you like the nail hit?Β 
  • Pat VachonPat Vachon πŸ’ŽπŸ’ŽπŸ’Ž
    edited January 5, 2016
    The auto create one doesn't render ever as a multi select on a reference field.
  • edited June 25, 2020
    Hi,

    Any news or workarounds available regarding this issue?
    Would it be possible to populate a table filter from JS snippet? If so, how?

    I need to show a multi-select table filter based on a Reference field but with the look & feel of a "normal" picklist table filter.

    Thanks

  • Zach McElrathZach McElrath Principal Software Engineer Chattanooga, TN πŸ’ŽπŸ’ŽπŸ’Ž
    edited December 21, 2016
    Pedro, so you want a Multi-select Filter based on a Reference field that looks like a single-select table filter? How would the user be able to select multiple Reference field values using the single-select picklist? Skuid already allows you to do Multi-Select on Reference fields, and the UI is the way it is precisely because the single-select UI doesn't make sense when picking multiple values.Β 
  • edited November 30, 2015
    Hi Zach,

    Not realy, what I realy need is a multi-select table filter based on a Reference field that looks like the multi-select picklist as shown in the picture (based on the values of the reference field values in the table:

    image
  • Zach McElrathZach McElrath Principal Software Engineer Chattanooga, TN πŸ’ŽπŸ’ŽπŸ’Ž
    edited December 21, 2016
    Okay, I see. That makes sense.
  • edited November 30, 2015
    Any thougths for a possible solution or a workaround?
  • edited January 13, 2016
    I'd also like to know if there's a trick to make this work.Β  It's possible to create a select filter with manual options sourced from a field on an aggregate model, essentially making a text field work like a native picklist.Β  It doesn't seem like a stretch to do this with multi-select, but you don't get a manual option for multi-select filters.

    EDIT: Β Actually the hack works for this case too! Β If you create a select filter and set up your options manually (in my case from an aggregate model that returns all unique values of a text field) then all you need to do is edit the XML and change filter type from "select" to "multiselect". Β 
  • Pat VachonPat Vachon πŸ’ŽπŸ’ŽπŸ’Ž
    edited January 18, 2016
    K. There is a simple solution to this if you know where to tweak in the XML and how to set the condition.

    The solution is the same as posted 12 months ago with one additional tweak. Set Β in the XML autocompthreshold="25" to either "" or a bigger number such as "500".

    So, to recap the steps.
    1. Create a condition where value is set to "Multiple specified values"
    2. Create a Filter where "Pick Options and Condition(s)" is set to manual. Select the condition from step 1. Set the Source with "Source Type" set to Snippet. Type in your snippet name.
    3. Open the XML and update two parameters on your filter as per the pic below.
    image
  • Rob HatchRob Hatch πŸ’ŽπŸ’ŽπŸ’Ž
    edited September 1, 2016
    Thanks again Pat. Β (or should I say mB Pat). Β Its great when an old answer serves another purpose.Β 
  • Jared JonesJared Jones ✭✭✭✭
    edited October 14, 2016
    Hi Pat - What did you do to be able see the soql in the developer console? Β I'm using this method, but when I deselect all, apply, it appears the table is filtered as Region = "" (none). Β The second time I deselect all, apply, then I get the expected Region = any.
  • Pat VachonPat Vachon πŸ’ŽπŸ’ŽπŸ’Ž
    edited October 14, 2016
    Here you go.




  • Jared JonesJared Jones ✭✭✭✭
    edited October 14, 2016
    Thanks for the fishing lesson, Pat. Β Hope you have a great weekend!
  • edited July 4, 2017
    HI All,

    Is it possible to use Manal picklist options for multi select filters on Table?

    I can see manal option for single select filter only.

    Thanks,
    Raj
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!