Data connection to the attachment database

0

Hi,

the easiest way is to create a MSSQL data database connection and configure the Test and Production tabs.

This would be sufficient if you execute the query only against the attachment database.

In case your query needs information from the content database as well as the attachment database. You would also need a constant with the database. The name of the database would again be defined per environment.

The statement would be something along
select WFD_STPID
from WFElements join {ENV:xyz}.dbo.WFDataAttachmentFIles on WFD_ID = ATT_WFDID
where ...

This won't work with the default connection as the used bps_user account cannot execute a query against another database.

Best regards,
Daniel

It works perfectly, thank you for help!