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.
there are two relations on in the COMPDEPARTMENT MBO and the other in COMPANIES MBO and one I don't use is the COMPDEPARTMENT MBO named "COMPANIES" I made it for future use.I think both are correct.
-- Regards,
- Ramy Mohamed Raslan
Cell phone: +20102 4640 011
To: MAXIMO@yahoogroups.com
From: ian.wright@gdfsuezep.co.uk
Date: Tue, 10 Sep 2013 13:40:15 +0000
Subject: RE: [MAXIMO List] Maximo Add new row Customization in Company Application
Also make sure you have the correct relationship between the COMPANY app COMPANIES table (owner ) and child (COMPDEPARTMENT)
table
The owner of the relationship is
COMPANIES
Probably
Company = :company and orgid = :orgid
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com]
On Behalf Of Ian Wright
Sent: 10 September 2013 14:08
To: MAXIMO@yahoogroups.com
Subject: RE: [MAXIMO List] Maximo Add new row Customization in Company Application
Did you stop and start the application server ?
From:
MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com]
On Behalf Of Ramy M. Raslan
Sent: 10 September 2013 12:41
To: maximo yahoogroups
Subject: RE: [MAXIMO List] Maximo Add new row Customization in Company Application
Thanks for your replay
who we configure or make this standard function work it didn't work with me so something is missing.
I did make it same as the parent object and attrebut in the database configration.
Thanks for your patience
--
Regards,
- Ramy Mohamed Raslan
Cell phone: +20102 4640 011
To:
MAXIMO@yahoogroups.com
From: ian.wright@gdfsuezep.co.uk
Date: Tue, 10 Sep 2013 10:58:19 +0000
Subject: RE: [MAXIMO List] Maximo Add new row Customization in Company Application
Its standard functionality if you enter the correct values into this table then child tables of a main object are automatically updated with the parent values you specify
('COMPANY',':OWNEROBJECT.COMPANY','COMPDEPARTMENT','COMPANY',1)
The Company field from the ownerobject Company will be automatically entered into the company field of the child object
COMPDEPARTMENT in effect you key value is set therefore your records don’t vanish
Rgds Ian
BPD Zenith Ltd
From:
MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com]
On Behalf Of Ramy M. Raslan
Sent: 10 September 2013 11:39
To: maximo yahoogroups
Subject: RE: [MAXIMO List] Maximo Add new row Customization in Company Application
Thanks for the feedback
I don't know if understand you correctly but do you suggest a trigger in the database to replace the customization
And by join you did you main the relation please can you be more specific which one for me to review and fix
Thanks in advance
--
Regards,
- Ramy Mohamed Raslan
Cell phone: +20102 4640 011
To: MAXIMO@yahoogroups.com
From: ian.wright@gdfsuezep.co.uk
Date: Mon, 9 Sep 2013 14:41:29 +0000
Subject: RE: [MAXIMO List] Maximo Add new row Customization in Company Application
No code of any type is needed just add the required fields get your key fields then any other fields you require to copy to your source table
I think you will need to re-start your application server you don’t need to do orgid or siteid as the framework will fill them in for you
insert
into appfielddefaults
(app,defaultvalue,objectname,attributename,appfielddefaultsid)
values
('COMPANY',':OWNEROBJECT.COMPANY','COMPDEPARTMENT','COMPANY',1)
Your joins don’t look correct either you need to join from COMPANY to COMPDEPARTMENT
Not as shown in your screen shot
Rgds Ian
BPD Zenith Ltd
From:
MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com]
On Behalf Of Ramy M. Raslan
Sent: 09 September 2013 15:26
To: maximo yahoogroups
Subject: [MAXIMO List] Maximo Add new row Customization in Company Application
Hi all
This is blog post i made trying to explain how to add a new tab with a new row function and some java customization
any feed back will be appreciated.
http://crazyjavadeveloper.blogspot.com/2013/09/companies-application-new-departments.html
http://crazyjavadeveloper.blogspot.com/2013/09/companies-application-new-departments_9.html
Thanks in advance
--
Regards,
- Ramy Mohamed Raslan
Cell phone: +20102 4640 011
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.
****************************************************************************************************************************************************************************************
Is it working after a restart of your application server if it's a cluster I think you will need to stop and start all the UI members ?
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Ramy M. Raslan
Sent: 11 September 2013 09:34
To: maximo yahoogroups
Subject: RE: [MAXIMO List] Maximo Add new row Customization in Company Application
there are two relations on in the COMPDEPARTMENT MBO and the other in COMPANIES MBO and one I don't use is the COMPDEPARTMENT MBO named "COMPANIES" I made it for future use.
I think both are correct.
--
Regards,
- Ramy Mohamed Raslan
Cell phone: +20102 4640 011
________________________________
To: MAXIMO@yahoogroups.com<mailto:MAXIMO@yahoogroups.com>
From: ian.wright@gdfsuezep.co.uk<mailto:ian.wright@gdfsuezep.co.uk>
Date: Tue, 10 Sep 2013 13:40:15 +0000
Subject: RE: [MAXIMO List] Maximo Add new row Customization in Company Application
Also make sure you have the correct relationship between the COMPANY app COMPANIES table (owner ) and child (COMPDEPARTMENT) table
The owner of the relationship is COMPANIES
Probably
Company = :company and orgid = :orgid
From: MAXIMO@yahoogroups.com<mailto:MAXIMO@yahoogroups.com> [mailto:MAXIMO@yahoogroups.com] On Behalf Of Ian Wright
Sent: 10 September 2013 14:08
To: MAXIMO@yahoogroups.com<mailto:MAXIMO@yahoogroups.com>
Subject: RE: [MAXIMO List] Maximo Add new row Customization in Company Application
Did you stop and start the application server ?
From: MAXIMO@yahoogroups.com<mailto:MAXIMO@yahoogroups.com> [mailto:MAXIMO@yahoogroups.com] On Behalf Of Ramy M. Raslan
Sent: 10 September 2013 12:41
To: maximo yahoogroups
Subject: RE: [MAXIMO List] Maximo Add new row Customization in Company Application
Thanks for your replay
who we configure or make this standard function work it didn't work with me so something is missing.
I did make it same as the parent object and attrebut in the database configration.
Thanks for your patience
--
Regards,
- Ramy Mohamed Raslan
Cell phone: +20102 4640 011
________________________________
To: MAXIMO@yahoogroups.com<mailto:MAXIMO@yahoogroups.com>
From: ian.wright@gdfsuezep.co.uk<mailto:ian.wright@gdfsuezep.co.uk>
Date: Tue, 10 Sep 2013 10:58:19 +0000
Subject: RE: [MAXIMO List] Maximo Add new row Customization in Company Application
Its standard functionality if you enter the correct values into this table then child tables of a main object are automatically updated with the parent values you specify
('COMPANY',':OWNEROBJECT.COMPANY','COMPDEPARTMENT','COMPANY',1)
The Company field from the ownerobject Company will be automatically entered into the company field of the child object COMPDEPARTMENT in effect you key value is set therefore your records don't vanish
Rgds Ian
BPD Zenith Ltd
From: MAXIMO@yahoogroups.com<mailto:MAXIMO@yahoogroups.com> [mailto:MAXIMO@yahoogroups.com] On Behalf Of Ramy M. Raslan
Sent: 10 September 2013 11:39
To: maximo yahoogroups
Subject: RE: [MAXIMO List] Maximo Add new row Customization in Company Application
Thanks for the feedback
I don't know if understand you correctly but do you suggest a trigger in the database to replace the customization
And by join you did you main the relation please can you be more specific which one for me to review and fix
Thanks in advance
--
Regards,
- Ramy Mohamed Raslan
Cell phone: +20102 4640 011
________________________________
To: MAXIMO@yahoogroups.com<mailto:MAXIMO@yahoogroups.com>
From: ian.wright@gdfsuezep.co.uk<mailto:ian.wright@gdfsuezep.co.uk>
Date: Mon, 9 Sep 2013 14:41:29 +0000
Subject: RE: [MAXIMO List] Maximo Add new row Customization in Company Application
No code of any type is needed just add the required fields get your key fields then any other fields you require to copy to your source table
I think you will need to re-start your application server you don't need to do orgid or siteid as the framework will fill them in for you
insert into appfielddefaults (app,defaultvalue,objectname,attributename,appfielddefaultsid) values
('COMPANY',':OWNEROBJECT.COMPANY','COMPDEPARTMENT','COMPANY',1)
Your joins don't look correct either you need to join from COMPANY to COMPDEPARTMENT
Not as shown in your screen shot
Rgds Ian
BPD Zenith Ltd
From: MAXIMO@yahoogroups.com<mailto:MAXIMO@yahoogroups.com> [mailto:MAXIMO@yahoogroups.com] On Behalf Of Ramy M. Raslan
Sent: 09 September 2013 15:26
To: maximo yahoogroups
Subject: [MAXIMO List] Maximo Add new row Customization in Company Application
Hi all
This is blog post i made trying to explain how to add a new tab with a new row function and some java customization
any feed back will be appreciated.
http://crazyjavadeveloper.blogspot.com/2013/09/companies-application-new-departments.html
http://crazyjavadeveloper.blogspot.com/2013/09/companies-application-new-departments_9.html
Thanks in advance
--
Regards,
- Ramy Mohamed Raslan
Cell phone: +20102 4640 011
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.
****************************************************************************************************************************************************************************************