Source Filter Settings

Hi,

Good day! I’m trying to use and having a hard time on an account filter under the aggregation settings in our source to exclude user_name that contains _old*, so that old accounts are not captured.

Could you please advise how I can configure the filter to exclude user_name that contain _old, _old1, _old2, and similar patterns during account aggregation?

Thank you!

1 Like

You can use

user_name.contains("_old")

For more info, check this doc

2 Likes

Hi @earvs0527,
Can you Please PATCH the below filter in your source and please let me know.

[
    {
        "op": "add",
        "path": "/connectorAttributes/account.filterString",
        "value": "( user_name.contains( '_old' ))"
    }
]

I hope this will work for you.
Thank you!