Question

Folders in the database

Laserfiche Administration

Updated March 11, 2015

asked on March 10, 2015

We have a customer who has been using Laserfiche for a while now. The customer has SQL system analysts who mostly work from SQL.

I have been prompted by a question from the customer who would like to know:

Where or how will he be able to view the Laserfiche Client folder structure from SQL? The customer requires the “folder” view so that he will be able to generate reports from SQL.

Is this possible at all?

0 0

Replies

replied on March 10, 2015

First, the requisite warning: reading information from the database is fine, but we strongly recommend that you don't make changes. Things may break if you do!

Ok--with that out of the way, the table you want is the toc table. The toc table contains a lot of important information about the entries in the repository, but the columns you’ll need are the tocid and the parentid columns. Each entry in the repository has its own row; tocid is the entry id for that entry, and parentid is the entry id for the folder that contains it. Please keep in mind that we change our database schema from time to time, so when you upgrade the system, your reports may break.

1 0

replied on March 11, 2015

Thank you Zackhary, this was very helpful. I did warn the analyst to not change the DB and only view.

0 0

You are not allowed to follow up in this post.

Question

Question

Folders in the database

Replies

Sign in to reply to this post.