Maximo List Archive

This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.



Inherited attachments

From: sriram s (2013-07-18 23:10)

Hi,
 
I want to stop adding the attached docs of a parent record or a main field associated records.
For example if we take pm record, whatever attachments exist for asset or location field are adding to that pm.
So I want to stop this functionality. If you have any idea on this please suggest me.
Advanced thanks for your help.
 
Thanks & Regards
Sriram


From: Ian Wright (2013-07-19 07:51)

There are two options I prefer the option 2
Option 1
Go to database configuration and get object PO
Click on relationship tab
Filter for the relationship "DOCLINKS"
The current relationship is :-
(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))
If you only want what was attached to the PM then Replace with THIS WILL STOP any attachments ever printing which are on the LOCATIONS , ASSET and MASTERPM objects
(ownertable = 'PM' and ownerid = :pmuid)
Option 2
When documents are attached the default status is to print attached documents i.e. when you select "Add new file" in the "advanced Options" section there is an option.
Print attached document with report if printable type?
It is set to true if you set this to false by default then a conscious decision needs to be made to actually want to print the document
You do this by going to the "system properties" find
mxe.doclink.defaultPrintDocWithReport set to false and live refresh
Rgds Ian
Ian.wright@bpdzenith.com
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of sriram s
Sent: 18 July 2013 16:11
To: maxim maximo
Subject: [MAXIMO List] Inherited attachments
Hi,
I want to stop adding the attached docs of a parent record or a main field associated records.
For example if we take pm record, whatever attachments exist for asset or location field are adding to that pm.
So I want to stop this functionality. If you have any idea on this please suggest me.
Advanced thanks for your help.
Thanks & Regards
Sriram
GDF SUEZ E&P UK Ltd (Company Number 3386464), registered in England and Wales with a registered office address at: 40 Holborn Viaduct, London, EC1N 2PB.
**************************************************************************************************************
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the system manager.
**************************************************************************************************************


From: sriram s (2013-07-19 19:46)

Hi Ian,
Thank you so much, the first option is working fine, but second option is not working..
Regards
Sriram
________________________________
From: Ian Wright <ian.wright@gdfsuezep.co.uk>
To: "MAXIMO@yahoogroups.com" <MAXIMO@yahoogroups.com>
Sent: Friday, 19 July 2013 11:51 AM
Subject: RE: [MAXIMO List] Inherited attachments

 
There are two options I prefer the option 2
Option 1
Go to database configuration and get object PO
Click on relationship tab
Filter for the relationship "DOCLINKS"
The current relationship is :-
(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))
If you only want what was attached to the PM then Replace with THIS WILL STOP any attachments ever printing which are on the LOCATIONS , ASSET and MASTERPM objects
(ownertable = 'PM' and ownerid = :pmuid)
Option 2
When documents are attached the default status is to print attached documents i.e. when you select "Add new file" in the "advanced Options" section there is an option.
Print attached document with report if printable type?
It is set to true if you set this to false by default then a conscious decision needs to be made to actually want to print the document
You do this by going to the "system properties" find
mxe.doclink.defaultPrintDocWithReport set to false and live refresh
Rgds Ian
Ian.wright@bpdzenith.com
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of sriram s
Sent: 18 July 2013 16:11
To: maxim maximo
Subject: [MAXIMO List] Inherited attachments
Hi,
I want to stop adding the attached docs of a parent record or a main field associated records.
For example if we take pm record, whatever attachments exist for asset or location field are adding to that pm.
So I want to stop this functionality. If you have any idea on this please suggest me.
Advanced thanks for your help.
Thanks & Regards
Sriram
GDF SUEZ E&P UK Ltd (Company Number 3386464), registered in England and Wales with a registered office address at: 40 Holborn Viaduct, London, EC1N 2PB.
**************************************************************************************************************
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the system manager.
**************************************************************************************************************


From: Ian Wright (2013-07-22 07:50)

Did you live refresh ?
The 2nd option will only work for new attachments
Old attachments must be manually de-selected from the view attachments dialog or you could use :-

Be careful with this as it will turn off all printing

Update DOCLINKS set PRINTTHRULINK=0 where ownertable in ('LOCATIONS','ASSET','MASTERPM')

From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of sriram s
Sent: 19 July 2013 12:47
To: MAXIMO@yahoogroups.com
Subject: Re: [MAXIMO List] Inherited attachments



Hi Ian,

Thank you so much, the first option is working fine, but second option is not working..

Regards
Sriram

________________________________
From: Ian Wright <ian.wright@gdfsuezep.co.uk<mailto:ian.wright%40gdfsuezep.co.uk>>
To: "MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com>" <MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com>>
Sent: Friday, 19 July 2013 11:51 AM
Subject: RE: [MAXIMO List] Inherited attachments



There are two options I prefer the option 2

Option 1

Go to database configuration and get object PO
Click on relationship tab
Filter for the relationship "DOCLINKS"

