search

itflow-org / itflow

Free and open-source web application for MSPs. Unifies IT documentation, ticketing, invoicing.
https://itflow.org
GNU General Public License v3.0
568 stars 147 forks source link

Fix ticket_assigned_to filter in SQL query #840

Closed o-psi closed 10 months ago

o-psi commented 10 months ago

This pull request fixes the ticket_assigned_to filter in the SQL query. Previously, the filter was using the LIKE operator with a wildcard at the beginning and end of the filter value. This caused incorrect results when searching for specific users, as you would want. The fix removes the wildcard at the beginning and end of the filter value, ensuring accurate filtering based on the assigned_to field.

wrongecho commented 10 months ago

Test these changes at: https://FixforuserIDsintickets840.pr-review.itflow.org
(automatic message)

o-psi commented 10 months ago

I am user ID 1, any technician that has a 1 in their ID shows up in my "My Tickets", so 10-19, 21, 31....

This fixes that issue.

sonarcloud[bot] commented 10 months ago

Quality Gate Passed Quality Gate passed

Kudos, no new issues were introduced!

0 New issues
0 Security Hotspots
No data about Coverage
0.0% Duplication on New Code

See analysis details on SonarCloud