Skip to main content
New Idea

Horizon Rules - Multi-Select picklist IS NULL or IS NOT NULL filter option

Related products:None
  • September 25, 2023
  • 10 replies
  • 122 views

heather_hansen
Forum|alt.badge.img+14

This was also an issue in Bionic Rules, and still is in Horizon Rules.  I need to be able to filter for a Multi-select picklist being null.  I can workaround it, but it would be much simpler if I could use IS NULL like I can with other field types.
 

 

10 replies

heather_hansen
Forum|alt.badge.img+14
  • Author
  • VIP ⭐️⭐️⭐️⭐️⭐️
  • September 25, 2023

For what it’s worth - IS NULL or IS NOT NULL is an option in Report Builder for multi-select.


rakesh
Forum|alt.badge.img+2
  • Lets put your data to work!
  • September 27, 2023
No StatusAcknowledged

dayn.johnson
Forum|alt.badge.img+7
  • VIP ⭐️⭐️⭐️⭐️⭐️
  • February 20, 2024

For what it’s worth - IS NULL or IS NOT NULL is an option in Report Builder for multi-select.

#product_parity!


sarahmiracle
Forum|alt.badge.img+11
  • VIP ⭐️⭐️⭐️⭐️⭐️
  • February 20, 2024

@rakesh I think this status should be “Acknowledged” for the idea? Looks like you set it to Acknowledged a few months ago but now it’s back to NEW IDEA. Maybe something to do with the Community transition?


alizee
Forum|alt.badge.img+13
  • VIP ⭐️⭐️⭐️⭐️⭐️
  • February 21, 2024

Overall revamp of everything multi-select picklist is required. 


alizee
Forum|alt.badge.img+13
  • VIP ⭐️⭐️⭐️⭐️⭐️
  • July 1, 2024

Since we have this available in reports… can this be prioritized? 

 


alizee
Forum|alt.badge.img+13
  • 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


dayn.johnson
Forum|alt.badge.img+7
  • VIP ⭐️⭐️⭐️⭐️⭐️
  • October 30, 2024

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

The multi picklist by @respectablesoundtrack6143 | Suno

🔥🔥🔥

@alizee -- hero.🤘

This says it all, so much more than words alone.


cmultanen
Forum|alt.badge.img+1
  • Helper ⭐️
  • April 10, 2025

+1 this is a big pain point in Rules Engine. Is there any update on this? 


alizee
Forum|alt.badge.img+13
  • VIP ⭐️⭐️⭐️⭐️⭐️
  • May 16, 2025

I’m back. 

This however isn’t solved still. 

Considering it’s possible in reports, we needed this about a few years ago. 

Rare occurrence of a feature allowing filtering multi picklists on “is null” / “is not null”

We do not want 2-3 more tasks in our designs or rules to tackle this. We do not. We do NOT. We DO NOT.