Infos:
- Installation method: Kubernetes Helm Chart
- Operating system rhel 9.4
- Database + version: postgressql 15.4.0
- Elasticsearch version: 8.12
- Browser + version: chrome 127.0.6533.73, Firefox 128.0.3
Actual behavior:
-
When creating a report profile, a trigger or a workflow in Zammad and attempting to filter tickets based on fields that utilize an external data source, the system fails to perform the search. Specifically:
-
No results are returned when filtering by these fields. The loading icon just keeps spinning:
-
In “Expert Mode,” an error message appears: “
no implicit conversion of Symbol into Integer”. -
In the browser console, the following error occurs whenever typing in the field:
Uncaught TypeError: Cannot read properties of undefined (reading 'params') -
The server log contains the following error:
ERROR -- : Selector::Sql.get->InvalidCondition: Invalid condition pre_condition nil {:name=>"ticket.afdeling", :operator=>"is", :value_completion=>"test", :value=>[]}!.
Expected behavior:
-
When filtering tickets (or other objects) based on fields that utilize an external data source:
-
The system should correctly return tickets matching the filter criteria.
-
No errors should be triggered in the browser console, server logs, or in the interface.
Steps to reproduce the behavior:
- Go to Zammad’s Objects section and create a custom ticket attribute using an external data source.
- Create or update a ticket, filling in the custom attribute field that utilizes the external data source.
- Go to the Reports section and create a new report profile.
- Attempt to filter tickets based on the custom attribute field created in step 1.
- Notice that no results are returned, and errors occur in “Expert Mode” and the browser console.