You need to sign in to do that
Don't have an account?
enossir
comparing data from soql query
I'm trying to compare data from querys on two different objects.
Object 1: Opportunity
Object 2: OpportunityFieldHistory
Now object 2 has the 'OpportunityId' field which matches up with, you guessed it, the opportunity object Id field. So what I'm trying to do is
Pull information on two fields from the opportunity Object, these two fields would have been modified so the data in them is not null (as an AND statement not OR i need them both to be not null). Now i want to fix the modifications made to those fields within around 800 or so opportunities.
Thats where the field history comes in. It has the Old data that i want, but i need to pull the correct opportunities ID's out and then cross reference them with a set from the field history and fitler out the field history data i actually want.
sooo
healp me please
Object 1: Opportunity
Object 2: OpportunityFieldHistory
Now object 2 has the 'OpportunityId' field which matches up with, you guessed it, the opportunity object Id field. So what I'm trying to do is
Pull information on two fields from the opportunity Object, these two fields would have been modified so the data in them is not null (as an AND statement not OR i need them both to be not null). Now i want to fix the modifications made to those fields within around 800 or so opportunities.
Thats where the field history comes in. It has the Old data that i want, but i need to pull the correct opportunities ID's out and then cross reference them with a set from the field history and fitler out the field history data i actually want.
sooo
healp me please
I'm thinking that might work...I'd rather go SOQL only as i'm trying to get this data from data loader and export it into a csv
Didn't understand relationship 'OpportunityFieldHistory' in FROM part of query call. If you are attempting to use a custom relationship, be sure to append the '__r' after the custom relationship name. Please reference your WSDL or the describe call for the appropriate names.
https://developer.salesforce.com/docs/atlas.en-us.securityImplGuide.meta/securityImplGuide/tracking_field_history_for_standard_objects.htm