Work.com
Leading Through Change with Data
COVID-19 Data Hub
COVID-19 Global Daily Tracker
Global Economy Data Track
Government Data Track
Healthcare Data Track
B-Well Together
Leading Through Change
Salesforce Care
Leading Through Change Blog
Trailhead Resources
AppExchange Resources
MuleSoft Resources
< Back to List
Andrew Gill
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
Stuart Fleming - 2 years ago
Glen Powell - 2 years ago
I have no hope of ever seeing this implemented, but I'll upvote it as it's totally sensible and an obvious flaw in the existing arrangement. A relational database which does not preserve referential integrity of copied records in it's dev environment is pretty ridiculous.
With Full Sandboxes being costed at 30% of total subscription price (!), little incentive for SF to bother fixing the "included" environments.
Marleene Nolan - 3 years ago
Gnanasekaran Thoppae - 3 years ago
Bob Bailey - 3 years ago
Scott Mercer - 4 years ago
Manjith Radhakrishnan - 4 years ago
Roy Lloyd - 4 years ago
Mary C - 4 years ago
Eljon Greene - 4 years ago
Akbar R - 4 years ago
Tony Cirelli - 4 years ago
Chase Bass - 4 years ago
Mike Merino - 4 years ago
Julie Akawie - 5 years ago
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.