Questions and discussion about using ProcessMaker: user interface, running cases & functionality

Moderator: amosbatto

User avatar
By 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 1874 times
hide.png (65.94 KiB) Viewed 1874 times
Last edited by Bosatzu on Mon Sep 02, 2019 6:51 pm, edited 1 time in total.
User avatar
By 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 1870 times
User avatar
By 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":"[email protected]","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 1851 times
ProcessMaker external Editor

Hi all, I am trying to follow how to use Processm[…]

Hi dan123dan, Even though your answer isn't direc[…]

If your plugin uses this (e.g. to insert data into[…]

Processmaker Installation on Linux

We are trying to install processmaker on linux ser[…]