2

This query:

select ID, StageName, Probability, Amount, CloseDate from OpportunityHistory where OpportunityId = 123 and LastModifiedDate > 2015-01-01T00:00:01z

Throws this error:

No such column 'LastModifiedDate' on entity 'OpportunityHistory'.
Improve this question

3 Answers 3

Reset to default
4

There is a field on OpportunityHistory called CreatedDate. Try that instead of LastModifiedDate.

Improve this answer
3

OpportunityHistory object represents the history of a change to the Amount, Probability, Stage, or Close Date fields of an Opportunity. This object is read-only. The system generates a new record whenever a user or client application changes the value of any of the above fields. As this is read only object and will not be updated anymore, LastmodifiedDate field is not available for this object. Instead you can add a clause for LastmodifiedDate of opportunity. Like - select ID, StageName, Probability, Amount, CloseDate from OpportunityHistory where OpportunityId = 123 and Opportunity.LastModifiedDate > 2015-01-01T00:00:01z

OR You may use createdDate of OpportunityHistory. As OpportunityHistory are read only and wont be updated anymore, the createdDate and lastmodifiedDate of OpportunityHistory will be always same. so you can definitely use createdDate.

Improve this answer
2
  • I believe that will still give me all the OpportunityHistory for the Opportunity that was updated. Is there a CreatedDate or something on OpportunityHistory?
    – Travis Reeder
    Mar 10, 2015 at 16:56
  • Yes, You can use createdDate of OpportunityHistory. In other word, the createdDate and lastmodifiedDate of OpportunityHistory will be always same. so use can definitely use createdDate.
    – Anup
    Mar 11, 2015 at 6:08
1

you can simply use CreatedDate instead of lastmodifieddate. as both will be same in case of OpportunityHistory object.

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .