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

Question

Question

LF Repository - SQL table details with table schema and dictionary

asked on August 30

Hello Team,

First thing we need details of the database dictionary for the LF repository, which gives an idea about the entire database structure, as we need to create some SQL query (select statement) that directly fired on the LF repository SQL database.

Also, we need information about the different table names for the repository where all the metadata would be saved along with the template. Actually, we are trying to customise the application (report), and we need to directly get data from the sql table of the repository instead of using any LF API or using an LF search query.

Please provide me all the SQL table details along with the relationship so that I can generate a query.

 

We will require some database structure understanding to perform/execute “select” statement query within LF repository database to get some of the information about the template and metadata. We are working on custom reports and for that we need to understand the database structure of the LF repository so that we will execute SQL query get desired output. Yes, we will totally understand support team concerned but we are using on-prime LF, and we will only perform read only queries. ( we needed tables name for template , metadata with single and multi-level along with relationship)

Thanks,
Pratik

0 0

Replies

replied on September 3

We don't provide documentation about the table structure. That said, the tables that store the field values are fairly simple with a consistent naming convention, so they aren't too difficult to figure out. In addition, they are the tables that are most commonly queried by integrators, so there are a lot of questions on this board that might point you in the right direction, such as https://answers.laserfiche.com/questions/201363/SQL-query-on-LF-Server-tables-for-specific-metadata .

1 0
replied on September 3

Are you running Laserfiche on-premises or Laserfiche Cloud? 

If you are running Laserfiche on-prem, then you should have access to the SQL Server hosting the database used by Laserfiche, which would let you then use any SQL-based tool to generate your data dictionary/schema/whatever else you need.

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

Sign in to reply to this post.