Displaying Job Plan attachments in PM

Resolving The Problem

Go to – System Configuration – Platform Configuration – Database Configuration
Select PM object
Click on Relationship Tab
Filter doclinks
Add the below SQL statement to DOCKLINKS relationship Where Clause

or (ownertable='JOBPLAN' and ownerid in (select jobplanid from jobplan where jpnum=:jpnum and (siteid is null or siteid=:siteid) and status in (select value from synonymdomain where domainid='JOBPLANSTATUS' and maxvalue ='ACTIVE') ))

So it will be :

(ownertable = 'PM' and ownerid = :pmuid) or (ownertable='LOCATIONS' and ownerid in (select locationsid from locations where location=:location and siteid=:siteid)) or (ownertable='ASSET' and ownerid in (select assetuid from asset where assetnum=:assetnum and siteid=:siteid)) or (ownertable='MASTERPM' and ownerid in (select masterpmid from masterpm where masterpmnum=:masterpm)) or (ownertable='JOBPLAN' and ownerid in (select jobplanid from jobplan where jpnum=:jpnum and (siteid is null or siteid=:siteid) and status in (select value from synonymdomain where domainid='JOBPLANSTATUS' and maxvalue ='ACTIVE') ))

Save changes