[Bosatzu]

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 5407 times

hide.png (65.94 KiB) Viewed 5407 times

[amosbatto]

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 5403 times

[Bosatzu]

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"}]}]

notas.png (154.76 KiB) Viewed 5384 times

[amosbatto]

You need to configure MySQL. See:
https://wiki.processmaker.com/3.0/Addit ... ullGroupBy

[Bosatzu]

You need to configure MySQL. See:
https://wiki.processmaker.com/3.0/Addit ... ullGroupBy

Thanks a lot!!!!