Trying to run a soql query with a subquery nested in the where clause. How is it possible to achieve it?
I tried using the filter option in the salesforce operation using an "IN" operator but it didn't work. Also for some reason I tried using just a list of values with the IN operator but it didn't work as well.
Keep getting the following error:
MALFORMED_QUERY: UserOrGroupId FROM AccountShare WHERE ( ) LIMIT 20 ^ ERROR at Row:1:Column:58 unexpected token: ')';
Seems like the filter is not being sent and the where clause is just empty.