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.
Folks,
I have changed the QUERY Objcet into a MAIN OBJECT so it now shows in my ACTIONS application as an Object. I want to creatre an Escalation that would change a Saved Query on a weekly basis so the users did not have to manually change the query each week to new dates.
Does anyone know if this will work or am I wasting my time?
I basically plan to set the CLAUSE column to a new value each week with new date values. Trying to figure out the the SQL Expression Builder now and not having much luck.
Trying to first create my ACTION then will do the ESCALATION. But not past the ACTION yet.
Any help? Using Maximo 6.2.3.
Thanks,
Miller
Hi,
Have you explored all the options for a query that does not need to be changes.
Maybe if you provide more details we can figure out a way to do that?
For instance you can use getdate() in SQL to get the current date and go back or forward.
So a query like
select * from workorder where reportdate >= getdate()-7
will always get the past seven days of work orders from the instant a person uses the query. There are other ways to manipulate dates for queries so you can always use the same query.
Dave Bone
--- In MAXIMO@yahoogroups.com, "David M" <david_miller_33139@...> wrote:
>
> Folks,
>
> I have changed the QUERY Objcet into a MAIN OBJECT so it now shows in my ACTIONS application as an Object. I want to creatre an Escalation that would change a Saved Query on a weekly basis so the users did not have to manually change the query each week to new dates.
>
> Does anyone know if this will work or am I wasting my time?
>
> I basically plan to set the CLAUSE column to a new value each week with new date values. Trying to figure out the the SQL Expression Builder now and not having much luck.
>
> Trying to first create my ACTION then will do the ESCALATION. But not past the ACTION yet.
>
> Any help? Using Maximo 6.2.3.
>
> Thanks,
> Miller
>
Your best bet is to create a stored procedure set to run on a scheduled basis.
--- On Fri, 9/9/11, David M <david_miller_33139@yahoo.com> wrote:
From: David M <david_miller_33139@yahoo.com>
Subject: [MAXIMO List] MXES Escalation on the QUERY Object
To: MAXIMO@yahoogroups.com
Date: Friday, September 9, 2011, 1:25 PM
Folks,
I have changed the QUERY Objcet into a MAIN OBJECT so it now shows in my ACTIONS application as an Object. I want to creatre an Escalation that would change a Saved Query on a weekly basis so the users did not have to manually change the query each week to new dates.
Does anyone know if this will work or am I wasting my time?
I basically plan to set the CLAUSE column to a new value each week with new date values. Trying to figure out the the SQL Expression Builder now and not having much luck.
Trying to first create my ACTION then will do the ESCALATION. But not past the ACTION yet.
Any help? Using Maximo 6.2.3.
Thanks,
Miller
You may be trying to make this too difficult. Is your desire to look at a
specific date range?
I have created one that looks for any date between the current date - 7 days
and the current date.
DB2: where enterdate between current timestamp and current timstamp - 7
days. Another way is the timestampdiff function (DB2).
On Fri, Sep 9, 2011 at 3:30 PM, Bill Mclain <bdmclain@yahoo.com> wrote:
> **
>
>
> Your best bet is to create a stored procedure set to run on a scheduled
> basis.
>
> --- On Fri, 9/9/11, David M <david_miller_33139@yahoo.com> wrote:
>
> From: David M <david_miller_33139@yahoo.com>
> Subject: [MAXIMO List] MXES Escalation on the QUERY Object
> To: MAXIMO@yahoogroups.com
> Date: Friday, September 9, 2011, 1:25 PM
>
>
>
>
> Folks,
>
> I have changed the QUERY Objcet into a MAIN OBJECT so it now shows in my
> ACTIONS application as an Object. I want to creatre an Escalation that would
> change a Saved Query on a weekly basis so the users did not have to manually
> change the query each week to new dates.
>
> Does anyone know if this will work or am I wasting my time?
>
> I basically plan to set the CLAUSE column to a new value each week with new
> date values. Trying to figure out the the SQL Expression Builder now and not
> having much luck.
>
> Trying to first create my ACTION then will do the ESCALATION. But not past
> the ACTION yet.
>
> Any help? Using Maximo 6.2.3.
>
> Thanks,
> Miller
>
>
>
>
>
--
In a country well governed, poverty is something to be ashamed of.
In a country badly governed, wealth is something to be ashamed of.
Confucius
Thnak you for all the suggestions. I am still trying to get requirmnets out of my users and they are not clear on what they need just yet.
I will look into both suggestions once i have better guidance.
Miller
--- In MAXIMO@yahoogroups.com, "Paul E. Miller, Jr." <paul-jr@...> wrote:
>
> You may be trying to make this too difficult. Is your desire to look at a
> specific date range?
>
> I have created one that looks for any date between the current date - 7 days
> and the current date.
>
> DB2: where enterdate between current timestamp and current timstamp - 7
> days. Another way is the timestampdiff function (DB2).
>
>
>
> On Fri, Sep 9, 2011 at 3:30 PM, Bill Mclain <bdmclain@...> wrote:
>
> > **
> >
> >
> > Your best bet is to create a stored procedure set to run on a scheduled
> > basis.
> >
> > --- On Fri, 9/9/11, David M <david_miller_33139@...> wrote:
> >
> > From: David M <david_miller_33139@...>
> > Subject: [MAXIMO List] MXES Escalation on the QUERY Object
> > To: MAXIMO@yahoogroups.com
> > Date: Friday, September 9, 2011, 1:25 PM
> >
> >
> >
> >
> > Folks,
> >
> > I have changed the QUERY Objcet into a MAIN OBJECT so it now shows in my
> > ACTIONS application as an Object. I want to creatre an Escalation that would
> > change a Saved Query on a weekly basis so the users did not have to manually
> > change the query each week to new dates.
> >
> > Does anyone know if this will work or am I wasting my time?
> >
> > I basically plan to set the CLAUSE column to a new value each week with new
> > date values. Trying to figure out the the SQL Expression Builder now and not
> > having much luck.
> >
> > Trying to first create my ACTION then will do the ESCALATION. But not past
> > the ACTION yet.
> >
> > Any help? Using Maximo 6.2.3.
> >
> > Thanks,
> > Miller
> >
> >
> >
> >
> >
>
>
>
> --
> In a country well governed, poverty is something to be ashamed of.
> In a country badly governed, wealth is something to be ashamed of.
> Confucius
>
>
>
>