Partial Sandboxes needs to keep Hierarchical integrity of data - Ideas - Salesforce Trailblazer Community
Trailblazer Community

All Ideas

Idea Details

Post an Idea
640  Points
Idea has been posted. Give it an upvote or downvote.

Partial Sandboxes needs to keep Hierarchical integrity of data

Operational Reporting

The new Partial Sandbox did not hit the mark for related hierarchial data that must be considered a single entity.  The current partial extract is using a random selection of rows, so although it ensures children have a parent it does not provide the ability to ensure a parent has all it's children. 

We have relational/hierarchial set of data that represents a clinical trial.  The clinical trial project is a top level object with at least four levels of related data, this could be data collected over months and years.  Some parent objects are slected with no children and as you go down the hierarchy you randomly have some children with data and some with none and never a complete set of children.  Without all the related children you cannot adequately test or use this data.  You may have gaps in time periods, etc.

Please provide the ability to specify a particular record in an object and then chase all related data for that record so that we have a complete unit.  The 10,000 row limit is also going to be a problem because as you get down the hierarchy the number of related records will increase especially where you have very granular data like time reported against a trial.  If we had a 10,000 limit we would in the end only be able to have a couple of clinical trials being part of the new sandbox.

Merge Idea · Flag

  • Upvotes
  • Downvotes



from AppExchange


No results found.

Help us to keep IdeaExchange clean by pointing out overlapping ideas. We'll investigate your suggestion and merge the ideas if it makes sense.



Thanks for your merge suggestion. We will review it shortly and merge the ideas if applicable.

Salesforce takes abuse situations very seriously. Examples of abuse include but are not limited to posting of offensive language or fraudulent statements. To help us process your request as quickly as possible, please fill out the form below describing the situation. For privacy and security reasons, the final outcome of an abuse case may not be revealed to the person who reported it.


Thank you for your feedback. We take abuse seriously and will investigate this issue and take appropriate action.