You are viewing limited content. For full access, please sign in.

Question

How to search for duplicate folder names

Laserfiche Version 8 Search and Retrieval

Updated January 30, 2014

asked on January 29, 2014

I have a customer that has duplicate folder names at various levels in the repository. The folders do not have (2) at the end and at point do not have workflow. Is there a search I can perform that would return all folders with the exact name?

0 0

Answer

APPROVED ANSWER

replied on January 30, 2014

If you have the option of running an SQL query, this would be a quick way to get a list of all folder names that are in the repository more than once along with a count of how many times. From there you could use the results to do the Folder Name search in the Laserfiche Client that Blake mentioned.

select name, count(*)
  from toc
  where etype = 0
  group by name
  having count(*) > 1

1 0

Replies

replied on January 29, 2014

Do you know the folder name? You should be able to just perform a Document/Folder Name search for that Folder name with no other criteria.

0 0

replied on January 29, 2014

I do not know the folder names

0 0

You are not allowed to follow up in this post.

Sign in to reply to this post.

Asked January 29, 2014
Updated January 30, 2014
670 views