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

Question

Where in the database can I find where the path is stored

Laserfiche

Updated January 3, 2014

asked on January 3, 2014

When using the Laserfiche client I can see several columns and I know where in the database it is stored, like:

- Entry ID, to be find in dbo.toc.tocid

- Name, to be find in dbo. toc.name

- Created by, using dbo.toc.creator join to dbo.account_cache.account_sid, stored under dbo.account_cache.account_name

Now, my question is, the Laserfiche column Path. Where in the database can I find the value?

0 0

Answer

APPROVED ANSWER

replied on January 3, 2014

In the toc table, there is a column for parentid. The value in there represents the tocid of the folder the entry resides in. You can determine the full path by recursively getting the parentid values until you reach the root.

1 0

Replies

replied on January 3, 2014

Hi Alexander,

Thanks for the response, I know about the tocid and the parentid, however with a folder in a folder in a folder, it is difficult to get the fullpath (almost the root). I was looking for something like:

"dbo.audit_entry .name" the fullpath is specified. Is that possible, starting from toc?

0 0

replied on January 3, 2014

The Server calculates that one dynamically based on the parentID chain that Alex mentioned.

0 0

You are not allowed to follow up in this post.

Sign in to reply to this post.

Asked January 3, 2014
Updated January 3, 2014
849 views