Advanced lists - row limit rolled back

Thanks to additional feedback from users like you, we're taking a second look at Advanced lists that have very large results. Recently, we announced that we'd limit the results to 20,000 rows, and that change was withdrawn Wednesday morning.

To help us better support your organization's needs for very large lists, it would help to have your answers to the following questions:

  • What are your top 4 biggest lists – with the List name and/or with your estimated number of rows you typically retrieve?
    • Alternatively, what Objects are you using when you create massive lists?
  • What is the average number of results sent to a third-party reporting tool (like PowerBI) per list?
  • What is the highest number of recipients in a single Pushpage job?
  • What are you doing with 50K plus results? What context is lost with fewer rows? Does it help to break it down by school year or term?
  • If we (purely hypothetically) re-introduce a row limit at 50k, how many additional lists would you have to build?

If you're willing to provide feedback, please either reply to this discussion or email me at jessica dot walters at blackbaud dot com. Also, please complete the Advanced List and Pushpage survey (published in the blue alert banner in-product) if you have not yet done so.

Thank you for your input!

Comments

  • @Jessi Walters
    Why do you even think of restricting a number of records in the Advanced list? Occasionally we need to extract records for all students roles - past, alumni, current, incoming. The advanced list should generate exact number of records from the database, and we should be able to filter these records ourselves. I have recently ran a list of all enrollment rows for all of our students, past and present, and noticed that the list has exactly 100K records, but some records we needed were missing. Is there a 100K records restriction in place? If so, why it is not stated anywhere on the Advanced list page?