I am trying to query Opportunity Field History to get the results for a custom lookup field that has history tracking. I am getting 2 records back for 1 single change, one of the record has oldvalue and newvalue as lookup id and another record has lookup name as old and new value. I was wondering why Field history is creating 2 records for same change. I am trying to query it and set the resulting list to a front end table, but since it is returning 2 values for single change there is a duplicate value displayed. how can i restrict that?
my query looks like this select id, OldVlaue, NewVlaue from OpportunityFieldHistory where OpportunityId='oppID'