Overriding the 5 dynamic filter constraint

  • 0
  • 1
  • Question
  • Updated 4 months ago
  • Acknowledged
tl;dr:  I understand that there's no way to change the 5 filter constraint on QB reports through the front end.  Has anyone tried to do this through script?

The handful of ways I tried to do this and failed are as follows:

1) Altering the "maxFacets" global variable that appears in the ?a=viewbuild pages - this allows you to stop seeing the "Maximum number of filters selected" warning but still won't allow you to add anything else. 
2) Updating the options for the "qb.columnChooser" jQuery UI widget factory plugin - changed the "maxDestItems" property to have a limit of 10 instead of "maxFacets" - this allows you to actually apply more than 5 filters, but they aren't applied/don't appear once you display the report. 
3) Using the FormData API to pass in additional <li> elements on the ?a=viewbuild pages - this has the same effect as #2 on this list
4) On the actual report page, you can construct your own filters using functionality from QB.Faceting object.  This works, but it's a lot of work and custom code.  I was hoping to just piggyback on what already exists in QB to make this work.  

At this point, my curiosity is killing me so any feedback is greatly appreciated.  Thank you!
Photo of Christine

Christine

  • 378 Points 250 badge 2x thumb

Posted 4 months ago

  • 0
  • 1
Can you share a little more about what you are trying to achieve? Why do you need more than 5 dynamic filters? How will you or your users benefit from more filters? There may be other ways to achieve your objective depending on what the ultimate goal is.
Photo of Christine

Christine

  • 378 Points 250 badge 2x thumb
Thanks so much for the reply!  We have other native Quickbase ways to solve this, though what prompted this was a client specifically requested more than 5 dynamic filters.  At this point, I'm just curious about the possibility of what I asked previously.  Again, your help is much appreciated.  
Alright, that makes sense. Unfortunately I don't know of a way to specifically increase the number of filters.

There is a item on uservoice for increasing the number of filters. It has 34 votes: https://quickbase.uservoice.com/forums/111823-quick-base-product-feedback/suggestions/8244501-allow-...

If you have issues accessing the link above, first go to the orange feedback button on your My Apps homepage and select "browse ideas" on the upper left.
Photo of Christine

Christine

  • 378 Points 250 badge 2x thumb
Thank you again for your help! 
Photo of Christine

Christine

  • 378 Points 250 badge 2x thumb
If anyone else should happen to stumble upon this and wonder how it turned out, we were able to do it with some scripting.  Feel free to let me know if I can assist.