Advanced Search Flags

Alonso, Daniel daniel.alonso at
Fri Dec 20 21:22:44 UTC 2013

Actually I want to use the Boolean chart for advanced search, If you have any documentation on how to implement it or change it on the code it would be great! 

Thanks in advance.

Daniel Luevano Alonso | Tool Support Engineer 
Phone |  214 5673309
Daniel.alonso at

-----Original Message-----
From: developers-owner at [mailto:developers-owner at] On Behalf Of Alonso, Daniel
Sent: Thursday, December 19, 2013 11:41 AM
To: dev-apps-bugzilla at
Subject: Advanced Search Flags

Hi All,

Recently  I add a flag 'DR' to my flags list, but it wasn't included to the 'Advanced Search' Form so I added thru code.
But I found an issue with the functionality:
Everything goes good when search is based on just ONE flag. BUT if 'CR' and 'DR' Flags are combined to search, the result is always ZERO.

I thought with this part of code on '' solved this, but it didn't work:
if (grep(/map_flags_uc/, @$fieldsref)) {
                                push(@supptables_special, "LEFT JOIN (SELECT DISTINCT flags.bug_id AS bug_id, GROUP_CONCAT(CONCAT(, flags.status) SEPARATOR ', ')  AS flags " .
                                                                                                                                  "FROM flags LEFT JOIN flagtypes ON flags.type_id = " .
                                                                                                                                  "WHERE = 'UC' GROUP BY bug_id) " .
                                                                                                                                  "AS map_flags_uc ON (bugs.bug_id = map_flags_uc.bug_id)");

Thanks in advance.

Daniel Luevano Alonso | Tool Support Engineer
* |  (214) 5673309
*Daniel.alonso at<mailto:Daniel.alonso at>

P Don't print this email unless you really need to, The environment is everyone's responsibility P

dev-apps-bugzilla mailing list
dev-apps-bugzilla at
To view or change your list settings, click here:

More information about the developers mailing list