Report showing duplicate documents

Linda_Froese_(linda.froese@gov.ab.ca_-_(deleted))

Any suggestions on how to create a Livereport that shows documents within a repository that have the same name?

Find more posts tagged with

Comments

André_Dierick

I am also interested in a Livereport which can show me duplicate docuements in the repository (excluding versions)

Tim_Hunter

how are you defining duplicate?

Jessica_Hixon

Was a solution for this ever determined? I'm looking for a report that pulls back duplicated tasks names in a task group.

So far I have came up with

select name
from dtree
where LOWER(name) in
(select LOWER(name) from dtree connect by parentid = prior
dataid start with dataid=%1group by name having count(name) > 1 )
and subtype=205
group by name

but this isn't pulling back anything even though there are multiple tasks created with the same name but have different case.

Thanks in advance for your help!

Lindsay_Davies

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

Hi Jessica,

If you want to find case-insensitive duplicates then you need to group by upper or lower of name in your inner select.

So when you have

task 1

and

TASK 1

with your current query they count once each and are dropped by the having clause.

With group by lower(name) having count(lower(name)) > 1

will give a count of 2 so the name is passed through.

Regards

Lindsay

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: 2011 September 26, Mon 14:18
To: eLink Recipient
Subject: RE duplicate documents

RE duplicate documents

Posted by jessica.r.hixon@lmco.com (Hixon, Jessica) On 2011/09/26 06:09

Was a solution for this ever determined? I'm looking for a report that pulls back duplicated tasks names in a task group. So far I have came up with select name
from dtree
where LOWER(name) in
(select LOWER(name) from dtree connect by parentid = prior
dataid start with dataid=%1group by name having count(name) > 1 )
and subtype=205
group by name
but this isn't pulling back anything even though there are multiple tasks created with the same name but have different case. Thanks in advance for your help!

[To post a comment, use the normal reply function]
Topic:	Report showing duplicate documents
Forum:	Content Server LiveReports Forum
Livelink Server:	knowledge-wlweb01

John W. Simon, Jr.

Here is what I have...

select

lower(name), count( * )
from dtree
where ownerid = XXXXXX
having count(lower(name)) > 1
group by lower( name )