View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0024600 | mantisbt | filters | public | 2018-07-10 06:20 | 2020-03-15 15:23 |
Reporter | fman | Assigned To | cproensa | ||
Priority | normal | Severity | minor | Reproducibility | always |
Status | closed | Resolution | fixed | ||
Product Version | 2.14.0 | ||||
Target Version | 2.24.0 | Fixed in Version | 2.24.0 | ||
Summary | 0024600: 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 :
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? best regards | ||||
Tags | No tags attached. | ||||
try: 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 |
|
if you follow the BugFilterQuery class, it's build_main() method where all the filter properties are evaluated and added one by one |
|
Thanks a lot for your fast answer. |
|
@fman and report if that fixes it? |
|
MantisBT: master ec75a98d 2020-01-19 06:49 Committer: dregad Details Diff |
BugFilterQuery check for later modifications The internal sql query is built and ready after the constructor method, and regenerated after changing query type with set_query_type(). However, if externally adding clauses throguh add_join(), add_where(), etc, those new parts are not translated to the final query automatically. Add a flag that keeps track of the modified state, so if the query is executed after modifications, the internal sql is rebuilt. Fixes: 0024600 |
Affected Issues 0024600 |
|
mod - core/classes/BugFilterQuery.class.php | Diff File |