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.
Dear All ,
I need to create a view with one field which is the combination of wonum and assetnum
eg: select assetnum from asset
union all
select wonum from workorder
how can I create view like this in maximo .Please help. I want to make a lookup with this view.
Reagrds
Jackey
First you create the view outside of Maximo, then create it in Maximo and use the name you gave it.
-W
________________________________
From: "sagar jackey jackey_sagar@yahoo.co.in [MAXIMO]" <MAXIMO@yahoogroups.com>
To: maximo yahoo <MAXIMO@yahoogroups.com>
Sent: Wednesday, June 25, 2014 6:56 AM
Subject: [MAXIMO List] Help in create View in Maximo
Dear All ,
I need to create a view with one field which is the combination of wonum and assetnum
eg: select assetnum from asset
union all
select wonum from workorder
how can I create view like this in maximo .Please help. I want to make a lookup with this view.
Reagrds
Jackey
That seems a strange combination why do you want a list of assets and a list of work orders added together
Rgds Ian
________________________________
From: MAXIMO@yahoogroups.com [MAXIMO@yahoogroups.com]
Sent: 25 June 2014 16:43
To: MAXIMO@yahoogroups.com
Subject: Re: [MAXIMO List] Help in create View in Maximo
First you create the view outside of Maximo, then create it in Maximo and use the name you gave it.
-W
________________________________
From: "sagar jackey jackey_sagar@yahoo.co.in [MAXIMO]" <MAXIMO@yahoogroups.com>
To: maximo yahoo <MAXIMO@yahoogroups.com>
Sent: Wednesday, June 25, 2014 6:56 AM
Subject: [MAXIMO List] Help in create View in Maximo
Dear All ,
I need to create a view with one field which is the combination of wonum and assetnum
eg: select assetnum from asset
union all
select wonum from workorder
how can I create view like this in maximo .Please help. I want to make a lookup with this view.
Reagrds
Jackey
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.
**************************************************************************************************************
Dear William,
I already created a view in database
CREATE OR REPLACE FORCE VIEW ZPLANTMAINT (ASSETNUM)
AS
SELECT assetnum
FROM asset
WHERE assetnum LIKE 'P%'
UNION ALL
SELECT wonum
FROM workorder
WHERE status NOT IN ('CLOSE', 'CAN') AND istask = 0;
But now how can I call or create in maximo.
Ian,
Our client using some projects , so they need asset and workorder related to that in this column.
On Wednesday, 25 June 2014 6:48 PM, "Ian Wright ian.wright@gdfsuezep.co.uk [MAXIMO]" <MAXIMO@yahoogroups.com> wrote:
That seems a strange combination why do you want a list of assets and a list of work orders added together
Rgds Ian
________________________________
From: MAXIMO@yahoogroups.com [MAXIMO@yahoogroups.com]
Sent: 25 June 2014 16:43
To: MAXIMO@yahoogroups.com
Subject: Re: [MAXIMO List] Help in create View in Maximo
First you create the view outside of Maximo, then create it in Maximo and use the name you gave it.
-W
________________________________
From: "sagar jackey jackey_sagar@yahoo.co.in [MAXIMO]" <MAXIMO@yahoogroups.com>
To: maximo yahoo <MAXIMO@yahoogroups.com>
Sent: Wednesday, June 25, 2014 6:56 AM
Subject: [MAXIMO List] Help in create View in Maximo
Dear All ,
I need to create a view with one field which is the combination of wonum and assetnum
eg: select assetnum from asset
union all
select wonum from workorder
how can I create view like this in maximo .Please help. I want to make a lookup with this view.
Reagrds
Jackey
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.
**************************************************************************************************************
------------------------------------
------------------------------------
Email addresses you might need:
Posting: MAXIMO@yahoogroups.com
Join : MAXIMO-subscribe@yahoogroups.com
Leave : MAXIMO-unsubscribe@yahoogroups.com
Cry : MAXIMO-owner@yahoogroups.com
Group : http://groups.yahoo.com/group/MAXIMO
------------------------------------
Yahoo Groups Links
MAXIMO-unsubscribe@yahoogroups.com
In database configuration, create a new object, note the view section, you'll want to check
View.
________________________________
From: "sagar jackey jackey_sagar@yahoo.co.in [MAXIMO]" <MAXIMO@yahoogroups.com>
To: "MAXIMO@yahoogroups.com" <MAXIMO@yahoogroups.com>
Sent: Thursday, June 26, 2014 12:46 AM
Subject: Re: [MAXIMO List] Help in create View in Maximo
Dear William,
I already created a view in database
CREATE OR REPLACE FORCE VIEW ZPLANTMAINT (ASSETNUM)
AS
SELECT assetnum
FROM asset
WHERE assetnum LIKE 'P%'
UNION ALL
SELECT wonum
FROM workorder
WHERE status NOT IN ('CLOSE', 'CAN') AND istask = 0;
But now how can I call or create in maximo.
Ian,
Our client using some projects , so they need asset and workorder related to that in this column.
On Wednesday, 25 June 2014 6:48 PM, "Ian Wright ian.wright@gdfsuezep.co.uk [MAXIMO]" <MAXIMO@yahoogroups.com> wrote:
That seems a strange combination why do you want a list of assets and a list of work orders added together
Rgds Ian
________________________________
From: MAXIMO@yahoogroups.com [MAXIMO@yahoogroups.com]
Sent: 25 June 2014 16:43
To: MAXIMO@yahoogroups.com
Subject: Re: [MAXIMO List] Help in create View in Maximo
First you create the view outside of Maximo, then create it in Maximo and use the name you gave it.
-W
________________________________
From: "sagar jackey jackey_sagar@yahoo.co.in [MAXIMO]" <MAXIMO@yahoogroups.com>
To: maximo yahoo <MAXIMO@yahoogroups.com>
Sent: Wednesday, June 25, 2014 6:56 AM
Subject: [MAXIMO List] Help in create View in Maximo
Dear All ,
I need to create a view with one field which is the combination of wonum and assetnum
eg: select assetnum from asset
union all
select wonum from workorder
how can I create view like this in maximo .Please help. I want to make a lookup with this view.
Reagrds
Jackey
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.
**************************************************************************************************************
------------------------------------
------------------------------------
Email addresses you might need:
Posting: MAXIMO@yahoogroups.com
Join : MAXIMO-subscribe@yahoogroups.com
Leave : MAXIMO-unsubscribe@yahoogroups.com
Cry : MAXIMO-owner@yahoogroups.com
Group : http://groups.yahoo.com/group/MAXIMO
------------------------------------
Yahoo Groups Links
MAXIMO-unsubscribe@yahoogroups.com