+ Start a Discussion
gopipatel_2610gopipatel_2610 

IsDeleted Query

Hi,
 
I am trying to get deleted records. When I delete any partner reocrd from the opprotunity and run the following query it shows only those record whose IsDelete flag = false. It doesnt show those record those are deleted i.e doesnt show any record whose IsDelete flag = true. Can anyone help me with this.
 

Select o.Name, o.Id, (Select Id, AccountFromId, Role, CreatedDate, LastModifiedDate, IsDeleted From AccountPartners where AccountFromId = '0013000000IGCby') From Opportunity o where Id ='006T0000002E6Gn'

 

Thanks,

 

benjasikbenjasik
are you calling queryall?
gopipatel_2610gopipatel_2610

No I am not calling queryall. I am just running that query in Eclipse to see the result of IsDeleted flag.

 

 

Thanks,

 

SuperfellSuperfell
query by definition doesn't return deleted rows, you need to use queryAll to see deleted rows.