Question

Repository's Database Table

Laserfiche Web Client Workflow

Updated April 3, 2018

asked on April 3, 2018

Good morning,

We were wondering where the data from Repository's metadata is kept. Let's say that I have a template called ABC and there is a folder with that template with values 1, 2 and 3.

How can I find 1, 2 and 3 in the database?

Thank you,

Raul Gonzalez

0 0

Replies

replied on April 3, 2018

Raul,

There are a set of tables, prop* and pset* in the database that define fields and templates, their data and relationships.

The propval table holds the assigned values for fields that are assigned to an entry, that is where you will find your 1,2,3 values. If you were to search that table setting the tocid = to the entry id of a folder or document you will see the values assigned to that entry.

I don't know that I would be updating anything directly in the table, but if you are looking to write some kind of report you will probably need to join a few of the prop, pset and other tables. If you are looking for some kind of report, a custom search from the client would probably be your best bet.

Tread lightly ...

~ Andrew

3 0

replied on April 3, 2018

Thanks Andrew, our goal is to connect a few tables to use them as Lookup Rules instead of using the Forms Database. We won't be writing anything to the tables, just selecting, so it could work. We'll need to run a few tests with the information that you provided first of course.

Thanks again Andrew.

Thank you,

Raul Gonzalez

2 0

You are not allowed to follow up in this post.

Question

Question

Repository's Database Table

Replies

Sign in to reply to this post.