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.
Does anyone know how to set up a crossover domain so that it will "push"
data from the current object to a related object, rather than "pullilng" it
the other way?
I seem to recall that it's possible, but maybe my memory is going . :)
Shannon Rotz
IBM Certified Solution Advisor
IBM Certified Deployment Professional
Maximo EAM V7
I'm not sure what you mean can you tell me what you want to do
The following will populate the field in the child object when the child object is created created
insert into appfielddefaults (app,defaultvalue,objectname,attributename,appfielddefaultsid) values
('PLUSGWO',':OWNEROBJECT.WONUM','PLUSGMOCAPPRLIST','WONUM',1)
Or automationscripts should work i.e. change a value in a field then
You can use
Mbo.setValue("relationship.fieldname", parameter_with_field_value,11L)
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Incomm Solutions Inc.
Sent: 05 November 2013 16:29
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] Crossover Domains - "Push"
Does anyone know how to set up a crossover domain so that it will "push" data from the current object to a related object, rather than "pullilng" it the other way?
I seem to recall that it's possible, but maybe my memory is going ... :)
Shannon Rotz
IBM Certified Solution Advisor
IBM Certified Deployment Professional
Maximo EAM V7
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.
**************************************************************************************************************
For instance: instead of "pulling" over some values from the Location to
the Work Order, as normal, is it possible to "push" a value from the work
order to the Location instead?
I thought there was a way to do that, but maybe I'm just hallucinating :)
Shannon
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of
Ian Wright
Sent: November-05-13 8:36 AM
To: MAXIMO@yahoogroups.com
Subject: RE: [MAXIMO List] Crossover Domains - "Push"
I'm not sure what you mean can you tell me what you want to do
The following will populate the field in the child object when the child
object is created created
insert into appfielddefaults
(app,defaultvalue,objectname,attributename,appfielddefaultsid) values
('PLUSGWO',':OWNEROBJECT.WONUM','PLUSGMOCAPPRLIST','WONUM',1)
Or automationscripts should work i.e. change a value in a field then
You can use
Mbo.setValue("relationship.fieldname", parameter_with_field_value,11L)
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of
Incomm Solutions Inc.
Sent: 05 November 2013 16:29
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] Crossover Domains - "Push"
Does anyone know how to set up a crossover domain so that it will "push"
data from the current object to a related object, rather than "pullilng" it
the other way?
I seem to recall that it's possible, but maybe my memory is going . :)
Shannon Rotz
IBM Certified Solution Advisor
IBM Certified Deployment Professional
Maximo EAM V7
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.
****************************************************************************
****************************************************************************
********************************
let s say in WO application you make the Location description NOT READONLY
(screendesigner) Then if you modify the Location description in Wotrack, it
will change in Locations....
On Tue, Nov 5, 2013 at 7:57 PM, Incomm Solutions Inc.
<shannonrotz@yahoo.ca>wrote:
>
>
> For instance: instead of "pulling" over some values from the Location to
> the Work Order, as normal, is it possible to "push" a value from the work
> order to the Location instead?
>
> I thought there was a way to do that, but maybe I'm just hallucinating :)
>
> Shannon
>
>
> From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of
> Ian Wright
> Sent: November-05-13 8:36 AM
> To: MAXIMO@yahoogroups.com
> Subject: RE: [MAXIMO List] Crossover Domains - "Push"
>
>
> I'm not sure what you mean can you tell me what you want to do
>
> The following will populate the field in the child object when the child
> object is created created
>
> insert into appfielddefaults
> (app,defaultvalue,objectname,attributename,appfielddefaultsid) values
>
> ('PLUSGWO',':OWNEROBJECT.WONUM','PLUSGMOCAPPRLIST','WONUM',1)
>
> Or automationscripts should work i.e. change a value in a field then
>
> You can use
>
> Mbo.setValue("relationship.fieldname", parameter_with_field_value,11L)
>
> From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of
> Incomm Solutions Inc.
> Sent: 05 November 2013 16:29
> To: MAXIMO@yahoogroups.com
> Subject: [MAXIMO List] Crossover Domains - "Push"
>
> Does anyone know how to set up a crossover domain so that it will "push"
> data from the current object to a related object, rather than "pullilng" it
> the other way?
>
> I seem to recall that it's possible, but maybe my memory is going . :)
>
>
> Shannon Rotz
>
> IBM Certified Solution Advisor
>
> IBM Certified Deployment Professional
>
> Maximo EAM V7
>
> 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.
>
> ****************************************************************************
>
> ****************************************************************************
> ********************************
>
>
>
>
>
--
Mohamed Skandaji, MBA, PMP
That is standard behavior, if you make it editable then you are editing a
field via a relationship and it will automatically change on the location.
On Tue, Nov 5, 2013 at 1:08 PM, Mohamed Skandaji <mohska@gmail.com> wrote:
>
>
> let s say in WO application you make the Location description NOT READONLY
> (screendesigner) Then if you modify the Location description in Wotrack, it
> will change in Locations....
>
>
> On Tue, Nov 5, 2013 at 7:57 PM, Incomm Solutions Inc. <
> shannonrotz@yahoo.ca> wrote:
>
>>
>>
>> For instance: instead of "pulling" over some values from the Location to
>> the Work Order, as normal, is it possible to "push" a value from the work
>> order to the Location instead?
>>
>> I thought there was a way to do that, but maybe I'm just hallucinating :)
>>
>> Shannon
>>
>>
>> From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of
>> Ian Wright
>> Sent: November-05-13 8:36 AM
>> To: MAXIMO@yahoogroups.com
>> Subject: RE: [MAXIMO List] Crossover Domains - "Push"
>>
>>
>> I'm not sure what you mean can you tell me what you want to do
>>
>> The following will populate the field in the child object when the child
>> object is created created
>>
>> insert into appfielddefaults
>> (app,defaultvalue,objectname,attributename,appfielddefaultsid) values
>>
>> ('PLUSGWO',':OWNEROBJECT.WONUM','PLUSGMOCAPPRLIST','WONUM',1)
>>
>> Or automationscripts should work i.e. change a value in a field then
>>
>> You can use
>>
>> Mbo.setValue("relationship.fieldname", parameter_with_field_value,11L)
>>
>> From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of
>> Incomm Solutions Inc.
>> Sent: 05 November 2013 16:29
>> To: MAXIMO@yahoogroups.com
>> Subject: [MAXIMO List] Crossover Domains - "Push"
>>
>> Does anyone know how to set up a crossover domain so that it will "push"
>> data from the current object to a related object, rather than "pullilng"
>> it
>> the other way?
>>
>> I seem to recall that it's possible, but maybe my memory is going . :)
>>
>>
>> Shannon Rotz
>>
>> IBM Certified Solution Advisor
>>
>> IBM Certified Deployment Professional
>>
>> Maximo EAM V7
>>
>> 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.
>>
>> ****************************************************************************
>>
>> ****************************************************************************
>> ********************************
>>
>>
>>
>>
>
>
> --
> Mohamed Skandaji, MBA, PMP
>
>
>
Interesting idea . I'll take a look at that with an eye to my current
problem to see if I could make that work.
Thanks.
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of
Mohamed Skandaji
Sent: November-05-13 11:09 AM
To: MAXIMO@yahoogroups.com
Subject: Re: [MAXIMO List] Crossover Domains - "Push"
let s say in WO application you make the Location description NOT READONLY
(screendesigner) Then if you modify the Location description in Wotrack, it
will change in Locations....
On Tue, Nov 5, 2013 at 7:57 PM, Incomm Solutions Inc. <shannonrotz@yahoo.ca>
wrote:
For instance: instead of "pulling" over some values from the Location to
the Work Order, as normal, is it possible to "push" a value from the work
order to the Location instead?
I thought there was a way to do that, but maybe I'm just hallucinating :)
Shannon
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of
Ian Wright
Sent: November-05-13 8:36 AM
To: MAXIMO@yahoogroups.com
Subject: RE: [MAXIMO List] Crossover Domains - "Push"
I'm not sure what you mean can you tell me what you want to do
The following will populate the field in the child object when the child
object is created created
insert into appfielddefaults
(app,defaultvalue,objectname,attributename,appfielddefaultsid) values
('PLUSGWO',':OWNEROBJECT.WONUM','PLUSGMOCAPPRLIST','WONUM',1)
Or automationscripts should work i.e. change a value in a field then
You can use
Mbo.setValue("relationship.fieldname", parameter_with_field_value,11L)
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of
Incomm Solutions Inc.
Sent: 05 November 2013 16:29
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] Crossover Domains - "Push"
Does anyone know how to set up a crossover domain so that it will "push"
data from the current object to a related object, rather than "pullilng" it
the other way?
I seem to recall that it's possible, but maybe my memory is going . :)
Shannon Rotz
IBM Certified Solution Advisor
IBM Certified Deployment Professional
Maximo EAM V7
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.
****************************************************************************
****************************************************************************
********************************
--
Mohamed Skandaji, MBA, PMP
from experience it can be a little chaotic too, I've seen people add a
multi-part text box and forget to make the description part read only and
have no clue that they're changing a different record thinking it is copied
over to the current record. It can be useful but be very clear as to the
intent.
On Tue, Nov 5, 2013 at 1:51 PM, Incomm Solutions Inc.
<shannonrotz@yahoo.ca>wrote:
>
>
> Interesting idea . I'll take a look at that with an eye to my current
> problem to see if I could make that work.
>
> Thanks.
>
> From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of
> Mohamed Skandaji
> Sent: November-05-13 11:09 AM
> To: MAXIMO@yahoogroups.com
> Subject: Re: [MAXIMO List] Crossover Domains - "Push"
>
> let s say in WO application you make the Location description NOT READONLY
> (screendesigner) Then if you modify the Location description in Wotrack, it
> will change in Locations....
>
> On Tue, Nov 5, 2013 at 7:57 PM, Incomm Solutions Inc. <
> shannonrotz@yahoo.ca>
> wrote:
>
> For instance: instead of "pulling" over some values from the Location to
> the Work Order, as normal, is it possible to "push" a value from the work
> order to the Location instead?
>
> I thought there was a way to do that, but maybe I'm just hallucinating :)
>
> Shannon
>
> From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of
>
> Ian Wright
> Sent: November-05-13 8:36 AM
> To: MAXIMO@yahoogroups.com
> Subject: RE: [MAXIMO List] Crossover Domains - "Push"
>
> I'm not sure what you mean can you tell me what you want to do
>
> The following will populate the field in the child object when the child
> object is created created
>
> insert into appfielddefaults
> (app,defaultvalue,objectname,attributename,appfielddefaultsid) values
>
> ('PLUSGWO',':OWNEROBJECT.WONUM','PLUSGMOCAPPRLIST','WONUM',1)
>
> Or automationscripts should work i.e. change a value in a field then
>
> You can use
>
> Mbo.setValue("relationship.fieldname", parameter_with_field_value,11L)
>
> From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of
> Incomm Solutions Inc.
> Sent: 05 November 2013 16:29
> To: MAXIMO@yahoogroups.com
> Subject: [MAXIMO List] Crossover Domains - "Push"
>
> Does anyone know how to set up a crossover domain so that it will "push"
> data from the current object to a related object, rather than "pullilng" it
> the other way?
>
> I seem to recall that it's possible, but maybe my memory is going . :)
>
> Shannon Rotz
>
> IBM Certified Solution Advisor
>
> IBM Certified Deployment Professional
>
> Maximo EAM V7
>
> 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.
>
> ****************************************************************************
>
> ****************************************************************************
> ********************************
>
>
>
> --
> Mohamed Skandaji, MBA, PMP
>
>
>
>
>
An escalation (with an action) that runs on workorder should do it. Set it to go over every 15 min or so (and put 'changedate >= sysdate - 1/96' in the 'where' clause so that it does not run on every record in WO the first time it runs)
Pat Morrow
pmorrow8@yahoo.com
On Tuesday, November 5, 2013 12:55 PM, Chris Lawless <lawlessc@gmail.com> wrote:
from experience it can be a little chaotic too, I've seen people add a multi-part text box and forget to make the description part read only and have no clue that they're changing a different record thinking it is copied over to the current record. It can be useful but be very clear as to the intent.
On Tue, Nov 5, 2013 at 1:51 PM, Incomm Solutions Inc. <shannonrotz@yahoo.ca> wrote:
>
>Interesting idea . I'll take a look at that with an eye to my current
>problem to see if I could make that work.
>
>Thanks.
>
>From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of
>Mohamed Skandaji
>Sent: November-05-13 11:09 AM
>To: MAXIMO@yahoogroups.com
>Subject: Re: [MAXIMO List] Crossover Domains - "Push"
>
>let s say in WO application you make the Location description NOT READONLY
>(screendesigner) Then if you modify the Location description in Wotrack, it
>will change in Locations....
>
>On Tue, Nov 5, 2013 at 7:57 PM, Incomm Solutions Inc. <shannonrotz@yahoo.ca>
>wrote:
>
>For instance: instead of "pulling" over some values from the Location to
>the Work Order, as normal, is it possible to "push" a value from the work
>order to the Location instead?
>
>I thought there was a way to do that, but maybe I'm just hallucinating :)
>
>Shannon
>
>From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of
>
>Ian Wright
>Sent: November-05-13 8:36 AM
>To: MAXIMO@yahoogroups.com
>Subject: RE: [MAXIMO List] Crossover Domains - "Push"
>
>I'm not sure what you mean can you tell me what you want to do
>
>The following will populate the field in the child object when the child
>object is created created
>
>insert into appfielddefaults
>(app,defaultvalue,objectname,attributename,appfielddefaultsid) values
>
>('PLUSGWO',':OWNEROBJECT.WONUM','PLUSGMOCAPPRLIST','WONUM',1)
>
>Or automationscripts should work i.e. change a value in a field then
>
>You can use
>
>Mbo.setValue("relationship.fieldname", parameter_with_field_value,11L)
>
>From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of
>Incomm Solutions Inc.
>Sent: 05 November 2013 16:29
>To: MAXIMO@yahoogroups.com
>Subject: [MAXIMO List] Crossover Domains - "Push"
>
>Does anyone know how to set up a crossover domain so that it will "push"
>data from the current object to a related object, rather than "pullilng" it
>the other way?
>
>I seem to recall that it's possible, but maybe my memory is going . :)
>
>Shannon Rotz
>
>IBM Certified Solution Advisor
>
>IBM Certified Deployment Professional
>
>Maximo EAM V7
>
>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.
>****************************************************************************
>****************************************************************************
>********************************
>
>
>
>--
>Mohamed Skandaji, MBA, PMP
>
>
>
>
As per my first post this will work in an automation script and does not have the issues of editing through a relationship
mbo.setValue("relationship.fieldname", parameter_with_field_value,11L)
or
mbo.setValue("relationship.fieldname", “your value”,11L)
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Pat Morrow
Sent: 05 November 2013 21:13
To: MAXIMO@yahoogroups.com
Subject: Re: [MAXIMO List] Crossover Domains - "Push"
An escalation (with an action) that runs on workorder should do it. Set it to go over every 15 min or so (and put 'changedate >= sysdate - 1/96' in the 'where' clause so that it does not run on every record in WO the first time it runs)
Pat Morrow
pmorrow8@yahoo.com<mailto:pmorrow8@yahoo.com>
On Tuesday, November 5, 2013 12:55 PM, Chris Lawless <lawlessc@gmail.com<mailto:lawlessc@gmail.com>> wrote:
from experience it can be a little chaotic too, I've seen people add a multi-part text box and forget to make the description part read only and have no clue that they're changing a different record thinking it is copied over to the current record. It can be useful but be very clear as to the intent.
On Tue, Nov 5, 2013 at 1:51 PM, Incomm Solutions Inc. <shannonrotz@yahoo.ca<mailto:shannonrotz@yahoo.ca>> wrote:
Interesting idea . I'll take a look at that with an eye to my current
problem to see if I could make that work.
Thanks.
From: MAXIMO@yahoogroups.com<mailto:MAXIMO@yahoogroups.com> [mailto:MAXIMO@yahoogroups.com<mailto:MAXIMO@yahoogroups.com>] On Behalf Of
Mohamed Skandaji
Sent: November-05-13 11:09 AM
To: MAXIMO@yahoogroups.com<mailto:MAXIMO@yahoogroups.com>
Subject: Re: [MAXIMO List] Crossover Domains - "Push"
let s say in WO application you make the Location description NOT READONLY
(screendesigner) Then if you modify the Location description in Wotrack, it
will change in Locations....
On Tue, Nov 5, 2013 at 7:57 PM, Incomm Solutions Inc. <shannonrotz@yahoo.ca<mailto:shannonrotz@yahoo.ca>>
wrote:
For instance: instead of "pulling" over some values from the Location to
the Work Order, as normal, is it possible to "push" a value from the work
order to the Location instead?
I thought there was a way to do that, but maybe I'm just hallucinating :)
Shannon
From: MAXIMO@yahoogroups.com<mailto:MAXIMO@yahoogroups.com> [mailto:MAXIMO@yahoogroups.com<mailto:MAXIMO@yahoogroups.com>] On Behalf Of
Ian Wright
Sent: November-05-13 8:36 AM
To: MAXIMO@yahoogroups.com<mailto:MAXIMO@yahoogroups.com>
Subject: RE: [MAXIMO List] Crossover Domains - "Push"
I'm not sure what you mean can you tell me what you want to do
The following will populate the field in the child object when the child
object is created created
insert into appfielddefaults
(app,defaultvalue,objectname,attributename,appfielddefaultsid) values
('PLUSGWO',':OWNEROBJECT.WONUM','PLUSGMOCAPPRLIST','WONUM',1)
Or automationscripts should work i.e. change a value in a field then
You can use
Mbo.setValue("relationship.fieldname", parameter_with_field_value,11L)
From: MAXIMO@yahoogroups.com<mailto:MAXIMO@yahoogroups.com> [mailto:MAXIMO@yahoogroups.com<mailto:MAXIMO@yahoogroups.com>] On Behalf Of
Incomm Solutions Inc.
Sent: 05 November 2013 16:29
To: MAXIMO@yahoogroups.com<mailto:MAXIMO@yahoogroups.com>
Subject: [MAXIMO List] Crossover Domains - "Push"
Does anyone know how to set up a crossover domain so that it will "push"
data from the current object to a related object, rather than "pullilng" it
the other way?
I seem to recall that it's possible, but maybe my memory is going . :)
Shannon Rotz
IBM Certified Solution Advisor
IBM Certified Deployment Professional
Maximo EAM V7
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.
****************************************************************************
****************************************************************************
********************************
--
Mohamed Skandaji, MBA, PMP
Couple thoughts on this.
1. If you think you NEED to push data from one object to another, it may mean the data element is not properly normalized. I'm personally kinda fanatical about adhering to third normal form, more so than most I know, but I thought it worth bringing up.
2. Be mindful of the validation on the object being "pushed to". We used to have a running total in a custom attribute in locations, and we were pushing data to that running total based on changes made in the work order app. Because of the condition of out locations data (due to allowing back end updates, but that's another story) sometimes the save on the work order would fail and it was because of the validation on the locations object.
3. Be mindful of pushing data changes to the a single row in the target object from multiple rows in the source object as this can result in getting a "record updated by another user error". We ran into this where updates to multiple work orders (children) were pushing the update to the same locations object.
Thanks!
-Chris H
-----Original Message-----
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Ian Wright
Sent: Wednesday, November 06, 2013 3:07 AM
To: MAXIMO@yahoogroups.com
Subject: RE: [MAXIMO List] Crossover Domains - "Push"
As per my first post this will work in an automation script and does not have the issues of editing through a relationship
mbo.setValue("relationship.fieldname", parameter_with_field_value,11L)
or
mbo.setValue("relationship.fieldname", “your value”,11L)
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Pat Morrow
Sent: 05 November 2013 21:13
To: MAXIMO@yahoogroups.com
Subject: Re: [MAXIMO List] Crossover Domains - "Push"
An escalation (with an action) that runs on workorder should do it. Set it to go over every 15 min or so (and put 'changedate >= sysdate - 1/96' in the 'where' clause so that it does not run on every record in WO the first time it runs)
Pat Morrow
pmorrow8@yahoo.com
On Tuesday, November 5, 2013 12:55 PM, Chris Lawless <lawlessc@gmail.com> wrote:
from experience it can be a little chaotic too, I've seen people add a multi-part text box and forget to make the description part read only and have no clue that they're changing a different record thinking it is copied over to the current record. It can be useful but be very clear as to the intent.
On Tue, Nov 5, 2013 at 1:51 PM, Incomm Solutions Inc. <shannonrotz@yahoo.ca> wrote:
Interesting idea . I'll take a look at that with an eye to my current problem to see if I could make that work.
Thanks.
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Mohamed Skandaji
Sent: November-05-13 11:09 AM
To: MAXIMO@yahoogroups.com
Subject: Re: [MAXIMO List] Crossover Domains - "Push"
let s say in WO application you make the Location description NOT READONLY
(screendesigner) Then if you modify the Location description in Wotrack, it will change in Locations....
On Tue, Nov 5, 2013 at 7:57 PM, Incomm Solutions Inc. <shannonrotz@yahoo.ca>
wrote:
For instance: instead of "pulling" over some values from the Location to the Work Order, as normal, is it possible to "push" a value from the work order to the Location instead?
I thought there was a way to do that, but maybe I'm just hallucinating :)
Shannon
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of
Ian Wright
Sent: November-05-13 8:36 AM
To: MAXIMO@yahoogroups.com
Subject: RE: [MAXIMO List] Crossover Domains - "Push"
I'm not sure what you mean can you tell me what you want to do
The following will populate the field in the child object when the child object is created created
insert into appfielddefaults
(app,defaultvalue,objectname,attributename,appfielddefaultsid) values
('PLUSGWO',':OWNEROBJECT.WONUM','PLUSGMOCAPPRLIST','WONUM',1)
Or automationscripts should work i.e. change a value in a field then
You can use
Mbo.setValue("relationship.fieldname", parameter_with_field_value,11L)
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Incomm Solutions Inc.
Sent: 05 November 2013 16:29
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] Crossover Domains - "Push"
Does anyone know how to set up a crossover domain so that it will "push"
data from the current object to a related object, rather than "pullilng" it the other way?
I seem to recall that it's possible, but maybe my memory is going . :)
Shannon Rotz
IBM Certified Solution Advisor
IBM Certified Deployment Professional
Maximo EAM V7
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.
****************************************************************************
****************************************************************************
********************************
--
Mohamed Skandaji, MBA, PMP
We had this as an issue between work orders and failure codes when we found that in Quick Reporting in 6.2.7 you were able to 'modify' the description of the failure/ problem/ cause/ and remedy and because the descriptions are not stored at the work order level everytime someone change one of these descriptions it modified all the historical records to show the new (current) description.
---In MAXIMO@yahoogroups.com, <christopher.a.hanna@...> wrote:
Couple thoughts on this.
1. If you think you NEED to push data from one object to another, it may mean the data element is not properly normalized. I'm personally kinda fanatical about adhering to third normal form, more so than most I know, but I thought it worth bringing up.
2. Be mindful of the validation on the object being "pushed to". We used to have a running total in a custom attribute in locations, and we were pushing data to that running total based on changes made in the work order app. Because of the condition of out locations data (due to allowing back end updates, but that's another story) sometimes the save on the work order would fail and it was because of the validation on the locations object.
3. Be mindful of pushing data changes to the a single row in the target object from multiple rows in the source object as this can result in getting a "record updated by another user error". We ran into this where updates to multiple work orders (children) were pushing the update to the same locations object.
Thanks!
-Chris H
-----Original Message-----
From: MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com] On Behalf Of Ian Wright
Sent: Wednesday, November 06, 2013 3:07 AM
To: MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com
Subject: RE: [MAXIMO List] Crossover Domains - "Push"
As per my first post this will work in an automation script and does not have the issues of editing through a relationship
mbo.setValue("relationship.fieldname", parameter_with_field_value,11L)
or
mbo.setValue("relationship.fieldname", “your value”,11L)
From: MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com] On Behalf Of Pat Morrow
Sent: 05 November 2013 21:13
To: MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com
Subject: Re: [MAXIMO List] Crossover Domains - "Push"
An escalation (with an action) that runs on workorder should do it. Set it to go over every 15 min or so (and put 'changedate >= sysdate - 1/96' in the 'where' clause so that it does not run on every record in WO the first time it runs)
Pat Morrow
pmorrow8@... mailto:pmorrow8@...
On Tuesday, November 5, 2013 12:55 PM, Chris Lawless <lawlessc@... mailto:lawlessc@...> wrote:
from experience it can be a little chaotic too, I've seen people add a multi-part text box and forget to make the description part read only and have no clue that they're changing a different record thinking it is copied over to the current record. It can be useful but be very clear as to the intent.
On Tue, Nov 5, 2013 at 1:51 PM, Incomm Solutions Inc. <shannonrotz@... mailto:shannonrotz@...> wrote:
Interesting idea . I'll take a look at that with an eye to my current problem to see if I could make that work.
Thanks.
From: MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com] On Behalf Of Mohamed Skandaji
Sent: November-05-13 11:09 AM
To: MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com
Subject: Re: [MAXIMO List] Crossover Domains - "Push"
let s say in WO application you make the Location description NOT READONLY
(screendesigner) Then if you modify the Location description in Wotrack, it will change in Locations....
On Tue, Nov 5, 2013 at 7:57 PM, Incomm Solutions Inc. <shannonrotz@... mailto:shannonrotz@...>
wrote:
For instance: instead of "pulling" over some values from the Location to the Work Order, as normal, is it possible to "push" a value from the work order to the Location instead?
I thought there was a way to do that, but maybe I'm just hallucinating :)
Shannon
From: MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com] On Behalf Of
Ian Wright
Sent: November-05-13 8:36 AM
To: MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com
Subject: RE: [MAXIMO List] Crossover Domains - "Push"
I'm not sure what you mean can you tell me what you want to do
The following will populate the field in the child object when the child object is created created
insert into appfielddefaults
(app,defaultvalue,objectname,attributename,appfielddefaultsid) values
('PLUSGWO',':OWNEROBJECT.WONUM','PLUSGMOCAPPRLIST','WONUM',1)
Or automationscripts should work i.e. change a value in a field then
You can use
Mbo.setValue("relationship.fieldname", parameter_with_field_value,11L)
From: MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com] On Behalf Of Incomm Solutions Inc.
Sent: 05 November 2013 16:29
To: MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com
Subject: [MAXIMO List] Crossover Domains - "Push"
Does anyone know how to set up a crossover domain so that it will "push"
data from the current object to a related object, rather than "pullilng" it the other way?
I seem to recall that it's possible, but maybe my memory is going . :)
Shannon Rotz
IBM Certified Solution Advisor
IBM Certified Deployment Professional
Maximo EAM V7
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.
****************************************************************************
****************************************************************************
********************************
--
Mohamed Skandaji, MBA, PMP
Thanks for the discussion guys. The requirement in question was to allow the user to see certain data about the last transaction against the current record. I realized, in a “duh!” moment, that all I really needed to do was display it, not transfer it. So the simplest solution won out – yay!
Regarding your points, Chris – I agree, and normally wouldn’t go in this direction myself except in limited circumstances, of which this happened to be one. Thanks for your suggestions too, Pat & Ian –
Shannon
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of roy.cline@covidien.com
Sent: November-06-13 6:37 AM
To: MAXIMO@yahoogroups.com
Subject: RE: RE: [MAXIMO List] Crossover Domains - "Push"
We had this as an issue between work orders and failure codes when we found that in Quick Reporting in 6.2.7 you were able to 'modify' the description of the failure/ problem/ cause/ and remedy and because the descriptions are not stored at the work order level everytime someone change one of these descriptions it modified all the historical records to show the new (current) description.
---In MAXIMO@yahoogroups.com, <christopher.a.hanna@...> wrote:
Couple thoughts on this.
1. If you think you NEED to push data from one object to another, it may mean the data element is not properly normalized. I'm personally kinda fanatical about adhering to third normal form, more so than most I know, but I thought it worth bringing up.
2. Be mindful of the validation on the object being "pushed to". We used to have a running total in a custom attribute in locations, and we were pushing data to that running total based on changes made in the work order app. Because of the condition of out locations data (due to allowing back end updates, but that's another story) sometimes the save on the work order would fail and it was because of the validation on the locations object.
3. Be mindful of pushing data changes to the a single row in the target object from multiple rows in the source object as this can result in getting a "record updated by another user error". We ran into this where updates to multiple work orders (children) were pushing the update to the same locations object.
Thanks!
-Chris H
-----Original Message-----
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Ian Wright
Sent: Wednesday, November 06, 2013 3:07 AM
To: MAXIMO@yahoogroups.com
Subject: RE: [MAXIMO List] Crossover Domains - "Push"
As per my first post this will work in an automation script and does not have the issues of editing through a relationship
mbo.setValue("relationship.fieldname", parameter_with_field_value,11L)
or
mbo.setValue("relationship.fieldname", “your value”,11L)
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Pat Morrow
Sent: 05 November 2013 21:13
To: MAXIMO@yahoogroups.com
Subject: Re: [MAXIMO List] Crossover Domains - "Push"
An escalation (with an action) that runs on workorder should do it. Set it to go over every 15 min or so (and put 'changedate >= sysdate - 1/96' in the 'where' clause so that it does not run on every record in WO the first time it runs)
Pat Morrow
pmorrow8@...
On Tuesday, November 5, 2013 12:55 PM, Chris Lawless <lawlessc@...> wrote:
from experience it can be a little chaotic too, I've seen people add a multi-part text box and forget to make the description part read only and have no clue that they're changing a different record thinking it is copied over to the current record. It can be useful but be very clear as to the intent.
On Tue, Nov 5, 2013 at 1:51 PM, Incomm Solutions Inc. <shannonrotz@...> wrote:
Interesting idea . I'll take a look at that with an eye to my current problem to see if I could make that work.
Thanks.
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Mohamed Skandaji
Sent: November-05-13 11:09 AM
To: MAXIMO@yahoogroups.com
Subject: Re: [MAXIMO List] Crossover Domains - "Push"
let s say in WO application you make the Location description NOT READONLY
(screendesigner) Then if you modify the Location description in Wotrack, it will change in Locations....
On Tue, Nov 5, 2013 at 7:57 PM, Incomm Solutions Inc. <shannonrotz@...>
wrote:
For instance: instead of "pulling" over some values from the Location to the Work Order, as normal, is it possible to "push" a value from the work order to the Location instead?
I thought there was a way to do that, but maybe I'm just hallucinating :)
Shannon
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of
Ian Wright
Sent: November-05-13 8:36 AM
To: MAXIMO@yahoogroups.com
Subject: RE: [MAXIMO List] Crossover Domains - "Push"
I'm not sure what you mean can you tell me what you want to do
The following will populate the field in the child object when the child object is created created
insert into appfielddefaults
(app,defaultvalue,objectname,attributename,appfielddefaultsid) values
('PLUSGWO',':OWNEROBJECT.WONUM','PLUSGMOCAPPRLIST','WONUM',1)
Or automationscripts should work i.e. change a value in a field then
You can use
Mbo.setValue("relationship.fieldname", parameter_with_field_value,11L)
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Incomm Solutions Inc.
Sent: 05 November 2013 16:29
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] Crossover Domains - "Push"
Does anyone know how to set up a crossover domain so that it will "push"
data from the current object to a related object, rather than "pullilng" it the other way?
I seem to recall that it's possible, but maybe my memory is going . :)
Shannon Rotz
IBM Certified Solution Advisor
IBM Certified Deployment Professional
Maximo EAM V7
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.
****************************************************************************
****************************************************************************
********************************
--
Mohamed Skandaji, MBA, PMP