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.

1 vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    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 →

    2 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • 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:

        https://i.ibb.co/xzXwkVn/soql-query-example-for-uservoice.png

      • 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!

        Tom

      Feedback and Knowledge Base