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.
Hi everyone,
I need your help to show description of work order on dialog box 'manage downtime history' Asset, I've been trying with method 'where clause' in tab relationship 'MODDOWNTIMEHIST' with 'WORKORDER' but won't open.
FYI :
Relationship : STARTWONUMDESC
Child Object : WORKORDER
Where Clause : assetnum=:asset.assetnum and value=:startwonum
Help me for solve this puzzle, tell me if I am wrong or have another opinion for a solution. Thank you everyone :)
Your relationship should be
wonum = :wonum and siteid = :siteid
and your field on the dialog
STARTWONUMDESC.DESCRIPTION
Rgds Ian
BPD Zenith Ltd
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of forz4ever@yahoo.com
Sent: 03 February 2014 09:20
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] Need Help Show Description of Work Order on Manage Downtime History Asset
Hi everyone,
I need your help to show description of work order on dialog box 'manage downtime history' Asset, I've been trying with method 'where clause' in tab relationship 'MODDOWNTIMEHIST' with 'WORKORDER' but won't open.
FYI :
Relationship : STARTWONUMDESC
Child Object : WORKORDER
Where Clause : assetnum=:asset.assetnum and value=:startwonum
Help me for solve this puzzle, tell me if I am wrong or have another opinion for a solution. Thank you everyone :)
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.
**************************************************************************************************************
Sorry typo
wonum = :startwonum and siteid = :siteid
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Ian Wright
Sent: 03 February 2014 10:03
To: MAXIMO@yahoogroups.com
Subject: RE: [MAXIMO List] Need Help Show Description of Work Order on Manage Downtime History Asset
Your relationship should be
wonum = :wonum and siteid = :siteid
and your field on the dialog
STARTWONUMDESC.DESCRIPTION
Rgds Ian
BPD Zenith Ltd
From: MAXIMO@yahoogroups.com<mailto:MAXIMO@yahoogroups.com> [mailto:MAXIMO@yahoogroups.com] On Behalf Of forz4ever@yahoo.com<mailto:forz4ever@yahoo.com>
Sent: 03 February 2014 09:20
To: MAXIMO@yahoogroups.com<mailto:MAXIMO@yahoogroups.com>
Subject: [MAXIMO List] Need Help Show Description of Work Order on Manage Downtime History Asset
Hi everyone,
I need your help to show description of work order on dialog box 'manage downtime history' Asset, I've been trying with method 'where clause' in tab relationship 'MODDOWNTIMEHIST' with 'WORKORDER' but won't open.
FYI :
Relationship : STARTWONUMDESC
Child Object : WORKORDER
Where Clause : assetnum=:asset.assetnum and value=:startwonum
Help me for solve this puzzle, tell me if I am wrong or have another opinion for a solution. Thank you everyone :)
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.
****************************************************************************************************************************************************************************************
Thank you Ian, It works!
Sent from my iPhone
> On 3 Feb 2014, at 17.05, Ian Wright <ian.wright@gdfsuezep.co.uk> wrote:
>
> Sorry typo
>
>
>
> wonum = :startwonum and siteid = :siteid
>
>
>
>
>
> From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Ian Wright
> Sent: 03 February 2014 10:03
> To: MAXIMO@yahoogroups.com
> Subject: RE: [MAXIMO List] Need Help Show Description of Work Order on Manage Downtime History Asset
>
>
>
>
>
> Your relationship should be
>
>
>
> wonum = :wonum and siteid = :siteid
>
>
>
> and your field on the dialog
>
>
>
> STARTWONUMDESC.DESCRIPTION
>
>
>
> Rgds Ian
>
> BPD Zenith Ltd
>
>
>
> From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of forz4ever@yahoo.com
> Sent: 03 February 2014 09:20
> To: MAXIMO@yahoogroups.com
> Subject: [MAXIMO List] Need Help Show Description of Work Order on Manage Downtime History Asset
>
>
>
>
>
> Hi everyone,
>
> I need your help to show description of work order on dialog box 'manage downtime history' Asset, I've been trying with method 'where clause' in tab relationship 'MODDOWNTIMEHIST' with 'WORKORDER' but won't open.
>
> FYI :
> Relationship : STARTWONUMDESC
> Child Object : WORKORDER
> Where Clause : assetnum=:asset.assetnum and value=:startwonum
>
> Help me for solve this puzzle, tell me if I am wrong or have another opinion for a solution. Thank you everyone :)
>
> 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.
> ****************************************************************************************************************************************************************************************
>
>
>
I know I tested it ☺
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Lutfi Ramadhan
Sent: 03 February 2014 10:10
To: MAXIMO@yahoogroups.com
Subject: Re: [MAXIMO List] Need Help Show Description of Work Order on Manage Downtime History Asset
Thank you Ian, It works!
Sent from my iPhone
On 3 Feb 2014, at 17.05, Ian Wright <ian.wright@gdfsuezep.co.uk<mailto:ian.wright@gdfsuezep.co.uk>> wrote:
Sorry typo
wonum = :startwonum and siteid = :siteid
From: MAXIMO@yahoogroups.com<mailto:MAXIMO@yahoogroups.com> [mailto:MAXIMO@yahoogroups.com] On Behalf Of Ian Wright
Sent: 03 February 2014 10:03
To: MAXIMO@yahoogroups.com<mailto:MAXIMO@yahoogroups.com>
Subject: RE: [MAXIMO List] Need Help Show Description of Work Order on Manage Downtime History Asset
Your relationship should be
wonum = :wonum and siteid = :siteid
and your field on the dialog
STARTWONUMDESC.DESCRIPTION
Rgds Ian
BPD Zenith Ltd
From: MAXIMO@yahoogroups.com<mailto:MAXIMO@yahoogroups.com> [mailto:MAXIMO@yahoogroups.com] On Behalf Of forz4ever@yahoo.com<mailto:forz4ever@yahoo.com>
Sent: 03 February 2014 09:20
To: MAXIMO@yahoogroups.com<mailto:MAXIMO@yahoogroups.com>
Subject: [MAXIMO List] Need Help Show Description of Work Order on Manage Downtime History Asset
Hi everyone,
I need your help to show description of work order on dialog box 'manage downtime history' Asset, I've been trying with method 'where clause' in tab relationship 'MODDOWNTIMEHIST' with 'WORKORDER' but won't open.
FYI :
Relationship : STARTWONUMDESC
Child Object : WORKORDER
Where Clause : assetnum=:asset.assetnum and value=:startwonum
Help me for solve this puzzle, tell me if I am wrong or have another opinion for a solution. Thank you everyone :)
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.
****************************************************************************************************************************************************************************************
I want to show 'downtime' from 'MODDOWNTIMEHIST' in list Work Order Tracking, how can I showing downtime from 'Manage Downtime History' in list Work Order Tracking?
Sent from my iPhone
> On 3 Feb 2014, at 17.26, Ian Wright <ian.wright@gdfsuezep.co.uk> wrote:
>
> I know I tested it J
>
>
>
> From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Lutfi Ramadhan
> Sent: 03 February 2014 10:10
> To: MAXIMO@yahoogroups.com
> Subject: Re: [MAXIMO List] Need Help Show Description of Work Order on Manage Downtime History Asset
>
>
>
>
>
> Thank you Ian, It works!
>
>
>
> Sent from my iPhone
>
>
> On 3 Feb 2014, at 17.05, Ian Wright <ian.wright@gdfsuezep.co.uk> wrote:
>
>
>
> Sorry typo
>
>
>
> wonum = :startwonum and siteid = :siteid
>
>
>
>
>
> From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Ian Wright
> Sent: 03 February 2014 10:03
> To: MAXIMO@yahoogroups.com
> Subject: RE: [MAXIMO List] Need Help Show Description of Work Order on Manage Downtime History Asset
>
>
>
>
>
> Your relationship should be
>
>
>
> wonum = :wonum and siteid = :siteid
>
>
>
> and your field on the dialog
>
>
>
> STARTWONUMDESC.DESCRIPTION
>
>
>
> Rgds Ian
>
> BPD Zenith Ltd
>
>
>
> From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of forz4ever@yahoo.com
> Sent: 03 February 2014 09:20
> To: MAXIMO@yahoogroups.com
> Subject: [MAXIMO List] Need Help Show Description of Work Order on Manage Downtime History Asset
>
>
>
>
>
> Hi everyone,
>
> I need your help to show description of work order on dialog box 'manage downtime history' Asset, I've been trying with method 'where clause' in tab relationship 'MODDOWNTIMEHIST' with 'WORKORDER' but won't open.
>
> FYI :
> Relationship : STARTWONUMDESC
> Child Object : WORKORDER
> Where Clause : assetnum=:asset.assetnum and value=:startwonum
>
> Help me for solve this puzzle, tell me if I am wrong or have another opinion for a solution. Thank you everyone :)
>
> 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.
> ****************************************************************************************************************************************************************************************
>
>
>
The downtime is kept in assetstatus table MODDOWNTIMEHIST is non persistant
The problem is assetstatus is many to one and the list tab can only show one record so it depends what you want to show if it’s the last reading then you can do it with a relationship if it’s the aggregate value then either a view or a class / script on a non persistent field to work out the value
Rgds Ian
BPD Zenith Ltd
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Lutfi Ramadhan
Sent: 03 February 2014 12:48
To: MAXIMO@yahoogroups.com
Subject: Re: [MAXIMO List] Need Help Show Description of Work Order on Manage Downtime History Asset
I want to show 'downtime' from 'MODDOWNTIMEHIST' in list Work Order Tracking, how can I showing downtime from 'Manage Downtime History' in list Work Order Tracking?
Sent from my iPhone
On 3 Feb 2014, at 17.26, Ian Wright <ian.wright@gdfsuezep.co.uk<mailto:ian.wright@gdfsuezep.co.uk>> wrote:
I know I tested it ☺
From: MAXIMO@yahoogroups.com<mailto:MAXIMO@yahoogroups.com> [mailto:MAXIMO@yahoogroups.com] On Behalf Of Lutfi Ramadhan
Sent: 03 February 2014 10:10
To: MAXIMO@yahoogroups.com<mailto:MAXIMO@yahoogroups.com>
Subject: Re: [MAXIMO List] Need Help Show Description of Work Order on Manage Downtime History Asset
Thank you Ian, It works!
Sent from my iPhone
On 3 Feb 2014, at 17.05, Ian Wright <ian.wright@gdfsuezep.co.uk<mailto:ian.wright@gdfsuezep.co.uk>> wrote:
Sorry typo
wonum = :startwonum and siteid = :siteid
From: MAXIMO@yahoogroups.com<mailto:MAXIMO@yahoogroups.com> [mailto:MAXIMO@yahoogroups.com] On Behalf Of Ian Wright
Sent: 03 February 2014 10:03
To: MAXIMO@yahoogroups.com<mailto:MAXIMO@yahoogroups.com>
Subject: RE: [MAXIMO List] Need Help Show Description of Work Order on Manage Downtime History Asset
Your relationship should be
wonum = :wonum and siteid = :siteid
and your field on the dialog
STARTWONUMDESC.DESCRIPTION
Rgds Ian
BPD Zenith Ltd
From: MAXIMO@yahoogroups.com<mailto:MAXIMO@yahoogroups.com> [mailto:MAXIMO@yahoogroups.com] On Behalf Of forz4ever@yahoo.com<mailto:forz4ever@yahoo.com>
Sent: 03 February 2014 09:20
To: MAXIMO@yahoogroups.com<mailto:MAXIMO@yahoogroups.com>
Subject: [MAXIMO List] Need Help Show Description of Work Order on Manage Downtime History Asset
Hi everyone,
I need your help to show description of work order on dialog box 'manage downtime history' Asset, I've been trying with method 'where clause' in tab relationship 'MODDOWNTIMEHIST' with 'WORKORDER' but won't open.
FYI :
Relationship : STARTWONUMDESC
Child Object : WORKORDER
Where Clause : assetnum=:asset.assetnum and value=:startwonum
Help me for solve this puzzle, tell me if I am wrong or have another opinion for a solution. Thank you everyone :)
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.
****************************************************************************************************************************************************************************************