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

Question

Question

Retrieving values from an index list item

asked on October 11 Show version history

I'm working on a Form that would allow our Legal team to add bulk holds to records. This would be mostly based on the type of document needing the hold within a certain account number range. 

The issue I'm having is returning a list of available document types. The document types are an index list value on each template. The attached screenshots show my Forms query to pull back all available templates. I then need to allow them to select the document type from that template they wish to apply the hold to. I was hoping to find this in the LF database somewhere but am coming up empty. 

I'd like to do this part with just a Forms direct query, but can use Workflow if that's the only way. 
 

AllTemplates.PNG
FormsDB_Lookup.PNG
AllDocTypes.PNG
AllTemplates.PNG (33.69 KB)
AllDocTypes.PNG (11.23 KB)
0 0

Replies

replied on October 11

John,

I would suspect that Laserfiche would discourage you from accessing the underlying SQL tables directly but if you decide to pursue that option the metadata template names are stored in the dbo.propset table.

replied on October 14

Does your post in this other thread refer to this question?

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

Sign in to reply to this post.