I want to get all Salesforce account based on child object filters(opportunity ID/forecast category etc). I added those filters as shown in image-
It gives me all account not filtered ones. Please suggest.
Only way I've found to do this so far is to query for opportunities matching some critera. Then, find a unique list of a account ids associated to all of the opportunities returned. Then, use that unique list of account ids to query for the accounts. If you have a lot of accounts you want to lookup, you might want to also batch the account ids together (comma separated) and query Salesforce using the Id IN criteria.
Also, you might be able to avoid the second query to lookup the accounts by returning more than the account id in the first query. You'll have to map the account data to a flat file and enforce unique on the account id column to remove dupes.
Thanks Seth Duda for a quick response. I have saved unique account xml profiles in document cache in 1st branch. Now I'm fetching result with salesforce connector based on the stored account ID in cache in another branch but it gives me error like "Unable to create XML files from data, the document may not be well-formed xml ".
I believe you can't set filters across objects. Consider restructuring your query(Query Opportunities with filter and bring in related Accounts) or following Seth Duda's recommendation.
Thanks Lee Sobotkin.
Retrieving data ...