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

Question

Question

Can document metadata be read directly from the Laserfiche RDBMS tables or is it stored on the volumes?

asked on August 26, 2019

Does anyone know if the metadata for documents in Laserfiche is stored on the file systems(volumes) with the content, or is it stored (and readable) in the supporting Laserfiche DBMS ?

0 0

Answer

SELECTED ANSWER
replied on August 26, 2019

Hi Tim

The Metadata fields are stored in the Repository Database and are readible but not easily as the information to get to it is distributed across multiple tables and needs to be pulled together to be meaningful. I typically create a View in my Repository DB where I can I pull this information together.

SELECT        dbo.propdef.prop_id, dbo.propval.tocid, dbo.propval.str_val, dbo.propdef.prop_name
FROM            dbo.propdef INNER JOIN
                         dbo.propval ON dbo.propdef.prop_id = dbo.propval.prop_id

The View looks like this

prop_id = the Metadata Field unique ID

tocid = The entry ID of the document

prop_Name is the Metadata Field Name

str_val = the value of the Metadata Field

 

 

1 0
replied on August 26, 2019

Thank you Steve Knowlton...this was just what I was looking for !

0 0

Replies

replied on August 26, 2019

Metadata is stored in the database.

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

Sign in to reply to this post.