Skip to main content
alizee
alizee
VIP ⭐️⭐️⭐️⭐️⭐️
November 16, 2021

Filter on boolean attribute = false

  • November 16, 2021
  • 5 replies
  • 99 views

We need to be able to filter data on boolean attribute = false in rules engine as well as in report builder. We use boolean attributes for a variety of purposes, such as indicating whether or not a user/account uses a product or whether they’re opted out from CS comms. We build rules based on boolean attributes and sometimes, we’ll need to filter for values where it is set to false… but we can’t according to Support. 

This is a huge product gap… Please add this to the roadmap.

 

    5 replies

    heather_hansen
    heather_hansen
    VIP ⭐️⭐️⭐️⭐️⭐️
    November 16, 2021

    @alizee you should be able to do this.  I have several reports and rules that use Boolean results as a filter.  Is it possible that you have records that don’t have a true or false value, and that’s why the filter isn’t working?

    alizee
    alizeeAuthor
    VIP ⭐️⭐️⭐️⭐️⭐️
    November 16, 2021

    @heather_hansen Thanks. Support told me no later than today that it is not possible and were not able to provide a workaround. Even filtering on doesn’t equal true returns no values… so definitely not working.

    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.
    heather_hansen
    heather_hansen
    VIP ⭐️⭐️⭐️⭐️⭐️
    November 16, 2021

    Hmm.  Yeah, the only time I’ve seen it not work correctly is if there are records without a value.  As long as there’s a value of TRUE/FALSE, you should be able to use it.  I have a ton of them that are working as expected. 

      alizee
      alizeeAuthor
      VIP ⭐️⭐️⭐️⭐️⭐️
      December 8, 2021

      Support have helped me with this issue, so I’ll mark this as closed. Thank you all for chiming in. 

      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 ⭐️
        December 9, 2021

        Support have helped me with this issue, so I’ll mark this as closed. Thank you all for chiming in. 

        Awesome, thanks @alizee for updating the thread on community and 🦸‍♀️ @heather_hansen for engaging!

        @mandy_major , @vaishali_rawat & team FTW!!

         

        It's an opportunity for engagement
        Terms & ConditionsAccessibility statement