PostgresSQL Error from Group Assign Filter

Plugins
1

Hi,

since my collegues encountered an somewhat strange SQL Error on filtering for Groups I invested some time and some Tokens to OpenAI to figure out “who dun it”

The issue:
selecting any group filter from the buttons right to the search field, resulted in an SQL Syntax error 42601, which, google tells, has to do mostly with wrong use of hyphens.

After identifiying the Group-Assign Plugin as a Problem, I quite quickly found TaskAllAssigneeFilter. php to have some issues.
Due to my insufficient PHP Knowledge (what remained from version 2.x is not enaugh) I droped the complete Text into ChatGPT with the request to analyze in regard to the above errorcode.

The result suggested for one, to cast the inline variable $this->value and change line 79 to read:

$this->query->addCondition(TaskModel::TABLE.".owner_gp IN (
    SELECT group_id FROM ".GroupMemberModel::TABLE." WHERE ".GroupMemberModel::TABLE.".user_id=" . intval($this->value) . ")");

and secondly to remove extra hyphens on line 107 (".GroupModel::TABLE.") to read:

$this->query->addCondition(TaskModel::TABLE.".owner_gp IN (SELECT group_id FROM ".GroupMemberModel::TABLE." WHERE ".GroupMemberModel::TABLE.".user_id IN ('$useridstring'))");

Solved my Problem so far.

So whoever sees him or herself fit to issue a pullrequest in github to fix the issue, please do so. For the time beeing this seems to be somewhat out of my competence.

Hope someone can make use of the information.

Michael