couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ilya Novojilov <novojilov.i...@gmail.com>
Subject Re: getting related documents
Date Sun, 21 Aug 2011 10:03:41 GMT
It seems very close, will give it a try.

This was done in SQL + php with 3 requests:

select * from tags where tagid in (1,2,3);
if (no rows)
select * from tags where tagid in (1,2);
if (no rows)
select * from tags where tagid in (1);
if (no rows)
return default set


2011/8/21 Marcello Nuccio <marcello.nuccio@gmail.com>:
> I'm not sure to understand your question. Can you be more specific?
> Is the following useful?
> http://stackoverflow.com/questions/5227587/how-to-match-a-superset-key-to-a-subset-using-group-level-sub-selects-in-couchdb/5256801#5256801
>
> Marcello
>
> 2011/8/21 Ilya Novojilov <novojilov.ilya@gmail.com>:
>> He||o all
>> I understand it's a very common request, but I couldn't find a solution.
>> Say documents are:
>>
>> {
>>  title:"doc 1",
>>  body:"body",
>>  tags:["tag1","tag2","tag3"]
>> }
>>
>> another thing is that Tags have importance value.
>> So I want to get documents that have tag1,tag2 adn tag3
>> If there is no such docs - return those with tag1 and tag2
>> etc.
>>
>

Mime
View raw message