Advanced Search Flags

[Alonso, Daniel]

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 ti.com


-----Original Message-----
From: developers-owner at bugzilla.org [mailto:developers-owner at bugzilla.org] On Behalf Of Alonso, Daniel
Sent: Thursday, December 19, 2013 11:41 AM
To: dev-apps-bugzilla at lists.mozilla.org
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 '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
-
To view or change your list settings, click here:
<http://bugzilla.org/cgi-bin/mj_wwwusr?user=daniel.alonso@ti.com>