Communauté des utilisateurs de GestSup
https://forum.gestsup.fr/
Code : Tout sélectionner
DEBUG MODE:
SELECT DISTINCT tincidents.id, tincidents.type, tincidents.technician, tincidents.t_group, tincidents.title, tincidents.user, tincidents.u_group, tincidents.u_service, tincidents.u_agency, tincidents.sender_service, tincidents.date_create, tincidents.date_hope, tincidents.date_res, tincidents.state, tincidents.priority, tincidents.criticality, tincidents.category, tincidents.subcat, tincidents.techread, tincidents.place, tincidents.asset_id
FROM tincidents, tstates, tthreads, tsubcat, tcategory, tassets, tusers
WHERE
tincidents.user=tusers.id AND
tincidents.state=tstates.id AND
tincidents.id=tthreads.ticket AND
tincidents.subcat=tsubcat.id AND
tincidents.category=tcategory.id AND
tincidents.asset_id=tassets.id AND
( tincidents.title LIKE '%afficha%' OR
tincidents.description LIKE '%afficha%' OR
tthreads.text LIKE '%afficha%' OR
tsubcat.name LIKE 'afficha' OR
tassets.netbios LIKE 'afficha' OR
tcategory.name LIKE 'afficha' OR
tincidents.id = 'afficha' OR
tincidents.user LIKE (SELECT max(id) FROM tusers where (firstname LIKE '%afficha%' OR
lastname LIKE '%afficha%') AND
disable=0) ) AND
( tincidents.user LIKE '%' AND
tincidents.disable='0' AND
tincidents.u_group LIKE '%' AND
tincidents.technician LIKE '%' AND
tincidents.t_group LIKE '%' AND
tincidents.techread LIKE '%' AND
tincidents.category LIKE '%' AND
tincidents.subcat LIKE '%' AND
tincidents.id LIKE '%' AND
tincidents.user LIKE '%' AND
tincidents.date_hope LIKE '%' AND
tincidents.priority LIKE '%' AND
tincidents.criticality LIKE '%' AND
tincidents.type LIKE '%' AND
tincidents.title LIKE '%' ) AND
tincidents.disable='0'
ORDER BY id DESC
LIMIT 0,30
VAR: POST_keywords=afficha GET_keywords='' | POST_state=% GET_state=% state= | POST_date_create=% GET_date_create= | cnt_service= | GET_view= | POST_date_start= | POST_date_end= | cnt_agency=
Recherche de tickets : afficha Nombre : 0
Erreur : Aucun ticket trouvé.