Actions
Defect #63
closed
Query using multi custom_fields values return no results
Status:
Closed
Priority:
Normal
Assignee:
-
Category:
-
Target version:
-
Start date:
Due date:
% Done:
0%
Estimated time:
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)"
Updated by
Actions