Project

General

Profile

Actions
Copy link

Bug #4509

closed

Filtering by columns that require joins does not function

Added by krileon over 10 years ago. Updated about 10 years ago.

Status:
Closed
Priority:
Normal
Assignee:
beat
Target version:
CB 2.0.0
Start date:
28 May 2014
Due date:
% Done:

100%

Estimated time:
4:00 h

Description

When filtering by a column that requires a JOIN and is present in the query it always uses the "a." table as instead of doing proper lookup. To test add the below filter to CB > User Management then filter by Enabled/Disabled.

<filter name="block" value="block" valuetype="sql:int" type="xml:user_block" label="" blanktext="- Select Enabled -" />

This functionality is traced as follows.

TableBrowser > _prepareXmlSqlQuery > process_filter

Actions
Copy link
 #1

Updated by beat over 10 years ago

  • Estimated time set to 4:00 h
Actions
Copy link
 #2

Updated by beat over 10 years ago

  • Status changed from Assigned to Resolved
  • % Done changed from 0 to 100

Bug introduced in CB 2.0 solved with MR !253 and usage for block user added in MR !256 .

Thus we can mark this one as resolved.

Actions
Copy link
 #3

Updated by beat about 10 years ago

  • Status changed from Resolved to Closed
Actions
Copy link

Also available in: Atom PDF