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.



Modify a field's value by changing value of another field

From: shakti biswal (2012-01-31 10:37)

Hi,
I know this can be done using validation classes. Is there a way to do so just by configuring maximo and not by java coding?
Say, a field named "Status" can take values A/B/C/D. Another field is a checkbox named "Disabled". The condition is when I set the Status field to D, it should check the Disabled field. Can we do this by condition UI?
There is another not so elegant solution by executing an escalation that periodically checks for records with Status D and sets the Disabled field.
Thanks in advance.
Regards,
Shakti


From: Chad Stringer (2012-01-31 08:37)

What version of Maximo are you running?
In Maximo 7 you can use conditional expressions against the domain value list to only show the desired values once another value is true. We use this functionality quite often.
CJ Stringer
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of shakti biswal
Sent: Tuesday, January 31, 2012 12:07 AM
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] Modify a field's value by changing value of another field
Hi,
I know this can be done using validation classes. Is there a way to do so just by configuring maximo and not by java coding?
Say, a field named "Status" can take values A/B/C/D. Another field is a checkbox named "Disabled". The condition is when I set the Status field to D, it should check the Disabled field. Can we do this by condition UI?
There is another not so elegant solution by executing an escalation that periodically checks for records with Status D and sets the Disabled field.
Thanks in advance.
Regards,
Shakti


From: shakti biswal (2012-02-01 14:10)

Thanks Chad for your reply.
 
We're running Maximo V7.1.1. In this case I'm trying to check "Disabled" field when I select the "Status" as D. Or if I try to disable the record by checking "Disabled" field as true, can I set the status value to D.
 
How can I invoke an event that sets the value of a field when I try setting Status value to D? Is this possible without validation logic?
 
-Shakti
________________________________
From: Chad Stringer <cstringer@practive-inc.com>
To: "MAXIMO@yahoogroups.com" <MAXIMO@yahoogroups.com>
Sent: Tuesday, 31 January 2012 7:07 PM
Subject: RE: [MAXIMO List] Modify a field's value by changing value of another field
 
What version of Maximo are you running?
In Maximo 7 you can use conditional expressions against the domain value list to only show the desired values once another value is true. We use this functionality quite often.
CJ Stringer
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of shakti biswal
Sent: Tuesday, January 31, 2012 12:07 AM
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] Modify a field's value by changing value of another field
Hi,
I know this can be done using validation classes. Is there a way to do so just by configuring maximo and not by java coding?
Say, a field named "Status" can take values A/B/C/D. Another field is a checkbox named "Disabled". The condition is when I set the Status field to D, it should check the Disabled field. Can we do this by condition UI?
There is another not so elegant solution by executing an escalation that periodically checks for records with Status D and sets the Disabled field.
Thanks in advance.
Regards,
Shakti


From: Chad Stringer (2012-02-01 09:33)

First you need to figure out which field you want to limit the other. They can't both limit each other.

If you want to check the 'Disabled' field, and have the only valid status be 'D', you set a conditional expression where the where clause is that the disabled field = 1, then, in the domain value list for the statuses, you have set the D value as the only valid field when that condition is true by using the View/Modify conditions, then adding the desired condition to the value you need.
Now, you need to verify the functionality is correct in a dev environment first. You have to be very careful that you get your where clauses correct, or when the conditions are not met, you may get some odd results.

Test this thoroughly before you implement, but I do this in a lot of cases. We have used this practice to limit crafts available for different work types. Functions very successfully.

CJ Stringer

From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of shakti biswal
Sent: Wednesday, February 01, 2012 3:41 AM
To: MAXIMO@yahoogroups.com
Subject: Re: [MAXIMO List] Modify a field's value by changing value of another field



Thanks Chad for your reply.

We're running Maximo V7.1.1. In this case I'm trying to check "Disabled" field when I select the "Status" as D. Or if I try to disable the record by checking "Disabled" field as true, can I set the status value to D.

How can I invoke an event that sets the value of a field when I try setting Status value to D? Is this possible without validation logic?

-Shakti

