Skip to main content
phani_kumar
phani_kumar
Gainsight Employee ⭐️⭐️
February 10, 2022
New Idea

Is it possible to provide an option to choose "Include Null Values" for Multi-Select Picklist fields

Related products:CS Reports
  • February 10, 2022
  • 16 replies
  • 367 views

Hi.

Currently, we don’t have an option to choose/select the “Include Null Values” for the Multi-Select Picklist fields in Rules and/or JO Query Builder.

When ever we drag the multi select picklist field in to a filter section (Ex: in Rules) we have to choose either Includes or Excludes option only and unable to select the “Include Null Values” as well. Like how we have this option for Picklist Data type fields.

Screenshots for the same:

 

Due to unavailable of this option we are unable to get the Null value records. If we can get the same option like how we have for the Picklist field would be great.

Thanks.

    16 replies

    alizee
    alizee
    VIP ⭐️⭐️⭐️⭐️⭐️
    January 23, 2023

    Please please please. Getting this kind of information through ‘count of’ filtered tasks and reassembling that is really a waste of the available number of tasks we can have in rules engine and JO (I know it’s going to change), not everything warrants a data design either. This is really a feature we needed yesterday.

    The most expensive part of building is the mistakes. That's true in construction. Not so much in CSOps. So ask questions, make mistakes and learn. All views expressed here are my own.
      anirbandutta
      anirbandutta
      Expert ⭐️
      January 24, 2023

      @vmallya, @Prateek Parashar could you pl take a look at this requirement?

      cc @PavanCh  

      It's an opportunity for engagement
        anirbandutta
        anirbandutta
        Expert ⭐️
        February 20, 2023
        Updated idea statusNo Status→Under Consideration
        Idea merged into:

        All the votes from this idea have been transferred.
        It's an opportunity for engagement
          anirbandutta
          anirbandutta
          Expert ⭐️
          February 20, 2023
          The following idea has been merged into this idea:

          All the votes have been transferred into this idea.
          It's an opportunity for engagement
            anirbandutta
            anirbandutta
            Expert ⭐️
            February 20, 2023
            Idea merged into:

            All the votes from this idea have been transferred.
            It's an opportunity for engagement
              Jef Vanlaer
              Jef Vanlaer
              Helper ⭐️⭐️⭐️
              March 7, 2023

              Pretty frustrating to have to work around this still today in Data Designer (and all other areas)

                romihache
                romihache
                VIP ⭐️⭐️⭐️⭐️⭐️
                March 7, 2023

                Heavy +1!
                Working around this silly gap consumes a lot of time, would love to see this implemented in the near future!
                 

                Continuous improvement is better than delayed perfection
                heather_hansen
                heather_hansen
                VIP ⭐️⭐️⭐️⭐️⭐️
                September 25, 2023

                +1 - Running into this with Horizon Rules as well.

                seth
                seth
                Expert ⭐️
                January 18, 2024

                What’s the easiest way that you use to work around this? (I’m filtering Relationships in Data Designer.)

                Best option I can think of:

                1. Fetch Relationships, including the multi-select picklist
                2. Transform: Only include GSID field. Filter for picklist values in [select all items].
                3. Merge: Join the filtered GSIDs back to the original list of Relationships
                4. Transform: Filter for that merged-in GSID field is null, to find Relationships without anything in the multi-picklist.
                AI Transformation @ Gainsight
                  alizee
                  alizee
                  VIP ⭐️⭐️⭐️⭐️⭐️
                  October 30, 2024

                  Wouldn’t it be time to look at this? It’s such a hinderance. 

                  Here’s recap of what doesn’t work with multi picklists: 

                  The multi picklist by @respectablesoundtrack6143 | Suno

                   

                   

                  The most expensive part of building is the mistakes. That's true in construction. Not so much in CSOps. So ask questions, make mistakes and learn. All views expressed here are my own.
                  Show more replies
                  Terms & ConditionsAccessibility statement