Andrew Fawcett edited this page May 28, 2017 · 12 revisions

Welcome to the declarative-lookup-rollup-summaries wiki!

USAGE: Please read this in conjunction with other blogs and articles found in the documentation section

(This wiki is a work in progress)

Installing DLRS

You can either install the managed package which will save you space against your app and tab limits, or you can install the latest unmanaged package into Production or a Sandbox with the links in the Package Release History in the README

Here is the App and Objects that are installed. You can see there are two permission sets that can be used to give access. Installed Components

Permissions

You can install the package fro Admins only and open up permissions for all users/profiles with the options below or install for all users.

Install for Admins

There are two types of DLRS Users:

Admin

Kind of a tool admin user that both configures and activates the rollups (this has to be an admin to deploy and manage the trigger for example). This user also needs full read/write access to all the objects in the package.

User

Then there is the users that don't directly use the tool, but indirectly invoke its rollups. These users need read access to all the objects in the package. You don't however need to give them access to the app, tabs or Visualforce pages for example since they don't need to be able to access the tools admin UI.

Assigning Permissions

  • You can click on Permission itself Lookup Rollup Summaries - Process Rollups and there is a button Manage Assignments. From the page that is displayed you can create a List View to filter for the users you want, tick them and click Add Assignments. Process Rollups Permission Set
  • You can update a Profile by giving Read access to the following objects, Lookup Rollup Summaries, Lookup Rollup Summary Logs and Lookup Rollup Summary Schedule Items.
  • Finally, if you didn't find the first option useful enough, you may want can try out the free The Permissioner tool on AppExchange.

You can also Read the Salesforce documentation on installing and permissions

Professional Edition

It is now possible to install the managed package in a Lightning Professional Edition and configure entries to trigger Process Builder to action the declarative roll up summary. (per 341)

Process Builder Sharing Mode

Creating a New Lookup Rollup Summary

Manage Lookup Rollups Screen

Lookup Relationship

Parent Object

Enter the API name of the object in salesforce.com that you want the rollup summary to be stored on

Child Object

Enter the API name of the object that you want to query and rollup to the Parent Object

Relationship Field

Enter the API name of the lookup field on the Child Object relating to the Parent Object

Relationship Criteria (Optional)

If you would like to filter the Child Object records that get summarized enter the SOQL WHERE query here.

e.g. Amount > 200 AND Stage = 'Closed Won'

Examples & Details

Relationship Criteria Fields

Any field used in the Relationship Criteria needs to be entered here, one field per line e.g.

Amount
Stage

NOTE: If you are referencing Recordtype.Name or Recordtype.DeveloperName in your WHERE clause, exclude them from the Relationship Criteria Fields, because it will throw an error.

Rollup Details

Field to Aggregate

This is the API name of the field on the child record

Field to Order By

This is useful if you are concatenating

Aggregate Operation

Aggregate Result Field

Where on the Parent to place/write the result

Active

Must be set to Active to Calculate manually now or to set as Realtime. In order to set as Active you must deploy the child trigger.

Calculation Mode

Calculate Job Id

Text Rollups

Concatenate Delimiter

You can’t perform that action at this time.
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session.
Press h to open a hovercard with more details.