You are not logged in.
Hi there:
I think I've ran into an issue with the search criteria for Assigned To - Technician in ticket tracking. When I have that criteria selected as [All] I get no results. Looking at the SQL query it make sense to me why their are no results. The criteria represented in the query is
WHERE ( 1 ) AND ( `glpi_users_users_id_assign`.`id` = '0' )
Makes sense that there are no results seeing as we don't have a technician with an id of 0. Shouldn't the query read something along the lines of
WHERE ( 1 ) AND ( `glpi_users_users_id_assign`.`id` LIKE '%' )
Any help or clarification would be greatly appreciated.
Cheers,
David
Offline