The current relationship is :-

(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))

If you only want what was attached to the PM then Replace with THIS WILL STOP any attachments ever printing which are on the LOCATIONS , ASSET and MASTERPM objects

(ownertable = 'PM' and ownerid = :pmuid)

Option 2

When documents are attached the default status is to print attached documents i.e. when you select "Add new file" in the "advanced Options" section there is an option.
Print attached document with report if printable type?
It is set to true if you set this to false by default then a conscious decision needs to be made to actually want to print the document
You do this by going to the "system properties" find
mxe.doclink.defaultPrintDocWithReport set to false and live refresh

Rgds Ian
Ian.wright@bpdzenith.com<mailto:Ian.wright%40bpdzenith.com>

From: MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com> [mailto:MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com>] On Behalf Of sriram s
Sent: 18 July 2013 16:11
To: maxim maximo
Subject: [MAXIMO List] Inherited attachments

Hi,

I want to stop adding the attached docs of a parent record or a main field associated records.
For example if we take pm record, whatever attachments exist for asset or location field are adding to that pm.
So I want to stop this functionality. If you have any idea on this please suggest me.
Advanced thanks for your help.

Thanks & Regards
Sriram



GDF SUEZ E&P UK Ltd (Company Number 3386464), registered in England and Wales with a registered office address at: 40 Holborn Viaduct, London, EC1N 2PB.

**************************************************************************************************************
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the system manager.
**************************************************************************************************************






From: sriram s (2013-07-24 18:11)

Hi Ian,
 
Done but still the inherited attachments are not coming to main record.
 
Thank you for the help
Regards
Sriram S

________________________________
From: Ian Wright <ian.wright@gdfsuezep.co.uk>
To: "MAXIMO@yahoogroups.com" <MAXIMO@yahoogroups.com>
Sent: Monday, 22 July 2013 11:50 AM
Subject: RE: [MAXIMO List] Inherited attachments

 

Did you live refresh ?
The 2nd option will only work for new attachments
Old attachments must be manually de-selected from the view attachments dialog or you could use :-
Be careful with this as it will turn off all printing
Update DOCLINKS set PRINTTHRULINK=0 where ownertable in ('LOCATIONS','ASSET','MASTERPM')
From: mailto:MAXIMO%40yahoogroups.com [mailto:mailto:MAXIMO%40yahoogroups.com] On Behalf Of sriram s
Sent: 19 July 2013 12:47
To: mailto:MAXIMO%40yahoogroups.com
Subject: Re: [MAXIMO List] Inherited attachments
Hi Ian,
Thank you so much, the first option is working fine, but second option is not working..
Regards
Sriram
________________________________
From: Ian Wright <mailto:ian.wright%40gdfsuezep.co.uk<mailto:ian.wright%40gdfsuezep.co.uk>>
To: "mailto:MAXIMO%40yahoogroups.com<mailto:MAXIMO%40yahoogroups.com>" <mailto:MAXIMO%40yahoogroups.com<mailto:MAXIMO%40yahoogroups.com>>
Sent: Friday, 19 July 2013 11:51 AM
Subject: RE: [MAXIMO List] Inherited attachments
There are two options I prefer the option 2
Option 1
Go to database configuration and get object PO
Click on relationship tab
Filter for the relationship "DOCLINKS"
The current relationship is :-
(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))
If you only want what was attached to the PM then Replace with THIS WILL STOP any attachments ever printing which are on the LOCATIONS , ASSET and MASTERPM objects
(ownertable = 'PM' and ownerid = :pmuid)
Option 2
When documents are attached the default status is to print attached documents i.e. when you select "Add new file" in the "advanced Options" section there is an option.
Print attached document with report if printable type?
It is set to true if you set this to false by default then a conscious decision needs to be made to actually want to print the document
You do this by going to the "system properties" find
mxe.doclink.defaultPrintDocWithReport set to false and live refresh
Rgds Ian
mailto:Ian.wright%40bpdzenith.com<mailto:Ian.wright%40bpdzenith.com>
From: mailto:MAXIMO%40yahoogroups.com<mailto:MAXIMO%40yahoogroups.com> [mailto:mailto:MAXIMO%40yahoogroups.com<mailto:MAXIMO%40yahoogroups.com>] On Behalf Of sriram s
Sent: 18 July 2013 16:11
To: maxim maximo
Subject: [MAXIMO List] Inherited attachments
Hi,
I want to stop adding the attached docs of a parent record or a main field associated records.
For example if we take pm record, whatever attachments exist for asset or location field are adding to that pm.
So I want to stop this functionality. If you have any idea on this please suggest me.
Advanced thanks for your help.
Thanks & Regards
Sriram
GDF SUEZ E&P UK Ltd (Company Number 3386464), registered in England and Wales with a registered office address at: 40 Holborn Viaduct, London, EC1N 2PB.
**************************************************************************************************************
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the system manager.
**************************************************************************************************************




