Discussions

Expand all | Collapse all

Overriding the 5 dynamic filter constraint

  • 1.  Overriding the 5 dynamic filter constraint

    Top
    Contributor
    Posted 07-31-2018 15:57
    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!


  • 2.  RE: Overriding the 5 dynamic filter constraint

    Posted 07-31-2018 16:28
    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.


  • 3.  RE: Overriding the 5 dynamic filter constraint

    Top
    Contributor
    Posted 07-31-2018 17:41
    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.  


  • 4.  RE: Overriding the 5 dynamic filter constraint

    Posted 07-31-2018 22:13
    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-...">https://quickbase.uservoice.com/forums/111823-quick-base-product-feedback/suggestions/8244501-allow-more-than-5-dynamic-filters">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.


  • 5.  RE: Overriding the 5 dynamic filter constraint

    Top
    Contributor
    Posted 08-03-2018 14:59
    Thank you again for your help! 


  • 6.  RE: Overriding the 5 dynamic filter constraint

    Top
    Contributor
    Posted 08-03-2018 15:01
    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.