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