It is currently 23 Apr 2024, 09:19




 Page 1 of 1 [ 2 posts ] 
Author Message
 Post subject: filter "already in collection" option in advance search
PostPosted: 06 Aug 2015, 17:36 
Confirmed Padawan
Confirmed Padawan
User avatar

Joined: 16 May 2009, 18:05
Posts: 3586
Location: California, USA
Has thanked: 28 times
Been thanked: 323 times
In example: I want to compile a list of DTS LDs I don't own. It would be nice to have an option in advance search where I can filter the titles I own so my search would return only the DTS LDs outside my collection.
_________________
Coming Soon
Derman Labs
Anything Of Substance
Offline
 Profile  
 
 Post subject: Re: filter "already in collection" option in advance search  Topic is solved
PostPosted: 04 Feb 2016, 11:08 
Site Admin
Site Admin
User avatar

Joined: 07 Aug 2002, 23:37
Posts: 4551
Location: Tokyo
Has thanked: 295 times
Been thanked: 1146 times
substance wrote:
In example: I want to compile a list of DTS LDs I don't own.


I just added the positive where I have to list only titles hitting the collection (ALL MATCHING -AND- IN_COLLECTION):

Your request is a little more complex: ALL MATCHING -MINUS- IN_COLLECTION, that probably requires a nested request (where x in (select ...))

Will require a bit more of time to test.

Julien
_________________
HARDWARE DATABASE
HLD-X0/9 LD-S9 OPPO 105/205 SL-1200G
LDD-1 MSC-4000 R2144 PONTUS II C45 MC257
Online
 Profile  
 
Display posts from previous:  Sort by  
 Page 1 of 1 [ 2 posts ] 


Who is online

Users browsing this forum: No registered users and 8 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to: