Jump to content

What SQL Reporting table contains an authorisers details?


Recommended Posts

Hello all,

I'm trying to produce a report on all approvals sent and the table I've been trying to use is h_bpm_email_approvals, and unfortunately, it has proved fruitless when extracting relevant info i.e. "sent from" & "sent to" etc as these designated fields end up blank, is there a more effective table or method to extract such information?

Many thanks in advance,


Martin Mensah

Link to comment
Share on other sites

Hi Martin,

That is the correct table that holds the email approval info for the bpm engine.I believe the From address will only be set if you specifically put a from address in the bpm node at design time.

The To field should def have data in it, if it doesn't it means the person(s) you have tried to send the auth to don't have email address setup in their user data?

I have attached a test report that will join bpm instance table, email approvals table and sm requests table, it returns info as shown in screenshot. Feel free to upload that but if you are already reporting on that table i would expect you to get data.

Maybe change the select criteria to do where Sent To is not empty ? see if you get any data then? 

So as long as you have the Sent To address you could extend the report to join onto the users table to get the users name, tel info etc



Link to comment
Share on other sites

Just to clarify you are actually talking about "External Approvals" yes and not normal Approvals? To report on normal approvals (where a task is created and assigned to approver) you need to report on the h_sys_tasks table (select * from h_sys_tasks where h_reference = 'bpmApproval')


Link to comment
Share on other sites

  • 1 month later...

Hi Neil,

Thanks for your assistance but unfortunately, none of these solutions have worked for me, all the fields are empty.

I did find another table in the entity explorer called h_sm_request_approvers, however, the table dropdown in the report wizard doesn't display it as an option.

Is there a particular reason for this?





Link to comment
Share on other sites

  • 3 weeks later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...