query only recalled record for approval process

Question

I have a requirement in which I need to query only those record which are recalled, is it possible for using query or through report.

Can you try SELECT Id, Status, TargetObject.type, CompletedDate FROM ProcessInstance where status ='Removed' SOQL — SaiPraveen Kakkirala, Sep 28, 2022 at 10:11
Please tell me one thing, what is the difference between removed and recalled which word i use in where condition e.g where status='Removed' or where status='Recalled' — Ali Khan, Sep 28, 2022 at 10:34
I don't think Recalled will work. Once the record id removed from approval it will change the status to Removed — SaiPraveen Kakkirala, Sep 28, 2022 at 10:36
how can i access this object through UI, I can't see this object in object manager. — Ali Khan, Sep 28, 2022 at 10:45
You wont be able to see this object in object manager as you cannot customise this. Please find the below article for the object reference which shows you can use it in query(), retrieve() — SaiPraveen Kakkirala, Sep 28, 2022 at 10:48

SaiPraveen Kakkirala · Accepted Answer · 2022-09-28 10:38:39Z

1

For the records that are recalled you will have status as "Removed" you can use the below SOQL to get the records that are recalled.

SELECT Id, Status, TargetObject.type, CompletedDate FROM ProcessInstance where status ='Removed'

answered Sep 28, 2022 at 10:38

3,2581 gold badge4 silver badges14 bronze badges

Add a comment |

1 Answer 1