# JOB\_FAMILY Filyer in Workday Source configuration **URL:** \ **Category:** SHF Discussion and Questions\ **Tags:** identity-security-cloud\ **Created:** [August 8, 2024, 12:47am UTC](https://developer.sailpoint.com/discuss/t/job-family-filyer-in-workday-source-configuration/75811 "2024-08-08T00:47:32Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![mgrant](https://avatars.discourse-cdn.com/v4/letter/m/cc9497/32.png) [@mgrant](https://developer.sailpoint.com/discuss/u/mgrant)\ **Post date:** [August 8, 2024, 12:47am UTC](https://developer.sailpoint.com/discuss/t/job-family-filyer-in-workday-source-configuration/75811/1 "2024-08-08T00:47:32Z")
Hi Team, I have configured the filter below in my Workday source to look at accounts with only the JOB\_FAMILY of TEST\_FAMILY. The aggregation is successful but pulls in none of the test accounts I have with this job family. Any thoughts on what may be amiss? ```auto [ { "op": "replace", "path": "/connectorAttributes/filterString", "value": "( JOB_FAMILY != \"TEST_FAMILY\" )" } ] ``` ---
**Author:** ![shaileeM](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/shaileem/32/15314_2.png) [@shaileeM](https://developer.sailpoint.com/discuss/u/shaileeM)\ **Post date:** [August 8, 2024, 1:14am UTC](https://developer.sailpoint.com/discuss/t/job-family-filyer-in-workday-source-configuration/75811/2 "2024-08-08T01:14:32Z")
Hi Mavin, If I am understanding correctly, it seems it’s expected that none of the accounts with JOB\_FAMILY as TEST\_FAMILY will be aggregated because the operator used is Not Equals (!=). If you want to aggregate only TEST\_FAMILY accounts, you can use Equals (==) operator. ```auto [ { "op": "replace", "path": "/connectorAttributes/filterString", "value": "( JOB_FAMILY == \"TEST_FAMILY\" )" } ] ``` Sorry if I have misunderstood the situation. This link might be useful for Account aggregation filtering - [IdentityNow Account Filtering during Account Aggregation - Compass (sailpoint.com)](https://community.sailpoint.com/t5/IdentityNow-Wiki/IdentityNow-Account-Filtering-during-Account-Aggregation/ta-p/142873) ---
**Author:** ![mgrant](https://avatars.discourse-cdn.com/v4/letter/m/cc9497/32.png) [@mgrant](https://developer.sailpoint.com/discuss/u/mgrant)\ **Post date:** [August 8, 2024, 12:53pm UTC](https://developer.sailpoint.com/discuss/t/job-family-filyer-in-workday-source-configuration/75811/3 "2024-08-08T12:53:57Z")
Hi Shailee, Thanks for chiming in. Yes you are tracking with the use case I described. I have the same understanding that the ‘`!=`’ does not return the Job Family listed in the filter…it returns no accounts. However - when I use the ‘`==`’ it returns all the accounts - instead of the accounts I want to filter. It appears to do the opposite. Perhaps it’s not represented correctly in the target system maybe? ---
**Author:** ![shaileeM](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/shaileem/32/15314_2.png) [@shaileeM](https://developer.sailpoint.com/discuss/u/shaileeM)\ **Post date:** [August 8, 2024, 1:56pm UTC](https://developer.sailpoint.com/discuss/t/job-family-filyer-in-workday-source-configuration/75811/4 "2024-08-08T13:56:59Z")
Hi Marvin, I am not sure if this would work, but worth trying : Instead of filterString, can you try account.filterString ```auto [ { "op": "replace", "path": "/connectorAttributes/account.filterString", "value": "( JOB_FAMILY == \"TEST_FAMILY\" )" } ] ``` ---
**Author:** ![mgrant](https://avatars.discourse-cdn.com/v4/letter/m/cc9497/32.png) [@mgrant](https://developer.sailpoint.com/discuss/u/mgrant)\ **Post date:** [August 9, 2024, 11:38pm UTC](https://developer.sailpoint.com/discuss/t/job-family-filyer-in-workday-source-configuration/75811/5 "2024-08-09T23:38:57Z")
Hi Shailee, I was able to get the desired result with the filter below. Notice I added Negation (!) at the beginning of the value for it to filter the accounts I wanted it to aggregate. The condition passed. This is a bit puzzling and opposite of the documentation below. > **[IdentityNow Account Filtering during Account Aggregation](https://community.sailpoint.com/t5/IdentityNow-Wiki/IdentityNow-Account-Filtering-during-Account-Aggregation/ta-p/142873)** > > Overview Often there is a need to filter accounts on a source during an account aggregation process. While some source connectors offer an ability to filter accounts natively, other source connectors may not, usually due to technical limitations -... Usually a negation would work if the we see the `Inner Condition: plaintext JOB_FAMILY != "TEST_JOB_FAMILY"` However, to make it work for me I had to do the opposite of the inner condition and make the Inner condition "`==` or `true` See below. ```auto [ { "op": "replace", "path": "/connectorAttributes/filterString", "value": "!(JOB_FAMILY == \"TEST_FAMILY\" )" } ] ``` Needless to say - it took a little grinding to get to this discovery and it works exactly like I need it to. Thanks for the assist. You pointed me in the right direction my friend. ---
**Author:** ![shaileeM](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/shaileem/32/15314_2.png) [@shaileeM](https://developer.sailpoint.com/discuss/u/shaileeM)\ **Post date:** [August 10, 2024, 1:17am UTC](https://developer.sailpoint.com/discuss/t/job-family-filyer-in-workday-source-configuration/75811/6 "2024-08-10T01:17:55Z")
Hi Mavin, Yes its strange that != is not working but !(==) does the work. Glad that you could figure it out! Thanks for sharing the solution also. Thanks, Shailee ---
**Author:** ![system](https://global.discourse-cdn.com/sailpoint/original/2X/f/f2136700ed5e3703e0b85e02f6be799dacca7735.png) [@system](https://developer.sailpoint.com/discuss/u/system)\ **Post date:** [October 9, 2024, 1:18am UTC](https://developer.sailpoint.com/discuss/t/job-family-filyer-in-workday-source-configuration/75811/7 "2024-10-09T01:18:45Z")
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.