You are not logged in.
- Topics: Active | Unanswered
Announcement
Téléchargez la dernière version stable de GLPI
- Et vous, que pouvez vous faire pour le projet GLPI ? :
Contribuer
Download last stable version of GLPI - What can you do for GLPI ? : Contribute
Download last stable version of GLPI - What can you do for GLPI ? : Contribute
Pages: 1
Topic closed
#1 2010-11-17 12:57:19
- Xavstarblues
- Member
- Registered: 2010-09-02
- Posts: 12
Bug sur recherche multicritères pour les tickets
Bonjour j'ai trouvé un bug sur la recherche multicritères pour les tickets
Le "AND NOT" ne semble pas fonctionner, la requête est la même que pour AND
Exemple Recherche >
Statut "Non résolu" AND NOT Statut "En attente"
renvoie le même résultat que
Statut "Non résolu" AND Statut "En attente"
-GLPI 0.78.1 migré depuis 0.72.4
GLPI 0.78.1 ( => /home/glpi/www/glpi)
Server
Operating Systems : Linux XXXXXXXX 2.6.31-21-generic #59-Ubuntu SMP Wed Mar 24 07:28:56 UTC 2010 i686
PHP 5.2.10-2ubuntu6.4 (PDO, Reflection, SPL, SimpleXML, apache2handler, bcmath, bz2, calendar, ctype, date, dba, dom, exif,
filter, ftp, gettext, hash, iconv, json, ldap, libxml, mbstring, mime_magic, mysql, mysqli, openssl, pcre, pdo_mysql, posix,
session, shmop, soap, sockets, standard, sysvmsg, sysvsem, sysvshm, tokenizer, wddx, xml, xmlreader, xmlwriter, zip, zlib)
Setup: memory_limit="64M" max_execution_time="30" safe_mode="" session.save_handler="files" post_max_size="8M"
upload_max_filesize="2M"
Software: Apache/2.2.12 (Ubuntu) (Apache/2.2.12 (Ubuntu) Server at XXXXXXXXXX Port 80)
Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; IE7-01NET.COM-1.1; .NET CLR 2.0.50727; .NET4.0C; .NET4.0E; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729; IE7-01NET.COM-1.1)
MySQL: 5.1.37-1ubuntu5.1 (glpi@localhost/XXXXX)
Mysql replicate
Active : No
Plugins list
massocsimport Name:Import OCS Version :1.3.0 Status :Installed / not activated
LDAP directory
Server: 'ldap://XXXXX', Port (default=389): '389', Basedn: 'DC=XXXXXXXXX,DC=Local', Connection filter:
'(&(objectClass=user)(objectCategory=person)(!(userAccountControl:1.2.840.113556.1.4.803:=2)))', rootdn (for non anonymous
binds): 'glpi', Use TLS: '0'
Server: 'ldap://XXXXX', Port (default=389): '389', Basedn: 'DC=XXXXXXXX,DC=local', Connection filter:
'(&(objectClass=user)(objectCategory=person)(!(userAccountControl:1.2.840.113556.1.4.803:=2)))', rootdn (for non anonymous
binds): 'CN=glpi,CN=Users,DC=XXXXXXX,DC=local', Use TLS: '0'
Notifications / Mail Receiver
Use a SMTP server to send emails: PHP
Mail Receiver
OCS Inventory NG
Host for the OCSNG database : 'localhost', Connection to OCSNG database successful, Use the OCSNG software dictionary : 0
L'indication en mode debug sur la requete AND
N° Queries Time Errors
1 SHOW COLUMNS
FROM `glpi_tickets` 0.003
2 SHOW COLUMNS
FROM `glpi_tickets` 0.003
3 SELECT *
FROM `glpi_displaypreferences`
WHERE `itemtype` = 'Ticket' AND `users_id` = '304'
ORDER BY `rank` 0.000
4 SELECT *
FROM `glpi_displaypreferences`
WHERE `itemtype` = 'Ticket' AND `users_id` = '0'
ORDER BY `rank` 0.000
5 SHOW COLUMNS
FROM `glpi_tickets` 0.003
6 SET SESSION group_concat_max_len = 9999999; 0.014
7 SELECT `glpi_tickets`.`id` AS ITEM_0, `glpi_tickets`.`name` AS ITEM_1, `glpi_tickets`.`id` AS ITEM_1_2, `glpi_tickets`.`content` AS ITEM_1_3, `glpi_tickets`.`status` AS ITEM_1_4,`glpi_tickets`.`status` AS ITEM_2, `glpi_tickets`.`date_mod` AS ITEM_3, `glpi_tickets`.`date` AS ITEM_4, `glpi_tickets`.`priority` AS ITEM_5, `glpi_users_users_id`.`name` AS ITEM_6, `glpi_users_users_id`.`realname` AS ITEM_6_2, `glpi_users_users_id`.`id` AS ITEM_6_3, `glpi_users_users_id`.`firstname` AS ITEM_6_4, `glpi_users_users_id_assign`.`name` AS ITEM_7, `glpi_users_users_id_assign`.`realname` AS ITEM_7_2, `glpi_users_users_id_assign`.`id` AS ITEM_7_3, `glpi_users_users_id_assign`.`firstname` AS ITEM_7_4, `glpi_ticketcategories`.`completename` AS ITEM_8, `glpi_tickets`.`id` AS id
FROM `glpi_tickets`
LEFT JOIN `glpi_ticketvalidations` ON (`glpi_tickets`.`id` = `glpi_ticketvalidations`.`tickets_id`)
LEFT JOIN `glpi_users` AS glpi_users_users_id ON (`glpi_tickets`.`users_id` = `glpi_users_users_id`.`id`)
LEFT JOIN `glpi_users` AS glpi_users_users_id_assign ON (`glpi_tickets`.`users_id_assign` = `glpi_users_users_id_assign`.`id`)
LEFT JOIN `glpi_ticketcategories` ON (`glpi_tickets`.`ticketcategories_id` = `glpi_ticketcategories`.`id`)
WHERE ( 1 ) AND ( ( `glpi_tickets`.`status` = 'new' OR `glpi_tickets`.`status` = 'plan' OR `glpi_tickets`.`status` = 'assign' OR `glpi_tickets`.`status` = 'waiting' ) AND( `glpi_tickets`.`status` = 'waiting' ) ) GROUP BY `glpi_tickets`.`id`
ORDER BY ITEM_3 DESC 0.004
8 SELECT *
FROM `glpi_users`
WHERE `id`='530' 0.000
9 SELECT *
FROM `glpi_users`
WHERE `id`='304' 0.000
10 SELECT *
FROM `glpi_locations`
WHERE `id` = '1' 0.000
11 SELECT *
FROM `glpi_users`
WHERE `id`='409' 0.012
12 SELECT *
FROM `glpi_users`
WHERE `id`='304' 0.000
13 SELECT *
FROM `glpi_locations`
WHERE `id` = '1' 0.000
14 SELECT *
FROM `glpi_users`
WHERE `id`='405' 0.000
15 SELECT *
FROM `glpi_users`
WHERE `id`='304' 0.000
16 SELECT *
FROM `glpi_locations`
WHERE `id` = '1' 0.000
17 SELECT *
FROM `glpi_users`
WHERE `id`='530' 0.000
18 SELECT *
FROM `glpi_users`
WHERE `id`='445' 0.000
19 SELECT *
FROM `glpi_users`
WHERE `id`='376' 0.000
20 SELECT *
FROM `glpi_users`
WHERE `id`='445' 0.000
21 SELECT *
FROM `glpi_users`
WHERE `id`='376' 0.000
22 SELECT *
FROM `glpi_users`
WHERE `id`='445' 0.000
23 SELECT *
FROM `glpi_users`
WHERE `id`='304' 0.012
24 SELECT *
FROM `glpi_locations`
WHERE `id` = '1' 0.000
25 SELECT *
FROM `glpi_users`
WHERE `id`='304' 0.000
26 SELECT *
FROM `glpi_locations`
WHERE `id` = '1' 0.000
27 SELECT *
FROM `glpi_users`
WHERE `id`='491' 0.000
28 SELECT *
FROM `glpi_users`
WHERE `id`='304' 0.000
29 SELECT *
FROM `glpi_locations`
WHERE `id` = '1' 0.000
30 SELECT *
FROM `glpi_users`
WHERE `id`='494' 0.000
31 SELECT *
FROM `glpi_users`
WHERE `id`='304' 0.000
32 SELECT *
FROM `glpi_locations`
WHERE `id` = '1' 0.000
33 SELECT *
FROM `glpi_users`
WHERE `id`='428' 0.000
34 SELECT *
FROM `glpi_users`
WHERE `id`='445' 0.000
35 SHOW COLUMNS
FROM `glpi_tickets` 0.021
AUTOLOAD
Plugin, Search, Ticket, Dropdown, Bookmark, DisplayPreference, CommonDropdown, CommonTreeDropdown, Location, Infocom, Document, TicketFollowup, TicketTask, CommonDBChild, TicketValidation
POST VARIABLE
KEY => VALUE
itemtype => Ticket
num => 1
field => 12
searchtype => equals
value => waiting
meta => 0
GET VARIABLE
KEY => VALUE
field =>
KEY => VALUE
0 => 12
1 => 12
searchtype =>
KEY => VALUE
0 => equals
1 => equals
contains =>
KEY => VALUE
0 => notold
1 => waiting
link =>
KEY => VALUE
1 => AND NOT
itemtype => Ticket
start => 0
order => DESC
is_deleted => 0
distinct => N
link2 =>
KEY => VALUE
0 => AND
field2 =>
KEY => VALUE
0 => view
contains2 =>
KEY => VALUE
0 =>
itemtype2 =>
KEY => VALUE
0 =>
searchtype2 =>
sort => 19
SESSION VARIABLE
KEY => VALUE
glpi_plugins =>
glpicookietest => testcookie
glpi_use_mode => 2
glpiID => 304
glpiname => xavier.sirard
glpirealname => Sirard
glpifirstname => Xavier
glpidefault_entity => 0
glpiusers_idisation => 1
glpiextauth => 1
glpiauthtype => 3
glpiroot =>
glpicrontimer => 1289988952
glpi_tabs =>
KEY => VALUE
central => 1
glpidate_format => 0
glpidefault_requesttypes_id => 1
glpidropdown_chars_limit => 50
glpifollowup_private => 0
glpitask_private => 0
glpiis_categorized_soft_expanded => 1
glpiis_ids_visible => 0
glpiis_not_categorized_soft_expanded => 1
glpilanguage => fr_FR
glpilist_limit => 100
glpinumber_format => 0
glpipriority_1 => #fff2f2
glpipriority_2 => #ffe0e0
glpipriority_3 => #ffcece
glpipriority_4 => #ffbfbf
glpipriority_5 => #ffadad
glpipriority_6 => #ff5555
glpishow_jobs_at_login => 0
glpiuse_flat_dropdowntree => 0
glpiprofiles =>
KEY => VALUE
1 =>
KEY => VALUE
name => post-only
entities =>
KEY => VALUE
0 =>
KEY => VALUE
id => 0
name =>
is_recursive => 0
4 =>
KEY => VALUE
name => super-admin
entities =>
KEY => VALUE
0 =>
KEY => VALUE
id => 0
name =>
is_recursive => 1
5 =>
KEY => VALUE
name => Test
entities =>
KEY => VALUE
0 =>
KEY => VALUE
id => 0
name =>
is_recursive => 0
glpiactiveprofile =>
KEY => VALUE
id => 4
name => super-admin
interface => central
is_default => 0
computer => w
monitor => w
software => w
networking => w
printer => w
peripheral => w
cartridge => w
consumable => w
phone => w
notes => w
contact_enterprise => w
document => w
contract => w
infocom => w
knowbase => w
faq => w
reservation_helpdesk => 1
reservation_central => w
reports => r
ocsng => w
view_ocsng => r
sync_ocsng => w
dropdown => w
entity_dropdown => w
device => w
typedoc => w
link => w
config => w
rule_ticket => r
entity_rule_ticket => w
rule_ocs => w
rule_ldap => w
rule_softwarecategories => w
search_config => w
search_config_global => w
check_update => r
profile => w
user => w
user_authtype => w
group => w
entity => w
transfer => w
logs => r
reminder_public => w
bookmark_public => w
backup => w
create_ticket => 1
delete_ticket => 1
add_followups => 1
group_add_followups => 1
global_add_followups => 1
global_add_tasks => 1
update_ticket => 1
update_priority => 1
own_ticket => 1
steal_ticket => 1
assign_ticket => 1
show_all_ticket => 1
show_assign_ticket => 1
show_full_ticket => 1
observe_ticket => 1
update_followups => 1
update_tasks => 1
show_planning => 1
show_group_planning => 1
show_all_planning => 1
statistic => 1
password_update => 1
helpdesk_hardware => 3
helpdesk_item_type =>
KEY => VALUE
0 => Computer
1 => Software
2 => Phone
helpdesk_status =>
show_group_ticket => 0
show_group_hardware => 0
rule_dictionnary_software => w
rule_dictionnary_dropdown => w
budget => w
import_externalauth_users => w
notification => w
rule_mailcollector => w
date_mod =>
comment =>
validate_ticket => 1
create_validation => 1
entities =>
KEY => VALUE
0 =>
KEY => VALUE
id => 0
name =>
is_recursive => 1
glpiactiveentities =>
KEY => VALUE
0 => 0
glpisearch =>
KEY => VALUE
Ticket =>
KEY => VALUE
start => 0
order => DESC
is_deleted => 0
distinct => N
link =>
KEY => VALUE
1 => AND NOT
field =>
KEY => VALUE
0 => 12
1 => 12
contains =>
KEY => VALUE
0 => notold
1 => waiting
searchtype =>
KEY => VALUE
0 => equals
1 => equals
link2 =>
KEY => VALUE
0 => AND
field2 =>
KEY => VALUE
0 => view
contains2 =>
KEY => VALUE
0 =>
itemtype2 =>
KEY => VALUE
0 =>
searchtype2 =>
sort => 19
itemtype => Ticket
glpisearchcount =>
KEY => VALUE
Ticket => 2
glpisearchcount2 =>
KEY => VALUE
Ticket => 0
glpiactiveentities_string => '0'
glpiparententities =>
glpiparententities_string =>
glpiactive_entity => 0
glpiactive_entity_name => Entité racine (arborescence)
glpiactive_entity_shortname => Entité racine (arborescence)
glpishowallentities => 1
glpigroups =>
KEY => VALUE
0 => 423
glpi_currenttime => 2010-11-17 11:16:39
MESSAGE_AFTER_REDIRECT =>
glpi_multientitiesmode => 0
glpilisttitle =>
KEY => VALUE
Ticket => Liste
glpilistitems =>
KEY => VALUE
Ticket =>
KEY => VALUE
0 => 93
1 => 82
2 => 12
3 => 120
4 => 77
5 => 115
6 => 25
7 => 60
8 => 24
9 => 86
glpilisturl =>
KEY => VALUE
Ticket => /front/ticket.php?field%5B0%5D=12&searchtype%5B0%5D=equals&contains%5B0%5D=notold&link%5B1%5D=AND+NOT&field%5B1%5D=12&searchtype%5B1%5D=equals&contains%5B1%5D=waiting&itemtype=Ticket&start=0
glpimassiveactionselected => La requete AND NOT
N° Queries Time Errors
1 SHOW COLUMNS
FROM `glpi_tickets` 0.003
2 SHOW COLUMNS
FROM `glpi_tickets` 0.003
3 SELECT *
FROM `glpi_displaypreferences`
WHERE `itemtype` = 'Ticket' AND `users_id` = '304'
ORDER BY `rank` 0.000
4 SELECT *
FROM `glpi_displaypreferences`
WHERE `itemtype` = 'Ticket' AND `users_id` = '0'
ORDER BY `rank` 0.000
5 SHOW COLUMNS
FROM `glpi_tickets` 0.003
6 SET SESSION group_concat_max_len = 9999999; 0.001
7 SELECT `glpi_tickets`.`id` AS ITEM_0, `glpi_tickets`.`name` AS ITEM_1, `glpi_tickets`.`id` AS ITEM_1_2, `glpi_tickets`.`content` AS ITEM_1_3, `glpi_tickets`.`status` AS ITEM_1_4,`glpi_tickets`.`status` AS ITEM_2, `glpi_tickets`.`date_mod` AS ITEM_3, `glpi_tickets`.`date` AS ITEM_4, `glpi_tickets`.`priority` AS ITEM_5, `glpi_users_users_id`.`name` AS ITEM_6, `glpi_users_users_id`.`realname` AS ITEM_6_2, `glpi_users_users_id`.`id` AS ITEM_6_3, `glpi_users_users_id`.`firstname` AS ITEM_6_4, `glpi_users_users_id_assign`.`name` AS ITEM_7, `glpi_users_users_id_assign`.`realname` AS ITEM_7_2, `glpi_users_users_id_assign`.`id` AS ITEM_7_3, `glpi_users_users_id_assign`.`firstname` AS ITEM_7_4, `glpi_ticketcategories`.`completename` AS ITEM_8, `glpi_tickets`.`id` AS id
FROM `glpi_tickets`
LEFT JOIN `glpi_ticketvalidations` ON (`glpi_tickets`.`id` = `glpi_ticketvalidations`.`tickets_id`)
LEFT JOIN `glpi_users` AS glpi_users_users_id ON (`glpi_tickets`.`users_id` = `glpi_users_users_id`.`id`)
LEFT JOIN `glpi_users` AS glpi_users_users_id_assign ON (`glpi_tickets`.`users_id_assign` = `glpi_users_users_id_assign`.`id`)
LEFT JOIN `glpi_ticketcategories` ON (`glpi_tickets`.`ticketcategories_id` = `glpi_ticketcategories`.`id`)
WHERE ( 1 ) AND ( ( `glpi_tickets`.`status` = 'new' OR `glpi_tickets`.`status` = 'plan' OR `glpi_tickets`.`status` = 'assign' OR `glpi_tickets`.`status` = 'waiting' ) AND( `glpi_tickets`.`status` = 'waiting' ) ) GROUP BY `glpi_tickets`.`id`
ORDER BY ITEM_3 DESC 0.000
8 SELECT *
FROM `glpi_users`
WHERE `id`='530' 0.000
9 SELECT *
FROM `glpi_users`
WHERE `id`='304' 0.000
10 SELECT *
FROM `glpi_locations`
WHERE `id` = '1' 0.000
11 SELECT *
FROM `glpi_users`
WHERE `id`='409' 0.000
12 SELECT *
FROM `glpi_users`
WHERE `id`='304' 0.000
13 SELECT *
FROM `glpi_locations`
WHERE `id` = '1' 0.000
14 SELECT *
FROM `glpi_users`
WHERE `id`='405' 0.000
15 SELECT *
FROM `glpi_users`
WHERE `id`='304' 0.000
16 SELECT *
FROM `glpi_locations`
WHERE `id` = '1' 0.000
17 SELECT *
FROM `glpi_users`
WHERE `id`='530' 0.000
18 SELECT *
FROM `glpi_users`
WHERE `id`='445' 0.000
19 SELECT *
FROM `glpi_users`
WHERE `id`='376' 0.000
20 SELECT *
FROM `glpi_users`
WHERE `id`='445' 0.000
21 SELECT *
FROM `glpi_users`
WHERE `id`='376' 0.000
22 SELECT *
FROM `glpi_users`
WHERE `id`='445' 0.000
23 SELECT *
FROM `glpi_users`
WHERE `id`='304' 0.000
24 SELECT *
FROM `glpi_locations`
WHERE `id` = '1' 0.000
25 SELECT *
FROM `glpi_users`
WHERE `id`='304' 0.000
26 SELECT *
FROM `glpi_locations`
WHERE `id` = '1' 0.000
27 SELECT *
FROM `glpi_users`
WHERE `id`='491' 0.000
28 SELECT *
FROM `glpi_users`
WHERE `id`='304' 0.000
29 SELECT *
FROM `glpi_locations`
WHERE `id` = '1' 0.000
30 SELECT *
FROM `glpi_users`
WHERE `id`='494' 0.000
31 SELECT *
FROM `glpi_users`
WHERE `id`='304' 0.000
32 SELECT *
FROM `glpi_locations`
WHERE `id` = '1' 0.000
33 SELECT *
FROM `glpi_users`
WHERE `id`='428' 0.000
34 SELECT *
FROM `glpi_users`
WHERE `id`='445' 0.000
35 SHOW COLUMNS
FROM `glpi_tickets` 0.003
AUTOLOAD
Plugin, Search, Ticket, Dropdown, Bookmark, DisplayPreference, CommonDropdown, CommonTreeDropdown, Location, Infocom, Document, TicketFollowup, TicketTask, CommonDBChild, TicketValidation
POST VARIABLE
KEY => VALUE
itemtype => Ticket
num => 1
field => 12
searchtype => equals
value => waiting
meta => 0
GET VARIABLE
KEY => VALUE
field =>
KEY => VALUE
0 => 12
1 => 12
searchtype =>
KEY => VALUE
0 => equals
1 => equals
contains =>
KEY => VALUE
0 => notold
1 => waiting
link =>
KEY => VALUE
1 => AND
itemtype => Ticket
start => 0
order => DESC
is_deleted => 0
distinct => N
link2 =>
KEY => VALUE
0 => AND
field2 =>
KEY => VALUE
0 => view
contains2 =>
KEY => VALUE
0 =>
itemtype2 =>
KEY => VALUE
0 =>
searchtype2 =>
sort => 19
SESSION VARIABLE
KEY => VALUE
glpi_plugins =>
glpicookietest => testcookie
glpi_use_mode => 2
glpiID => 304
glpiname => xavier.sirard
glpirealname => Sirard
glpifirstname => Xavier
glpidefault_entity => 0
glpiusers_idisation => 1
glpiextauth => 1
glpiauthtype => 3
glpiroot =>
glpicrontimer => 1289988952
glpi_tabs =>
KEY => VALUE
central => 1
glpidate_format => 0
glpidefault_requesttypes_id => 1
glpidropdown_chars_limit => 50
glpifollowup_private => 0
glpitask_private => 0
glpiis_categorized_soft_expanded => 1
glpiis_ids_visible => 0
glpiis_not_categorized_soft_expanded => 1
glpilanguage => fr_FR
glpilist_limit => 100
glpinumber_format => 0
glpipriority_1 => #fff2f2
glpipriority_2 => #ffe0e0
glpipriority_3 => #ffcece
glpipriority_4 => #ffbfbf
glpipriority_5 => #ffadad
glpipriority_6 => #ff5555
glpishow_jobs_at_login => 0
glpiuse_flat_dropdowntree => 0
glpiprofiles =>
KEY => VALUE
1 =>
KEY => VALUE
name => post-only
entities =>
KEY => VALUE
0 =>
KEY => VALUE
id => 0
name =>
is_recursive => 0
4 =>
KEY => VALUE
name => super-admin
entities =>
KEY => VALUE
0 =>
KEY => VALUE
id => 0
name =>
is_recursive => 1
5 =>
KEY => VALUE
name => Test
entities =>
KEY => VALUE
0 =>
KEY => VALUE
id => 0
name =>
is_recursive => 0
glpiactiveprofile =>
KEY => VALUE
id => 4
name => super-admin
interface => central
is_default => 0
computer => w
monitor => w
software => w
networking => w
printer => w
peripheral => w
cartridge => w
consumable => w
phone => w
notes => w
contact_enterprise => w
document => w
contract => w
infocom => w
knowbase => w
faq => w
reservation_helpdesk => 1
reservation_central => w
reports => r
ocsng => w
view_ocsng => r
sync_ocsng => w
dropdown => w
entity_dropdown => w
device => w
typedoc => w
link => w
config => w
rule_ticket => r
entity_rule_ticket => w
rule_ocs => w
rule_ldap => w
rule_softwarecategories => w
search_config => w
search_config_global => w
check_update => r
profile => w
user => w
user_authtype => w
group => w
entity => w
transfer => w
logs => r
reminder_public => w
bookmark_public => w
backup => w
create_ticket => 1
delete_ticket => 1
add_followups => 1
group_add_followups => 1
global_add_followups => 1
global_add_tasks => 1
update_ticket => 1
update_priority => 1
own_ticket => 1
steal_ticket => 1
assign_ticket => 1
show_all_ticket => 1
show_assign_ticket => 1
show_full_ticket => 1
observe_ticket => 1
update_followups => 1
update_tasks => 1
show_planning => 1
show_group_planning => 1
show_all_planning => 1
statistic => 1
password_update => 1
helpdesk_hardware => 3
helpdesk_item_type =>
KEY => VALUE
0 => Computer
1 => Software
2 => Phone
helpdesk_status =>
show_group_ticket => 0
show_group_hardware => 0
rule_dictionnary_software => w
rule_dictionnary_dropdown => w
budget => w
import_externalauth_users => w
notification => w
rule_mailcollector => w
date_mod =>
comment =>
validate_ticket => 1
create_validation => 1
entities =>
KEY => VALUE
0 =>
KEY => VALUE
id => 0
name =>
is_recursive => 1
glpiactiveentities =>
KEY => VALUE
0 => 0
glpisearch =>
KEY => VALUE
Ticket =>
KEY => VALUE
start => 0
order => DESC
is_deleted => 0
distinct => N
link =>
KEY => VALUE
1 => AND
field =>
KEY => VALUE
0 => 12
1 => 12
contains =>
KEY => VALUE
0 => notold
1 => waiting
searchtype =>
KEY => VALUE
0 => equals
1 => equals
link2 =>
KEY => VALUE
0 => AND
field2 =>
KEY => VALUE
0 => view
contains2 =>
KEY => VALUE
0 =>
itemtype2 =>
KEY => VALUE
0 =>
searchtype2 =>
sort => 19
itemtype => Ticket
glpisearchcount =>
KEY => VALUE
Ticket => 2
glpisearchcount2 =>
KEY => VALUE
Ticket => 0
glpiactiveentities_string => '0'
glpiparententities =>
glpiparententities_string =>
glpiactive_entity => 0
glpiactive_entity_name => Entité racine (arborescence)
glpiactive_entity_shortname => Entité racine (arborescence)
glpishowallentities => 1
glpigroups =>
KEY => VALUE
0 => 423
glpi_currenttime => 2010-11-17 11:19:50
MESSAGE_AFTER_REDIRECT =>
glpi_multientitiesmode => 0
glpilisttitle =>
KEY => VALUE
Ticket => Liste
glpilistitems =>
KEY => VALUE
Ticket =>
KEY => VALUE
0 => 93
1 => 82
2 => 12
3 => 120
4 => 77
5 => 115
6 => 25
7 => 60
8 => 24
9 => 86
glpilisturl =>
KEY => VALUE
Ticket => /front/ticket.php?field%5B0%5D=12&searchtype%5B0%5D=equals&contains%5B0%5D=notold&link%5B1%5D=AND&field%5B1%5D=12&searchtype%5B1%5D=equals&contains%5B1%5D=waiting&itemtype=Ticket&start=0
glpimassiveactionselected => - Pas d'erreur dans les fichiers de log
php-errors.log
Test
Test
Test
TestSinon un cron.log et un mail.log qui ne me semble pas d'utilité.
- Navigateur IE7-FF3.6.12
---
Histoire de gagner du temps, j'ai déja fait un comparatif des deux requêtes.
Comparaison des fichiers query1.txt et QUERY2.TXT
***** query1.txt
FROM `glpi_tickets` 0.003
6 SET SESSION group_concat_max_len = 9999999; 0.014
7 SELECT `glpi_tickets`.`id` AS ITEM_0, `glpi_tickets`.`name` AS ITEM_1, `glpi_tickets`.`id` AS ITEM_1_2, `glpi_tickets`.
***** QUERY2.TXT
FROM `glpi_tickets` 0.003
6 SET SESSION group_concat_max_len = 9999999; 0.001
7 SELECT `glpi_tickets`.`id` AS ITEM_0, `glpi_tickets`.`name` AS ITEM_1, `glpi_tickets`.`id` AS ITEM_1_2, `glpi_tickets`.
*****
***** query1.txt
`glpi_tickets`.`status` = 'waiting' ) AND( `glpi_tickets`.`status` = 'waiting' ) ) GROUP BY `glpi_tickets`.`id`
ORDER BY ITEM_3 DESC 0.004
8 SELECT *
***** QUERY2.TXT
`glpi_tickets`.`status` = 'waiting' ) AND( `glpi_tickets`.`status` = 'waiting' ) ) GROUP BY `glpi_tickets`.`id`
ORDER BY ITEM_3 DESC 0.000
8 SELECT *
*****
***** query1.txt
FROM `glpi_users`
WHERE `id`='409' 0.012
12 SELECT *
***** QUERY2.TXT
FROM `glpi_users`
WHERE `id`='409' 0.000
12 SELECT *
*****
***** query1.txt
FROM `glpi_users`
WHERE `id`='304' 0.012
24 SELECT *
***** QUERY2.TXT
FROM `glpi_users`
WHERE `id`='304' 0.000
24 SELECT *
*****
***** query1.txt
35 SHOW COLUMNS
FROM `glpi_tickets` 0.021
AUTOLOAD
***** QUERY2.TXT
35 SHOW COLUMNS
FROM `glpi_tickets` 0.003
AUTOLOAD
*****
***** query1.txt
KEY => VALUE
1 => AND NOT
itemtype => Ticket
***** QUERY2.TXT
KEY => VALUE
1 => AND
itemtype => Ticket
*****
***** query1.txt
KEY => VALUE
1 => AND NOT
field =>
***** QUERY2.TXT
KEY => VALUE
1 => AND
field =>
*****
***** query1.txt
0 => 423
glpi_currenttime => 2010-11-17 11:16:39
MESSAGE_AFTER_REDIRECT =>
***** QUERY2.TXT
0 => 423
glpi_currenttime => 2010-11-17 11:19:50
MESSAGE_AFTER_REDIRECT =>
*****
***** query1.txt
KEY => VALUE
Ticket => /front/ticket.php?field%5B0%5D=12&searchtype%5B0%5D=equals&contains%5B0%5D=notold&link%5B1%5D=AND+NOT&field%5B1
5D=12&searchtype%5B1%5D=equals&contains%5B1%5D=waiting&itemtype=Ticket&start=0
glpimassiveactionselected =>
***** QUERY2.TXT
KEY => VALUE
Ticket => /front/ticket.php?field%5B0%5D=12&searchtype%5B0%5D=equals&contains%5B0%5D=notold&link%5B1%5D=AND&field%5B1%5D=
2&searchtype%5B1%5D=equals&contains%5B1%5D=waiting&itemtype=Ticket&start=0
glpimassiveactionselected =>
*****Sinon, j'ai fait le test avec d'autres "variables " et il semble que ce soit bien le AND NOT qui ne fonctionne pas.
Offline
#2 2010-11-17 13:06:25
- yllen
- GLPI-DEV
- From: Sillery (51)
- Registered: 2008-01-14
- Posts: 15,278
Re: Bug sur recherche multicritères pour les tickets
Effectivement je reproduit le bug.
Ticket ouvert https://forge.indepnet.net/issues/2461
CentOS 6.5 - CentOS 7.x
PHP 5.6 - PHP 7.x - MySQL 5.6 - MariaDB 10.2 + APC + oOPcache
GLPI from 0.72 to dev version
Certifiée ITIL (ITV2F, ITILF, ITILOSA)
Offline
#3 2010-11-17 16:53:03
- MoYo
- GLPI - Lead
- From: Poitiers
- Registered: 2004-09-13
- Posts: 14,513
- Website
Re: Bug sur recherche multicritères pour les tickets
la correction ici : https://forge.indepnet.net/projects/glp … ions/13084
MoYo - Julien Dombre - Association INDEPNET
Contribute to GLPI : Support Contribute References Freshmeat
Offline
Pages: 1
Topic closed