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

Question

Question

how to configure more than one Database in data source of Laserfiche workflow

asked on February 26, 2020

How to give more than one Database in a data source to use that in a custom query

0 0

Answer

SELECTED ANSWER
replied on February 26, 2020

When using a Custom Query, you can specify the DB in the "FROM" statement.  As long as the DB is on the same server this is not a problem.

 

A more robust way would be to create a View in your source DB that queries into the multiple Databases.  Then from your Workflow, query the View instead of a complex custom query.

4 0

Replies

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

Sign in to reply to this post.