[FX.php List] AND plus OR search

[Tim 'Webko' Booth]

On 09/12/2009, at 7:04 AM, Anders Monsen wrote:

> I think my mysql background is clouding my FX attempts...
>
> Is it possible to search for something where the conditions are as  
> follows:
>
> where field A contains value 'X'
> 	and
>
> field B contains value 'Y'
> 	or
> field C contains value 'X'
>
> I believe a pure OR search would find across A or B or C having the  
> values, but I want to have field A and then one of the other two  
> fields.

I have had trouble with compound searches - here may well be a better  
technique, but I end up creating calc fields for the OR clauses -  
B_C_calc = fieldB & " " & fieldC

Now search on fieldA and B_C_calc

I don't like this answer all that much, but it works

Webko