Kinook Software Forums

Go Back   Kinook Software Forums > Ultra Recall > [UR] General Discussion

Reply
 
Thread Tools Rate Thread Display Modes
  #1  
Old 10-10-2007, 12:18 PM
cnewtonne cnewtonne is online now
Registered User
 
Join Date: 07-27-2006
Posts: 436
List duplicate items with same URL?

Is there a way to retrieve items that have same URL? I wanted to clean up duplicate items.

Thank you
Reply With Quote
  #2  
Old 10-10-2007, 03:18 PM
kinook kinook is online now
Administrator
 
Join Date: 03-06-2001
Location: Colorado
Posts: 5,754
Using SQLite

SELECT ItemID, Value FROM ItemAttribute WHERE AttributeID=996 AND UPPER(Value) IN (SELECT UPPER(Value) AS Val FROM ItemAttribute WHERE AttributeID=996 GROUP BY Val HAVING(COUNT(*) > 1)) ORDER BY UPPER(Value);

http://www.kinook.com/Forum/showthre...?threadid=2825
Reply With Quote
  #3  
Old 10-10-2007, 06:14 PM
quant's Avatar
quant quant is online now
Registered User
 
Join Date: 11-30-2006
Posts: 967
Quote:
Originally posted by kinook
Using SQLite

SELECT ItemID, Value FROM ItemAttribute WHERE AttributeID=996 AND UPPER(Value) IN (SELECT UPPER(Value) AS Val FROM ItemAttribute WHERE AttributeID=996 GROUP BY Val HAVING(COUNT(*) > 1)) ORDER BY UPPER(Value);

http://www.kinook.com/Forum/showthre...?threadid=2825
this is second or third user request where UR built in search is simply not enough and you reply directly with sql query. I think it would be great if you add the possibility to create our own queries directly inside UR ... maybe with some simple interface or just a query line ;-)

Thanks!
Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



All times are GMT -5. The time now is 11:30 AM.


Copyright 1999-2019 Kinook Software, Inc.