Advanced Search Flags

[Alonso, Daniel]

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 'Search.pm' 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(flagtypes.name, flags.status) SEPARATOR ', ')  AS flags " .
                                                                                                                                  "FROM flags LEFT JOIN flagtypes ON flags.type_id = flagtypes.id " .
                                                                                                                                  "WHERE flagtypes.name = 'UC' GROUP BY bug_id) " .
                                                                                                                                  "AS map_flags_uc ON (bugs.bug_id = map_flags_uc.bug_id)");
                }

Thanks in advance.
Regards!

Daniel Luevano Alonso | Tool Support Engineer
* |  (214) 5673309
*Daniel.alonso at ti.com<mailto:Daniel.alonso at ti.com>
[TI2]

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 lists.mozilla.org
https://lists.mozilla.org/listinfo/dev-apps-bugzilla