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

Question

Question

Laserfiche reports

asked on November 3, 2019

hellow!

What can I do to create a report that retrieves data from the sql server 

( inventory report) to show how many stock remains and the quantity issued or received in a specific date 

Diana!

0 0

Replies

replied on November 4, 2019 Show version history

Field data is stored in the "propval" table, and field definitions are in "propdef". propval has a foreign key into the "toc" table, which contains information about the entry. If you are familiar with SQL it shouldn't be too hard to combine those tables to get the data you are looking for. It only gets tricky if you have to deal with multi-value fields - the "pos" column indicates the value's position in the list.

0 0
replied on July 29, 2020

Hello Brian

 

Any idea what the pos2 column represent?

 

Thanks,

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

Sign in to reply to this post.