________________________________
From: Chad Stringer <cstringer@practive-inc.com<mailto:cstringer%40practive-inc.com>>
To: "MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com>" <MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com>>
Sent: Tuesday, 31 January 2012 7:07 PM
Subject: RE: [MAXIMO List] Modify a field's value by changing value of another field


What version of Maximo are you running?

In Maximo 7 you can use conditional expressions against the domain value list to only show the desired values once another value is true. We use this functionality quite often.

CJ Stringer

From: MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com> [mailto:MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com>] On Behalf Of shakti biswal
Sent: Tuesday, January 31, 2012 12:07 AM
To: MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com>
Subject: [MAXIMO List] Modify a field's value by changing value of another field

Hi,

I know this can be done using validation classes. Is there a way to do so just by configuring maximo and not by java coding?

Say, a field named "Status" can take values A/B/C/D. Another field is a checkbox named "Disabled". The condition is when I set the Status field to D, it should check the Disabled field. Can we do this by condition UI?

There is another not so elegant solution by executing an escalation that periodically checks for records with Status D and sets the Disabled field.

Thanks in advance.

Regards,
Shakti








From: Bairrington, Jarrell (2012-02-01 14:57)

Could this be used to limit the choice work order numbers available to a person or craft when entering time in labor reporting?

_________________________________________________________________________________________
Jerry Bairrington│Business Applications Analyst II│CS Operations Support│USAA


From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Chad Stringer
Sent: Wednesday, February 01, 2012 8:34 AM
To: MAXIMO@yahoogroups.com
Subject: RE: [MAXIMO List] Modify a field's value by changing value of another field



First you need to figure out which field you want to limit the other. They can't both limit each other.

If you want to check the 'Disabled' field, and have the only valid status be 'D', you set a conditional expression where the where clause is that the disabled field = 1, then, in the domain value list for the statuses, you have set the D value as the only valid field when that condition is true by using the View/Modify conditions, then adding the desired condition to the value you need.
Now, you need to verify the functionality is correct in a dev environment first. You have to be very careful that you get your where clauses correct, or when the conditions are not met, you may get some odd results.

Test this thoroughly before you implement, but I do this in a lot of cases. We have used this practice to limit crafts available for different work types. Functions very successfully.

CJ Stringer

From: MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com> [mailto:MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com>] On Behalf Of shakti biswal
Sent: Wednesday, February 01, 2012 3:41 AM
To: MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com>
Subject: Re: [MAXIMO List] Modify a field's value by changing value of another field



Thanks Chad for your reply.

We're running Maximo V7.1.1. In this case I'm trying to check "Disabled" field when I select the "Status" as D. Or if I try to disable the record by checking "Disabled" field as true, can I set the status value to D.

How can I invoke an event that sets the value of a field when I try setting Status value to D? Is this possible without validation logic?

-Shakti

________________________________
From: Chad Stringer <cstringer@practive-inc.com<mailto:cstringer%40practive-inc.com><mailto:cstringer%40practive-inc.com>>
To: "MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com><mailto:MAXIMO%40yahoogroups.com>" <MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com><mailto:MAXIMO%40yahoogroups.com>>
Sent: Tuesday, 31 January 2012 7:07 PM
Subject: RE: [MAXIMO List] Modify a field's value by changing value of another field


What version of Maximo are you running?

In Maximo 7 you can use conditional expressions against the domain value list to only show the desired values once another value is true. We use this functionality quite often.

CJ Stringer

From: MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com><mailto:MAXIMO%40yahoogroups.com> [mailto:MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com><mailto:MAXIMO%40yahoogroups.com>] On Behalf Of shakti biswal
Sent: Tuesday, January 31, 2012 12:07 AM
To: MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com><mailto:MAXIMO%40yahoogroups.com>
Subject: [MAXIMO List] Modify a field's value by changing value of another field

Hi,

I know this can be done using validation classes. Is there a way to do so just by configuring maximo and not by java coding?

Say, a field named "Status" can take values A/B/C/D. Another field is a checkbox named "Disabled". The condition is when I set the Status field to D, it should check the Disabled field. Can we do this by condition UI?

There is another not so elegant solution by executing an escalation that periodically checks for records with Status D and sets the Disabled field.

Thanks in advance.

