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 guys: anyone know if you can get a color alert on a Result Set to trigger based on sysdate, i.e. if SCHEDSTART <= SYSDATE, change color?
So far it's not working, although it's not giving an error either.
TIA
Shannon
I have tried this as well with no luck.. Did some reading and from what I
can tell it has to be a hard coded date/time..
Shannon Sutton
CMMS Specialist
EAM/IBM-Tivoli Maximo
EMCOR Government Services
Office: 571-403-8940
Cell: 571-970-7965
From: "shannonrotz" <shannonrotz@yahoo.ca>
To: MAXIMO@yahoogroups.com
Date: 07/11/2012 03:34 PM
Subject: [MAXIMO List] Color Alerts - Result Sets - V7.5
Sent by: MAXIMO@yahoogroups.com
Hi guys: anyone know if you can get a color alert on a Result Set to
trigger based on sysdate, i.e. if SCHEDSTART <= SYSDATE, change color?
So far it's not working, although it's not giving an error either.
TIA
Shannon
This message is for the named person's use only. It may contain confidential,
proprietary or legally privileged information. No confidentiality or privilege
is waived or lost by any mistransmission. If you receive this message in error,
please immediately delete it and all copies of it from your system, destroy any
hard copies of it and notify the sender. You must not, directly or indirectly,
use, disclose, distribute, print, or copy any part of this message if you are
not the intended recipient.
I specifically asked IBM at Pulse and they said the expression value is only a value, calculations and/or SQL expression are not supported at this time.
They commented that the KPI module should be used for that type of functionality.
--- In MAXIMO@yahoogroups.com, Shannon Sutton <ssutton@...> wrote:
>
> I have tried this as well with no luck.. Did some reading and from what I
> can tell it has to be a hard coded date/time..
>
>
>
> Shannon Sutton
> CMMS Specialist
> EAM/IBM-Tivoli Maximo
> EMCOR Government Services
> Office: 571-403-8940
> Cell: 571-970-7965
>
>
>
>
> From: "shannonrotz" <shannonrotz@...>
> To: MAXIMO@yahoogroups.com
> Date: 07/11/2012 03:34 PM
> Subject: [MAXIMO List] Color Alerts - Result Sets - V7.5
> Sent by: MAXIMO@yahoogroups.com
>
>
>
>
>
>
> Hi guys: anyone know if you can get a color alert on a Result Set to
> trigger based on sysdate, i.e. if SCHEDSTART <= SYSDATE, change color?
>
> So far it's not working, although it's not giving an error either.
>
> TIA
>
> Shannon
>
>
>
>
> This message is for the named person's use only. It may contain confidential,
> proprietary or legally privileged information. No confidentiality or privilege
> is waived or lost by any mistransmission. If you receive this message in error,
> please immediately delete it and all copies of it from your system, destroy any
> hard copies of it and notify the sender. You must not, directly or indirectly,
> use, disclose, distribute, print, or copy any part of this message if you are
> not the intended recipient.
>
Downer! Well, there goes that idea.
I'll figure something else out.
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of
Jason Verly
Sent: July-11-12 3:06 PM
To: MAXIMO@yahoogroups.com
Subject: Re: [MAXIMO List] Color Alerts - Result Sets - V7.5
I specifically asked IBM at Pulse and they said the expression value is only
a value, calculations and/or SQL expression are not supported at this time.
They commented that the KPI module should be used for that type of
functionality.
--- In MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> , Shannon
Sutton <ssutton@...> wrote:
>
> I have tried this as well with no luck.. Did some reading and from what I
> can tell it has to be a hard coded date/time..
>
>
>
> Shannon Sutton
> CMMS Specialist
> EAM/IBM-Tivoli Maximo
> EMCOR Government Services
> Office: 571-403-8940
> Cell: 571-970-7965
>
>
>
>
> From: "shannonrotz" <shannonrotz@...>
> To: MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com>
> Date: 07/11/2012 03:34 PM
> Subject: [MAXIMO List] Color Alerts - Result Sets - V7.5
> Sent by: MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com>
>
>
>
>
>
>
> Hi guys: anyone know if you can get a color alert on a Result Set to
> trigger based on sysdate, i.e. if SCHEDSTART <= SYSDATE, change color?
>
> So far it's not working, although it's not giving an error either.
>
> TIA
>
> Shannon
>
>
>
>
> This message is for the named person's use only. It may contain
confidential,
> proprietary or legally privileged information. No confidentiality or
privilege
> is waived or lost by any mistransmission. If you receive this message in
error,
> please immediately delete it and all copies of it from your system,
destroy any
> hard copies of it and notify the sender. You must not, directly or
indirectly,
> use, disclose, distribute, print, or copy any part of this message if you
are
> not the intended recipient.
>
Shannon,
We use a product call TRM Rules Manager to perform such actions. Its a plug in type application that allows you to create rules to enhance Maximo's capablities where the out of the box functionality is missing or not flexible enough.
Ron
--- On Wed, 7/11/12, shannonrotz <shannonrotz@yahoo.ca> wrote:
From: shannonrotz <shannonrotz@yahoo.ca>
Subject: [MAXIMO List] Color Alerts - Result Sets - V7.5
To: MAXIMO@yahoogroups.com
Date: Wednesday, July 11, 2012, 3:34 PM
Hi guys: anyone know if you can get a color alert on a Result Set to trigger based on sysdate, i.e. if SCHEDSTART <= SYSDATE, change color?
So far it's not working, although it's not giving an error either.
TIA
Shannon
------------------------------------
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/MAXIMOYahoo! Groups Links
You could use a view which returns a number and put the views field in the result set
The view must have the same keys as the parent record + a
Rowstamp. The new field name must exist in the parent object as well as the view they must be the same types length etc.
A relationship is needed between parent and child
This article tells you how to add a Dot Notation/Joined Attribute to your result set
http://www-01.ibm.com/support/docview.wss?uid=swg21415976
Rgds Ian
--- In MAXIMO@yahoogroups.com, "shannonrotz" <shannonrotz@...> wrote:
>
> Hi guys: anyone know if you can get a color alert on a Result Set to trigger based on sysdate, i.e. if SCHEDSTART <= SYSDATE, change color?
>
> So far it's not working, although it's not giving an error either.
>
> TIA
>
>
>
> Shannon
>
Thanks Ian! Much appreciated.
Shannon
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of
ian_wright12000
Sent: July-18-12 9:03 AM
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] Re: Color Alerts - Result Sets - V7.5
You could use a view which returns a number and put the views field in the
result set
The view must have the same keys as the parent record + a
Rowstamp. The new field name must exist in the parent object as well as the
view they must be the same types length etc.
A relationship is needed between parent and child
This article tells you how to add a Dot Notation/Joined Attribute to your
result set
http://www-01.ibm.com/support/docview.wss?uid=swg21415976
Rgds Ian
--- In MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> ,
"shannonrotz" <shannonrotz@...> wrote:
>
> Hi guys: anyone know if you can get a color alert on a Result Set to
trigger based on sysdate, i.e. if SCHEDSTART <= SYSDATE, change color?
>
> So far it's not working, although it's not giving an error either.
>
> TIA
>
>
>
> Shannon
>