Customize/Configure AdHoc Properties

It would be nice to be able to have a way to not default "Suppress Duplicate Rows" with Revenue Queries. Any way to control this would be a great feature within CRM to create queries.
  • Guest
  • Jun 29 2015
  • Will not implement
Blackbaud CRM / Query
  • Attach files
  • Mitchell Gibbs commented
    27 Mar 16:49

    Suppress Duplicate Rows negatively impacts performance, sometimes significantly, especially for Selections. For one of our CRM databases, there are 125 nightly static queries that refresh and were created without disabling suppress duplicate rows. Changing that cut the time to refresh them in half. Suppress duplicate rows should be the exception, not the default. For most forms, we could change that - but not for this form.

    ×

    Attachments Open full size

  • +13

Related ideas