Smart data deployment filters
Alex Walter on April 23rd 2019
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
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.
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
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
Operators applied to "DateTime"
Some commonly used
DateTime items include
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:
In addition to
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.
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.
Want more information on data deployments?
If you haven't signed up for our data loader, please get in touch with us and we will organize a free trial for you. And if you're already deploying data with Gearset, we would love to hear if there is something that you'd like to see or you've spotted something we could improve. In either case, drop us a line on our in-app chat, leave a feature request on our feedback forum, or send us an email!