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

Question

Search for unused templates

Laserfiche Search and Retrieval Answers Site How To Administration

Updated September 10

asked on September 9

How do I search for templates that aren't assigned to any files? I'd like to get a list to review and delete the ones we don't use.

0 0

Replies

replied on September 10

Now that you mention it, I'm not aware of a way to identify "unused" templates from the Admin console and that seems like it would be a useful feature to add for maintenance purposes.

The admin console does have a kind of safety feature to check for entries using a template before it will delete to prevent that, but not sure about a way to actively "find" them.

Normally I wouldn't recommend going directly to the database, but unless there's a way that I'm missing you could get a list with the following query.

SELECT * FROM [propset]
WHERE [pset_id] NOT IN (
  SELECT DISTINCT [pset_id]
  FROM [toc]
  WHERE [pset_id] IS NOT NULL
  )

2 0

You are not allowed to follow up in this post.

Sign in to reply to this post.

Asked September 9
Updated September 10
37 views