How to find path and file name of a specific document in Velocity

Posted on Updated on

This is a procedure for finding a specific document path from Fiserv Velocity application:

use prod_docs

select * from prod_docs.dbo.imageallocation

where (AllocationID in

(Select DocumentKey from prod_app.dbo.documents where


or use an inner join

select a.allocationid, a.folderid, a.imagepath, b.documentid

from prod_docs.dbo.imageallocation a

inner join prod_app.dbo.documents b

on a.allocationid = b.documentkey

where b.documentid=XXXXX


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s