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

Question

Question

Full Repository Document Report

Laserfiche
Updated March 31, 2021
asked on March 30, 2021

Hi All,

 

A customer of ours has asked the question if it's possible through SQL to get a full report of all documents in the repository. To include:-

 

  • Entry ID
  • Filename
  • Document extension
  • Template name
  • Field 1
  • Field 2
  • Field 3
  • Field 4
  • Creation Date
  • File path

 

Most of these seem possible through the TOC table, but many other values (particularly field values) seem to be spread across multiple tables.

 

Is there an easy way to do this in SQL, or are there any other tools which could help out here other than searching through the client itself?

 

Cheers!

0 0

Answer

SELECTED ANSWER
replied on March 30, 2021

As you've seen, the metadata fields are the challenge here. There isn't a good way to have fields (which are each just a row in a table) added as a column without adding each one to the SELECT statement. But if it's a requirement you could dynamically generate the sql and then execute it. The other thing to watch for is multi-value fields - if the report needs more than a single value per field you'll need to think of how to represent that.

0 0
replied on March 31, 2021

Thanks Brian, I thought as much.

0 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...