Smart data deployment filters

Smart data deployment filters

Alex Walter on

Share with


Gearset’s data loader is an incredibly effective way to deploy data from one org to another, whether for sandbox seeding, debugging, or just general day-to-day feature development. That said, until recently, its ability to narrow down to a specific subset of interesting records was fairly limited.

In a recent release, we’ve made some changes to make it much easier to define the specific set of records you want to deploy. By applying logical operators, such as a multi-value OR, an is empty or an is not empty operator, you can include all the records you need in a single deployment, rather than having to do multiple deployments between the same two orgs. Similarly, you might want to use a greater than or a less than operator to include all the records created or modified before or after a particular date and time.

Object filter settings

Four new features to help you configure your data deployments

We’ve added four new features to Gearset’s data deployment filters:

The “OR” operator

If you want to include records that match a particular field, e.g. if you want all Accounts from the countries Australia, Brazil and China, you can add multiple values by selecting the field and clicking Add another value. This way, you can include Accounts from Australia OR Brazil OR China.

The OR operator

The “is empty” and “is not empty” operators

Gearset allows you to filter for Objects that have a field that is empty or is not empty. For example, FilledObject below has entries for the field AnEmail, whereas the same field has been left blank in BlankObject. Now, if you were to place a filter on AnEmail and select is empty, Gearset would deploy BlankObject, giving you all the records that lack an entry for AnEmail.

Filled Object example
Blank Object example

Operators applied to “DateTime”

Some commonly used DateTime items include CreatedDate and LastModifiedDate. For DateTime fields such as CreatedDate, select the date using the date picker and a time from the time picker. Here, for example, is how to chose any Accounts created after 9:30am on March 10th, 2019:

Created after DateTime

In addition to equals and does not equal a particular DateTime, you can now filter for all Objects created before or after a particular date by using the greater than or less than operator. Gearset uses the timezone you’ve selected in the Notification Settings of the My Account page - you should check this matches your timezone in your Salesforce org to make sure your filter configuration specifies the records you’d like to deploy.


Validation of filter values

Along with these new filters, we’ve added some validation to make sure that the filters are properly defined with values that make sense. This makes it easier than ever to define useful filters, and to make sure you’re deploying exactly the records you want to deploy.

Validation alert

Gearset checks and alerts you to any invalid values before you run a deployment, such as an incorrect date format. These checks prevent deployments failing without you knowing the reason why.

Validation notification

Easy and precise data deployments

Want to deploy data to your Salesforce orgs with precision? Start a free 30-day trial now, with nothing to install in your orgs.

Try all of Gearset for free