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

documentid=XXXXX))

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

Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s