asked on July 28, 2015
•
Show version history
Does anyone know where the the values of metadata of a document stored in the database? For example, if I have a document with a template that contains fields like status, first_name, last_name, history and I want to write a SQL query to retrieve it. Which table(s) they are stored in? I understand that we can use search functionality like advanced search on the repository but I'm looking for a way to query it directly from the table in the database. Thank you very much.
Update: This is for documents in LF repository that are not submitted by LF form. Just a plain scanned document with metadata assigned to it