Search engine with many criteria

[yllen]

https://forum.glpi-project.org/viewtopic.php?id=167848

2 criteria: status and items seen

request generated for Where
WHERE glpi_tickets.is_deleted = 0 AND ( glpi_tickets.entities_id IN ('1', '332') ) AND
( ( glpi_tickets.status IN ('2') AND (glpi_tickets.id LIKE '%test%' ) OR (glpi_tickets.name LIKE '%test%' ) OR (glpi_entities.completename LIKE '%test%' ) OR (glpi_tickettasks.content LIKE '%test%' ) OR (glpi_tickets.status LIKE '%test%' ) OR (CONVERT(glpi_tickets.date_mod USING utf8) LIKE '%test%' )) ) GROUP BY glpi_tickets.id
ORDER BY ITEM_Ticket_19 DESC

the bold ( must be after the first criterion so before the first LIKE
WHERE glpi_tickets.is_deleted = 0 AND ( glpi_tickets.entities_id IN ('1', '332') ) AND ( glpi_tickets.status IN ('2') AND
((glpi_tickets.id LIKE '%test%' ) OR (glpi_tickets.name LIKE '%test%' ) OR (glpi_entities.completename LIKE '%test%' ) OR (glpi_tickettasks.content LIKE '%test%' ) OR (glpi_tickets.status LIKE '%test%' ) OR (CONVERT(glpi_tickets.date_mod USING utf8) LIKE '%test%' )) ) GROUP BY glpi_tickets.id
ORDER BY ITEM_Ticket_19 DESC