View Issue Details

IDProjectCategoryView StatusLast Update
0024600mantisbtfilterspublic2018-07-10 16:30
ReporterfmanAssigned To 
PrioritynormalSeverityminorReproducibilityalways
Status newResolutionopen 
Product Version2.14.0 
Target VersionFixed in Version 
Summary0024600: BugFilterQuery - issue? - trying to add join & where conditions
Description

I need to do a customization on the query used to extract rows for the bug listing (view feature).

Because I was not able (my fault) to understand where the query is build and setted, the best solution I've found was to do changes on function filter_get_bug_rows()

I've tried to use $t_filter_query->add_join() and $t_filter_query->add_where() after :

build a filter query, here for counting results

$t_filter_query = new BugFilterQuery(
        $t_filter,
        array(
            'query_type' => BugFilterQuery::QUERY_TYPE_LIST,
            'project_id' => $p_project_id,
            'user_id' => $p_user_id,
            'use_sticky' => $p_show_sticky
            )
        ); 

Everything OK retrieving COUNT, but when doing $t_rows = $t_filter_query->fetch_all() it seems that the pieces I've added via ->add_join(); and ->add_where() were ignored.

Do you have any tip/hint/pointer to some documentation?
Right now IMHO it seems a bug

best regards

TagsNo tags attached.

Activities

cproensa

cproensa

2018-07-10 16:16

developer   ~0060237

try:
$t_filter_query->set_query_type( BugFilterQuery::QUERY_TYPE_LIST )
after adding your "join" and "where" parts, to rebuild the inner sql

if it works, probably we could give it a thought to be smarter and rebuild the internal query, automatically, at some point after adding external parts and before the actual execute

cproensa

cproensa

2018-07-10 16:20

developer   ~0060238

Because I was not able (my fault) to understand where the query is build and setted

if you follow the BugFilterQuery class, it's build_main() method where all the filter properties are evaluated and added one by one

fman

fman

2018-07-10 16:30

reporter   ~0060239

Thanks a lot for your fast answer.
I'm going to try what is explained on note 60237 and provide feedback

Issue History

Date Modified Username Field Change
2018-07-10 06:20 fman New Issue
2018-07-10 16:16 cproensa Note Added: 0060237
2018-07-10 16:20 cproensa Note Added: 0060238
2018-07-10 16:30 fman Note Added: 0060239