From: Ian Wright (2013-07-24 10:28)

Sorry I thought you just wanted to stop them printing

However you could try this join which would only show ones that were flagged for printing

(ownertable = 'PM'
and ownerid = :pmuid) or (ownertable='LOCATIONS' and PRINTTHRULINK=1 and
ownerid in (select locationsid from locations where location=:location and siteid=:siteid)) or
(ownertable='ASSET' and PRINTTHRULINK=1 and ownerid in (select assetuid from asset where assetnum=:assetnum and siteid=:siteid)) or
(ownertable='MASTERPM' and PRINTTHRULINK=1 and ownerid in (select masterpmid from masterpm where masterpmnum=:masterpm))

From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of sriram s
Sent: 24 July 2013 11:11
To: MAXIMO@yahoogroups.com
Subject: Re: [MAXIMO List] Inherited attachments



Hi Ian,

Done but still the inherited attachments are not coming to main record.

Thank you for the help
Regards
Sriram S


________________________________
From: Ian Wright <ian.wright@gdfsuezep.co.uk<mailto:ian.wright%40gdfsuezep.co.uk>>
To: "MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com>" <MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com>>
Sent: Monday, 22 July 2013 11:50 AM
Subject: RE: [MAXIMO List] Inherited attachments



Did you live refresh ?
The 2nd option will only work for new attachments
Old attachments must be manually de-selected from the view attachments dialog or you could use :-

Be careful with this as it will turn off all printing

Update DOCLINKS set PRINTTHRULINK=0 where ownertable in ('LOCATIONS','ASSET','MASTERPM')

From: mailto:MAXIMO%40yahoogroups.com [mailto:mailto:MAXIMO%40yahoogroups.com] On Behalf Of sriram s
Sent: 19 July 2013 12:47
To: mailto:MAXIMO%40yahoogroups.com
Subject: Re: [MAXIMO List] Inherited attachments

Hi Ian,

Thank you so much, the first option is working fine, but second option is not working..

Regards
Sriram

________________________________
From: Ian Wright <mailto:ian.wright%40gdfsuezep.co.uk<mailto:ian.wright%40gdfsuezep.co.uk<mailto:ian.wright%40gdfsuezep.co.uk%3cmailto:ian.wright%40gdfsuezep.co.uk>>>
To: "mailto:MAXIMO%40yahoogroups.com<mailto:MAXIMO%40yahoogroups.com><mailto:MAXIMO%40yahoogroups.com%3cmailto:MAXIMO%40yahoogroups.com%3e>" <mailto:MAXIMO%40yahoogroups.com<mailto:MAXIMO%40yahoogroups.com<mailto:MAXIMO%40yahoogroups.com%3cmailto:MAXIMO%40yahoogroups.com>>>
Sent: Friday, 19 July 2013 11:51 AM
Subject: RE: [MAXIMO List] Inherited attachments

There are two options I prefer the option 2

Option 1

Go to database configuration and get object PO
Click on relationship tab
Filter for the relationship "DOCLINKS"

The current relationship is :-

(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))

If you only want what was attached to the PM then Replace with THIS WILL STOP any attachments ever printing which are on the LOCATIONS , ASSET and MASTERPM objects

(ownertable = 'PM' and ownerid = :pmuid)

Option 2

When documents are attached the default status is to print attached documents i.e. when you select "Add new file" in the "advanced Options" section there is an option.
Print attached document with report if printable type?
It is set to true if you set this to false by default then a conscious decision needs to be made to actually want to print the document
You do this by going to the "system properties" find
mxe.doclink.defaultPrintDocWithReport set to false and live refresh

Rgds Ian
mailto:Ian.wright%40bpdzenith.com<mailto:Ian.wright%40bpdzenith.com<mailto:Ian.wright%40bpdzenith.com%3cmailto:Ian.wright%40bpdzenith.com>>

From: mailto:MAXIMO%40yahoogroups.com<mailto:MAXIMO%40yahoogroups.com<mailto:MAXIMO%40yahoogroups.com%3cmailto:MAXIMO%40yahoogroups.com>> [mailto:mailto:MAXIMO%40yahoogroups.com<mailto:MAXIMO%40yahoogroups.com>] On Behalf Of sriram s
Sent: 18 July 2013 16:11
To: maxim maximo
Subject: [MAXIMO List] Inherited attachments

Hi,

I want to stop adding the attached docs of a parent record or a main field associated records.
For example if we take pm record, whatever attachments exist for asset or location field are adding to that pm.
So I want to stop this functionality. If you have any idea on this please suggest me.
Advanced thanks for your help.

Thanks & Regards
Sriram



GDF SUEZ E&P UK Ltd (Company Number 3386464), registered in England and Wales with a registered office address at: 40 Holborn Viaduct, London, EC1N 2PB.

**************************************************************************************************************
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the system manager.
**************************************************************************************************************