Hey ...
10x for you reply ... unfortunately this is not a case for me ..
I have canceled the feature which needs this ...
KInd regards
Armando
Erick Erickson wrote:
One thing I've seen suggested is to add the number of values to
a separate field, say topic_count. Then, in your situation above
you could append "AND topic_count=1". This can extend
to work if you wanted any number of matches (and only
that number). For instance,
topic=5 AND topic=10 AND topic=20 AND topic_count=3 would
give you article 4.....
Don't know if this works in your particular situation....
Erick
On Mon, Mar 22, 2010 at 10:32 AM, Armando Ota <armando...@siol.net> wrote:
Hi
I need a little help with query for my problem (if it can be solved)
I have a field in a document called topic
this field contains some values, 0 (for no topic) or 1 (topic 1), 2, 3,
etc ...
It can contain many values like 1, 10, 50, etc (for 1 doc)
So now to the problem:
I would like to get documents that have 0 for topic value and documents
that only have for example 1 for topic value inserted
articles for example:
article 1topics: 1, 5, 10, 20, 24
article 2 topics: 0
article 3 topics: 1
article 4 topic: 5, 10, 20
article 5 topic: 1, 13, 19
So I need search query to return me only article 2 and 3 not other articles
with 1 for topic value
Can that be done ? Any help appreciated
Kind regards
Armando
