[SOLVED] Case note permission problem

Reply

[SOLVED] Case note permission problem#826106

By Bosatzu - Thu Aug 22, 2019 4:46 pm

- Thu Aug 22, 2019 4:46 pm #826106

Hello everyone!

I'm traying to give case note permission to a group inside a process. I already create the groups, but when I try to give the permisson it doesn't list the groups.

americana.png (39.28 KiB) Viewed 5417 times

hide.png (65.94 KiB) Viewed 5417 times

Last edited by Bosatzu on Mon Sep 02, 2019 6:51 pm, edited 1 time in total.

Re: Case note permission problem#826109

By amosbatto - Thu Aug 22, 2019 8:40 pm

- Thu Aug 22, 2019 8:40 pm #826109

I don't see that problem in PM 3.3.10 Community (manual install in Debian 9.5, PHP 5.6.37, MySQL 5.7.23) with Firefox 60.5.
What is your setup?

Do you have users or groups imported from Active Directory or LDAP?

Press F12 to open your web browser's debugger, and go to the "Network" tab and then search for a group in the Process Permissions dialog box. Every time you type a character, there should be a new query to POST to http://{ip-or-domain}/api/1.0/{workspace}/
If you click on the "Response", are you seeing the names of the groups?

groupSearchProcessPermissions.png (247.16 KiB) Viewed 5413 times

Re: Case note permission problem#826134

By Bosatzu - Sat Aug 24, 2019 12:59 pm

- Sat Aug 24, 2019 12:59 pm #826134

Hi Amos!

The groups were created just on the admin menu of PM.

I'm using:
PM: 3.3.3 CE Manual installation
OS: Ubuntu 16.04

The message that i get is:

Code: Select all

[{"status":400,"response":{"error":{"code":400,"message":"Bad Request:  [wrapped: Could not execute query [Native Error: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'wf_americana.TASK_USER.TAS_UID' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by] [User Info: SELECT TASK_USER.TAS_UID, TASK_USER.USR_UID, TASK_USER.TU_TYPE, TASK_USER.TU_RELATION, TASK_USER.USR_UID AS GRP_UID, COUNT(TASK_USER.USR_UID) AS NUM_REC FROM TASK_USER WHERE TASK_USER.TU_TYPE=1 AND TASK_USER.TU_RELATION=2 GROUP BY TASK_USER.USR_UID]]"}}},{"status":200,"response":[{"usr_uid":"00000000000000000000000000000001","usr_username":"zeus","usr_firstname":"Administrator","usr_lastname":"zeus","usr_email":"admin@processmaker.com","usr_due_date":"2020-01-01","usr_create_date":"1999-11-30 00:00:00","usr_update_date":"2008-05-23 18:36:19","usr_status":"ACTIVE","usr_country":"US","usr_city":"FL","usr_location":"MMK","usr_address":"","usr_phone":"","usr_fax":"1-305-402-0282","usr_cellular":"1-305-675-1400","usr_zip_code":"","dep_uid":"","usr_position":"Administrator","usr_resume":"","usr_birthday":"1999-02-25","usr_role":"PROCESSMAKER_ADMIN","usr_reports_to":"","usr_replaced_by":"","usr_calendar_uid":"","usr_calendar_name":"","usr_ux":"NORMAL","usr_photo_path":"\/var\/www\/html\/americana\/workflow\/public_html\/images\/user.gif"}]}]