Regards,
Shakti











From: Chad Stringer (2012-02-01 12:29)

I'd have to look into this more, but anything is POSSIBLE. You would need a valuelist (DOMAIN) that labor reporting used to poll versus the users craft, which would need to be verified through the conditional expression. I haven't tried to limit that way before. We have done our labor reporting queries based on defaulting to the user.

CJ Stringer

From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Bairrington, Jarrell
Sent: Wednesday, February 01, 2012 9:57 AM
To: MAXIMO@yahoogroups.com
Subject: RE: [MAXIMO List] Modify a field's value by changing value of another field



Could this be used to limit the choice work order numbers available to a person or craft when entering time in labor reporting?

__________________________________________________________
Jerry Bairrington│Business Applications Analyst II│CS Operations Support│USAA


From: MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com> [mailto:MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com>] On Behalf Of Chad Stringer
Sent: Wednesday, February 01, 2012 8:34 AM
To: MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com>
Subject: RE: [MAXIMO List] Modify a field's value by changing value of another field



First you need to figure out which field you want to limit the other. They can't both limit each other.

If you want to check the 'Disabled' field, and have the only valid status be 'D', you set a conditional expression where the where clause is that the disabled field = 1, then, in the domain value list for the statuses, you have set the D value as the only valid field when that condition is true by using the View/Modify conditions, then adding the desired condition to the value you need.
Now, you need to verify the functionality is correct in a dev environment first. You have to be very careful that you get your where clauses correct, or when the conditions are not met, you may get some odd results.

Test this thoroughly before you implement, but I do this in a lot of cases. We have used this practice to limit crafts available for different work types. Functions very successfully.

CJ Stringer

From: MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com><mailto:MAXIMO%40yahoogroups.com> [mailto:MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com><mailto:MAXIMO%40yahoogroups.com>] On Behalf Of shakti biswal
Sent: Wednesday, February 01, 2012 3:41 AM
To: MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com><mailto:MAXIMO%40yahoogroups.com>
Subject: Re: [MAXIMO List] Modify a field's value by changing value of another field



Thanks Chad for your reply.

We're running Maximo V7.1.1. In this case I'm trying to check "Disabled" field when I select the "Status" as D. Or if I try to disable the record by checking "Disabled" field as true, can I set the status value to D.

How can I invoke an event that sets the value of a field when I try setting Status value to D? Is this possible without validation logic?

-Shakti

________________________________
From: Chad Stringer <cstringer@practive-inc.com<mailto:cstringer%40practive-inc.com><mailto:cstringer%40practive-inc.com><mailto:cstringer%40practive-inc.com>>
To: "MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com><mailto:MAXIMO%40yahoogroups.com><mailto:MAXIMO%40yahoogroups.com>" <MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com><mailto:MAXIMO%40yahoogroups.com><mailto:MAXIMO%40yahoogroups.com>>
Sent: Tuesday, 31 January 2012 7:07 PM
Subject: RE: [MAXIMO List] Modify a field's value by changing value of another field


What version of Maximo are you running?

In Maximo 7 you can use conditional expressions against the domain value list to only show the desired values once another value is true. We use this functionality quite often.

CJ Stringer

From: MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com><mailto:MAXIMO%40yahoogroups.com><mailto:MAXIMO%40yahoogroups.com> [mailto:MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com><mailto:MAXIMO%40yahoogroups.com><mailto:MAXIMO%40yahoogroups.com>] On Behalf Of shakti biswal
Sent: Tuesday, January 31, 2012 12:07 AM
To: MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com><mailto:MAXIMO%40yahoogroups.com><mailto:MAXIMO%40yahoogroups.com>
Subject: [MAXIMO List] Modify a field's value by changing value of another field

Hi,

I know this can be done using validation classes. Is there a way to do so just by configuring maximo and not by java coding?

Say, a field named "Status" can take values A/B/C/D. Another field is a checkbox named "Disabled". The condition is when I set the Status field to D, it should check the Disabled field. Can we do this by condition UI?

There is another not so elegant solution by executing an escalation that periodically checks for records with Status D and sets the Disabled field.

Thanks in advance.

Regards,
Shakti