Exclude records from a data deployment

Exclude records from a data deployment

Tom Smith on

Share with


You have strict guidelines around who can access your production data. Meanwhile, developers want to use production data for testing their changes. Gearset’s data loader now lets you exclude records from a deployment, making it easy to fine tune a set of test data.

Why would I need to exclude records?

Using production data for testing is a great way of finding real-life edge cases. Developers can generate test data, but it’s easy to miss complex scenarios which exist in production. Without testing on production data, problems only reveal themselves in production.

The problem with using production data is that your organization has a duty to protect that data. As a Salesforce admin you have controls in place to ensure that users can only access specific records.

You want to give developers data so that they can check their changes work. You don’t want to give access to everything. For example, you may want to avoid giving access to sensitive accounts or active opportunities.

Live eventConvene, Chicago

DevOps Dreamin’ Chicago 2024

Find out more

How do I set up a filter?

Until now, filters in Gearset’s data loader have been inclusive. This makes it painstakingly slow to exclude a single record - you have to include every other record.

You can now choose between equals and does not equal when creating a filter.

Select does not equal to exclude matching records

A does not equal filter means that the deployment excludes any records with a field matching that value. You can check the filters that the deployment will use in the deployment plan.

The deployment plan shows any filters to be used

Filters to exclude records are saved in our data deployment templates.

Keep your data protected

Excluding and obfuscating data during sandbox seeding is key to keeping your production data secure, while also giving your team reliable data for testing. Try it for yourself with a free 30-day trial.

Try all of Gearset for free