Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

QA/QE: Add to QA dataset: Rollup where the relationship field is a string, not a lookup #1402

Open
mkolodner opened this issue Oct 31, 2023 · 1 comment
Labels
enhancement QA/QE Tasks that relate to quality assurance for new releases. Snowfakery

Comments

@mkolodner
Copy link
Contributor

mkolodner commented Oct 31, 2023

One of DLRS's more obscure capabilities is that the rollup does not have to go across an actual relationship field. As long as the field designated as the relationship field holds a string of an 18 character Id, DLRS can handle that.

  1. A custom field that's text (18 characters) already exists (QALookupChild.Parent_by_String__c)
  2. Add parent objects and then child objects with Ids of parents in the field (Snowfakery task)
  3. Add a rollup that works across that text field
  4. Add automated testing that checks that the rollups are correct.
  5. Relationship field is created along with three test records.
  6. Upon insert the lookup by string field has the Id of records that don't exist (because Ids have changed). Will need something to fill this with valid results!
  7. Rollup is created.
@mkolodner mkolodner added Snowfakery QA/QE Tasks that relate to quality assurance for new releases. labels Oct 31, 2023
@acrosman
Copy link
Contributor

To generate data for this pattern with Snowfakery would require two passes. First, load a set of Parent records, then pull back their Ids using a query, and use those queries to populate the field. Documentation on that process is here: https://snowfakery.readthedocs.io/en/latest/index.html#iterate-over-salesforce-datasets

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement QA/QE Tasks that relate to quality assurance for new releases. Snowfakery
Projects
Status: In Progress
Development

No branches or pull requests

2 participants