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

Question

Question

What tables are the metadata stored in within the Laserfiche SQL database

Updated October 11, 2024
asked on April 7, 2014

I  have been asked to locate the metadata within the Laserfiche SQL database tables.

 

The reason:

 

The company has an ERP system that has a SQL backend.  One of the items that is stored is an OrderNumber.  The company is scanning in BOL's that have an OrderNumber on them.

 

We are using Quickfields to pull the OrderNumber off the BOL and then store them in Laserfiche.

 

They are wanting to write a SQL report that will compare the orders that are in the ERP system with the orders that have been scanned into Laserfiche.

 

In order to complete this report, I need to know where the "OrderNumber" that was scanned into Laserfiche is stored.  What Table within the Laserfiche database?

 

I hope that makes sense.

 

Thank you.

 

John

 

1 0

Answer

SELECTED ANSWER
replied on April 7, 2014

The field definitions are in the propdef table, the data is in propval.

3 0
View 2 previous replies
replied on April 7, 2014

Thank you Miruna, this answered my question.

0 0
replied on July 9, 2014

Is the propdef Table located in the same Database as the Forms Database? I cannot seem to find either the propdef table location in our Forms SQL Database. I can find the CF_Forms and CF_Fields tables, but I need to find the data entered in by users on forms that have been submitted.

 

Thank You!

0 0
replied on July 9, 2014

I realized the propdef Table is located in the Laserfiche Database. However, I am looking at the Forms database and not sure where the find where data entry on submitted forms is saved in the Forms Database. Where can I find this information?

 

Thanks

0 0
replied on July 9, 2014

The values are stored in the cf_bp_data table.

2 0
replied on July 10, 2014

Found the values. Thank you!

1 0
replied on September 15, 2015

I can see data for some of the fields in propval table but I can't find data for some of the fields.

I have around 15-20 fields in a table and I can't find data for some of the fields in propval table.

Any idea where can I find that data?

Replies

replied on October 11, 2024

Update. I believe I have found these in the dbo.lup table. 

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

Sign in to reply to this post.

Details
Related Posts
Loading ...