Advanced Search Flags

Alonso, Daniel daniel.alonso at
Thu Dec 19 17:41:15 UTC 2013

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

More information about the developers mailing list