Description of problem: trying to find bugs which contain more than 1 issue tracker does not work using the following boolean query, which I believe should work. cf_issue_trackers::greaterthan::1 cf_issue_trackers::greaterthan::2 cf_issue_trackers::greaterthan::3.... all these find all bugs with 1 or more issuetrackers. Expected: cf_issue_trackers::greaterthan::1 would find all bugzillas which have 2 or more. cf_issue_trackers::greaterthan::2 would find all bugzillas which have 3 or more. etc....
Hi Chris, Basically the search for issue trackers doesn't work as how you mentioned, greater than 1 0r 2 or 3 is not searching for how many issue trackers that a bug has, it is actually comparing actual issue tracker ids to 1 or 2 or 3 so searching for bugs with issue tracker greater than 1 will return all bugs that has issue tracker ids greater than 1, so it will not return a bug for example that has an issue tracker with is 0 if there was one. if you say greater than 200000 it will return for example something with id 290879 but not 129887. I don't think there is actually a way to search for how many issue trackers are associated with a bug at the moment. Noura
Ah ha. I guess this explains why when one tries to sort based on the issue trackers column it sorts not on the number of issue trackers but on the lowest to highest. Well it would certainly be useful to be able to search based on the number of issue trackers because, for example, it's much more important a bug when a bug has multiple issue trackers rather than one. It helps to prioritize devel and testing focus. So i guess i'll turn this into a feature request. :)
Chris, You can have a look at those reports https://engineering.redhat.com/metrics/bugzilla-metrics.cgi?page=it-check Maybe you can find what you are trying to look for. Also i am CC'ing bgroh maybe he has a better ides. Cheers, Noura
the links on that page fail. .... ACK Viewer Error Error executing run mode 'it-with-many-bz': DBI connect('dbname=portal;host=cspdb2.db.dev.redhat.com;port=3306;','EngReportUser',...) failed: Access denied for user 'EngReportUser'@'bzutils.engineering.redhat.com' (using password: YES) at /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/DBI.pm line 650 DBI::__ANON__('undef', 'undef') called at /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/DBI.pm line 705 DBI::connect('DBI', 'dbi:mysql:dbname=portal;host=cspdb2.db.dev.redhat.com;port=3306;', 'EngReportUser', ..., 'HASH(0x22c6a50)') called at /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/DBI.pm line 547 DBI::connect_cached('DBI', 'dbi:mysql:dbname=portal;host=cspdb2.db.dev.redhat.com;port=3306;', 'EngReportUser', ..., 'HASH(0x1fcc180)') called at lib/BugzillaMetrics/Database.pm line 45 eval {...} called at lib/BugzillaMetrics/Database.pm line 44 BugzillaMetrics::Database::connect('BugzillaMetrics') called at lib/BugzillaMetrics/IT.pm line 53 BugzillaMetrics::IT::get_it_bz_diff('BugzillaMetrics::IT') called at lib/BugzillaMetrics/WebApp/IT.pm line 93 BugzillaMetrics::WebApp::it_with_many_bz('BugzillaMetrics::WebApp=HASH(0x201f640)') called at /usr/lib/perl5/site_perl/5.8.5/CGI/Application.pm line 142 eval {...} called at /usr/lib/perl5/site_perl/5.8.5/CGI/Application.pm line 142 CGI::Application::run('BugzillaMetrics::WebApp=HASH(0x201f640)') called at lib/BugzillaMetrics/WebApp.pm line 45 BugzillaMetrics::WebApp::run('BugzillaMetrics::WebApp=HASH(0x201f640)') called at /var/www/html/metrics/bugzilla-metrics.cgi line 18 eval {...} called at /var/www/html/metrics/bugzilla-metrics.cgi line 11 2009-05-15 08:52:54
I reported it to engineering-services
this is the same issue with other fields too, like Partner/Verified fields for example also fail to return results which correspond to the greaterthan::X value. But seems this request will have to turn into a feature request, as i don't think anyone's going to want modify the current behaviour....i imagine it's seen as a feature, not a defect. hmmm...
Changing description. Guess i already changed this into a feature a short while ago... and forgot. hehe. So basically, i think if we could have another type of boolean operator: 'countgreaterthan' and 'countlessthan' and 'countequals' which compared the value to the number of 'items' in the field, it would work like a charm.
*** Bug 501559 has been marked as a duplicate of this bug. ***
This issue would be good for counting multiple partners listed in cf_partner as well.
This is still valid, even after 3.6 update. The links in Comment #3 are interesting, but they're not what i'm after exactly. I'm lookig to be able, from BZ interface (web, xmlrpc) query all bugs which meet various boolean queries (eg, has this flag, in this state...) AND 'issuetrackers' 'countgreaterthan' '3' Or to think of it another way, i need a way to be able to sort (prioritize) bugzillas based on the number of attached ITs (or the current equivalent).
Issue trackers were removed from Bugzilla last year, so closing this issue. Please let me know if you still think it is a problem. -- simon