Defect #63

Query using multi custom_fields values return no results

Added by Amedeo Amedeo about 15 years ago. Updated almost 15 years ago.

Status:ClosedStart date:
Priority:NormalDue date:
Assignee:-% Done:

0%

Category:-
Target version:-
Resolution: Affected version:

Description

Apparently ussing more than one custom field in a query returns no rows.
Probably this depends on the fact the query should have custom_values table aliases each for each field used otherwise
the AND condition will never be satisfy.

Below I have expanded the statement of one broken query:

"1=1 AND issues.project_id=1 AND (custom_values.custom_field_id = 36 AND custom_values.value IN ('3')) AND
(custom_values.custom_field_id = 9 AND custom_values.value IN ('Bangladesh')) AND (issues.status_id IS NOT NULL)"

History

#1 Updated by Jean-Philippe Lang almost 15 years ago

Fix is committed in rev 668.

Thanks.

Also available in: Atom PDF