You are viewing limited content. For full access, please sign in.

Question

how to export process wise access rights

Forms

Updated March 26

asked on March 25

Hi,

I need to extract list of users from each process where we have provided them access in forms. There is no any download or export button to pull the data. Please guide how to export such data from forms process.

Best Regards,
Abhishek

0 0

Replies

replied on March 25

You can use the following sql query to get a list of bps and users and roles:

  select bp.name as 'bp name', ur.bizprocess_applied as 'bp id', u.username, ur.user_id, r.role_name from cf_users_in_role ur
  left join cf_business_processes bp on ur.bizprocess_applied = bp.bp_id
  left join cf_roles r on ur.role_id = r.role_id
  left join cf_users u on ur.user_id = u.user_id

0 0

replied on March 26

Thank you! Such query works for me.

0 0

You are not allowed to follow up in this post.

Sign in to reply to this post.

Asked March 25
Updated March 26
40 views