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 ?
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
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