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

Question

Retrieve all Records from SQL table

Search and Retrieval Workflow Laserfiche

Updated July 10

asked on July 10 • Show version history

Hi all,
In WF 12, Does anybody know how to retrieve all records from a table name Supply List location in SQL?
Columns:

Item, description, cost

I would retrieve all record so i can place them in a MS Word 365 file that has cells. I already have my Word file ready with MergeFields.

Thanks In Advance

0 0

Replies

replied on July 10

@Carlos@████████,

Use a Custom Query in Workflow. Use the SQL command:

"Select Item, description, cost from {tablename}".

Don't use a where condition. This select statement will return all rows from {tablename} with those 3 columns.
Then in the workflow, use a For Each Row task to cycle thru each result in the SQL table.

2 0

replied on July 10

Got it, Thanks

0 0

You are not allowed to follow up in this post.

Sign in to reply to this post.

Asked July 10
Updated July 10
249 views