I have been playing with the appexchange.schema query tool in eclipse today. I managed to do a Soql-R query for bring back contacts and accounts.
I was wondering if there wa a way to filter on the subset. I.E. Return all Accounts with contatcs something like this:
Select a.Id, (Select AccountId From Contacts where LastModifiedDate>=2006-05-10T16:30:00.001-08:00) From Account a where Contacts != null or a.LastModifiedDate>=2006-05-10T16:30:00.001-08:00
This query should return all accounts that have been modified since 2006-05-10T16:30:00.001-08:00 or accounts where the contact has been modified since 2006-05-10T16:30:00.001-08:00
I have been playing with the appexchange.schema query tool in eclipse today. I managed to do a Soql-R query for bring back contacts and accounts.
I was wondering if there wa a way to filter on the subset. I.E. Return all Accounts with contatcs something like this:
Select a.Id, (Select AccountId From Contacts where LastModifiedDate>=2006-05-10T16:30:00.001-08:00) From Account a where Contacts != null or a.LastModifiedDate>=2006-05-10T16:30:00.001-08:00
This query should return all accounts that have been modified since 2006-05-10T16:30:00.001-08:00 or accounts where the contact has been modified since 2006-05-10T16:30:00.001-08:00
