List Builder (Custom with spec) is there a way to prevent it from running on screen until user wants output.

Bruce Boling
Bruce Boling
Sixth Anniversary Name Dropper Facilitator 1 June 2023 Monthly Challenge
in Blackbaud CRM Developer Discussions

With several list builders on one tab in CRM. They all start running as soon as you click the tab. Is there an option to not run until the user wants it to run. AND as a side question when you click on page 2, it would appear the whole sql starts running again instead of just showing page 2 and takes the same amount of time it did when it first ran. Thanks.

Answers

  • Rob Downs
    Rob Downs
    Tenth Anniversary Kudos 1 Name Dropper Participant

    The curse of the list builder 😂

    We constantly run into performance issues and are looking for ways to optimize, but all that filtering just requires longer load times.

    We typically put one ListBuilder per tab. We've found that if more that one section is necessary on a tab, then a shorter DataList with a Filter section performs better. It also keeps the pages from getting too long. Most of our listbuilders are also from the warehouse, which we found provides better performance.

    Acknowledging your frustrations and asking for the same advice…

Categories