Filter accounts having specific permissionsets using accountfilter query in Salesforce connector

[shetty07]

Hello,

We have a use case to include accounts that are having specific permission sets. Since Nesting of semi join sub-selects is not supported and also we cannot use join since Bind variables are only allowed in Apex code is there any other alternative way to achieve the below account filter query ?

Id in (select AssigneeId from PermissionSetAssignment where PermissionSet.Name includes ('Permissionset1','PermissionSet2'))

Regards,

Rahul

[SB]

Below is a link to the salesforce connector guide you can refer to for filtering (ACCOUNT_FILTER_QUERY )

https://docs.saviyntcloud.com/bundle/SF-v55x/page/Content/Configuring-the-Integration-for-Importing-...