search

ox-it / ords

Automatically exported from code.google.com/p/ords
0 stars 0 forks source link

Combined filters including linked fields produce no results #701

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1. View a table which includes one or more linked fields
2. Apply a combined filter to this table, where one of the filter criteria is 
on a linked field (use the method that involves selecting the table, then the 
field, then adding filter criteria)
3. Wonder why you aren't getting any results

What is the expected output? What do you see instead?
Combined filters including linked fields seem to give no results, even when 
they should. Attached are some illustrative screenshots: a filter applied to a 
non-linked field (showing results), a filter applied to a linked field (showing 
results), and then a combination of the two (showing no results, even though 
there's an overlap between the results of the two previous filters).

(Priority set as critical after discussion with James - as this means the ORDS 
is sometimes giving researchers the wrong results.)

Please use labels and text to provide additional information.

Original issue reported on code.google.com by meriel.p...@gmail.com on 3 Aug 2015 at 10:40

Attachments:

GoogleCodeExporter commented 9 years ago 
This bug affects any query involving two or more filter clauses using CONTAINS 
rather than having anything to do with relations.

This was caused by the filter processor only putting "%" symbols around the 
first parameter used with a CONTAINS clause . Now fixed!

Original comment by scott.br...@gmail.com on 3 Aug 2015 at 11:26

GoogleCodeExporter commented 9 years ago 
Ah - I see. Impressively fast fixing!

Original comment by meriel.p...@gmail.com on 3 Aug 2015 at 11:50