How to identify type of approval with table: "sysapproval_approver"

[Rene Dugas]

Hi,

I'm looking for a way to identify approvals I need to make form a list.

I use "sysapproval_approver" table but there is no column telling me if the approval is for retirement or for publishing.

I some rare cases I need to make mass approval for retirement on some KBs and doing it from that list (table) would help me.

But I can't identifiy the ones that are for retiring or publishing.

There is a column called "approval reason" but it's always empty.

Thanks

Rene

[Dr Atul G- LNG]

Hi @Rene Dugas 

There’s no field in the sys_approval table that can provide this, because it’s linked with the flow that determines why and for what purpose the approval is ending. You might need to create a custom field and then get it from the flow here.

[Rene Dugas]

In the table I see some columns that could help.

Approval for, reason, source, step...

But they are always with empty value. 

Could something be done to the flow or table in order to fill these calues ?

[Dr Atul G- LNG · Accepted solution]

Hi @Rene Dugas OOTB, these are not getting populated, and I’d say it’s not that easy to get the purpose of approval — you’ll need a custom solution for this, mate. You need to get the details from the Flow and then map them to the appropriate field in the sys_approval table.