I suggest you ...

Allow complex filters and child relationships on filters for data loading

Allow complex filters and child relationships on filters for data loading. For example, filter the Account to only load if the Owner is an Active user in the system.

3 votes
Sign in
Password icon
Signed in as (Sign out)

We’ll send you updates on this idea

Jody Crutchfield shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →


Sign in
Password icon
Signed in as (Sign out)
  • Scott Mercer commented  ·   ·  Flag as inappropriate

    Using formulas is an acceptable workaround, but it would be nice to be able to filter on common relationships such as RecordType.DeveloperName with needing to create a formula field.

  • Martin commented  ·   ·  Flag as inappropriate

    Having to modify the org/metadata in order to use a Gearset feature isn't ideal -- this would stop me from using Gearset on our live instance. Adding a formula smells like one of those workarounds that I'm used to in the Salesforce-only world, but I would wish for Gearset to have a bit more advanced filters come stock :)

    In an ideal world, the uber poweruser tool for me would be to somehow incorporate in SOQL queries for sourcing data. Those are already relationship-aware and can do all kinds of filtering. I'm sure it would be a lot of work to get something like this into a sensible shape/format, but in an ideal world...

    Screenshot example of a query I'd use for Jody's example:


  • AdminGearset Team (Admin, Gearset) commented  ·   ·  Flag as inappropriate

    It's now possible to filter records by formula fields on the Salesforce object.

    This allows you to create the complex formulas on your objects and filter by those fields in Gearset.

    This article has more information on how to set this up: https://docs.gearset.com/feature-guides/data-loader/complex-filtering-in-data-deployments

    Please let us know if you have any feedback on this filtering!


Feedback and Knowledge Base