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.
Hello,
Maximo 6.2.3, Oracle DB
I would like to set up a public saved query either in W/O Tracking or Quick Reporting that would return all work ordered by priority for the particular user that is logged in. I want it to find the work by looking at the Work Group (person group) and seeing if the logged in user is part of that person group. All userids and personids should be the same, so that shouldn't be an issue. Ultimately, I would like to put this on a Result Set on the user's start center so that the worker can see their schedule from the start center.
I am familiar with dynamic querying (i.e. using :USER), but I have not found a way to use the dynamic query while trying to look up information in another table.
Any advice you could give would be helpful.
This is from memory, Haven't worked with WORKORDER for a while, you may
need to verify the column names.
where persongroup in (select persongroup from persongroupteam where
(respparty = :USER or resppartygroup = :USER) )
and status in (....) etc.
You could also use the synonym domain for statuses.
On Wed, Jan 25, 2012 at 10:58 AM, Lauren <ldoucette@gatech.edu> wrote:
> **
>
>
> Hello,
>
> Maximo 6.2.3, Oracle DB
>
> I would like to set up a public saved query either in W/O Tracking or
> Quick Reporting that would return all work ordered by priority for the
> particular user that is logged in. I want it to find the work by looking at
> the Work Group (person group) and seeing if the logged in user is part of
> that person group. All userids and personids should be the same, so that
> shouldn't be an issue. Ultimately, I would like to put this on a Result Set
> on the user's start center so that the worker can see their schedule from
> the start center.
>
> I am familiar with dynamic querying (i.e. using :USER), but I have not
> found a way to use the dynamic query while trying to look up information in
> another table.
>
> Any advice you could give would be helpful.
>
>
>
--
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
Going from memory (with a quick check), you want the following - or
something like it:
Historyflag = 0 and istask = 0 and persongroup in (select persongroup from
persongroupteam where respparty = :user )
You probably know this, but when you set this up as a Saved Query, Maximo
will (annoyingly) substitute your user ID for :user, so you need to change
it back to ":user" if you want it to work for others.
Shannon
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of
Lauren
Sent: January-25-12 9:58 AM
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] Result Set Query to query work order using logged in
person ID and Person Group
Hello,
Maximo 6.2.3, Oracle DB
I would like to set up a public saved query either in W/O Tracking or Quick
Reporting that would return all work ordered by priority for the particular
user that is logged in. I want it to find the work by looking at the Work
Group (person group) and seeing if the logged in user is part of that person
group. All userids and personids should be the same, so that shouldn't be an
issue. Ultimately, I would like to put this on a Result Set on the user's
start center so that the worker can see their schedule from the start
center.
I am familiar with dynamic querying (i.e. using :USER), but I have not found
a way to use the dynamic query while trying to look up information in
another table.
Any advice you could give would be helpful.
This is what I use -- it's kind of overkill, but it will show EVERYTHING that involves that person--if that person is:
SUPERVISOR
LEAD
in the WORKGROUP
an alternate in the WORKGROUP
OWNER
in the OWNERGROUP
an alternate in the OWNERGROUP
**does not include CREW at this point**
It also excludes CAN, COMP, and CLOSE work orders and any synonyms of those. Here you go:
historyflag =0 and (owner in (select personid from maxuser where upper(loginid) = upper(:USER) or upper(userid) = upper(:USER)) or ownergroup in (select persongroup from persongroupteam where resppartygroup in (select personid from maxuser where upper(loginid) = upper(:USER) or upper(userid) = upper(:USER)) or respparty in (select personid from maxuser where upper(loginid) = upper(:USER) or upper(userid) = upper(:USER))) or lead in (select personid from maxuser where upper(loginid) = upper(:USER) or upper(userid) = upper(:USER)) or supervisor in (select personid from maxuser where upper(loginid) = upper(:USER) or upper(userid) = upper(:USER)) or persongroup in (select persongroup from persongroupteam where resppartygroup in (select personid from maxuser where upper(loginid) = upper(:USER) or upper(userid) = upper(:USER)) or respparty in (select personid from maxuser where upper(loginid) = upper(:USER) or upper(userid) = upper(:USER)))) and status in (select value from synonymdomain where domainid = 'WOSTATUS' and maxvalue not in ('CAN', 'COMP', 'CLOSE'))
Travis Herron
--- In MAXIMO@yahoogroups.com, "Shannon Rotz" <shannonrotz@...> wrote:
>
> Going from memory (with a quick check), you want the following - or
> something like it:
>
>
>
> Historyflag = 0 and istask = 0 and persongroup in (select persongroup from
> persongroupteam where respparty = :user )
>
>
>
> You probably know this, but when you set this up as a Saved Query, Maximo
> will (annoyingly) substitute your user ID for :user, so you need to change
> it back to ":user" if you want it to work for others.
>
>
>
>
>
>
>
>
>
> Shannon
>
>
>
> From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of
> Lauren
> Sent: January-25-12 9:58 AM
> To: MAXIMO@yahoogroups.com
> Subject: [MAXIMO List] Result Set Query to query work order using logged in
> person ID and Person Group
>
>
>
>
>
> Hello,
>
> Maximo 6.2.3, Oracle DB
>
> I would like to set up a public saved query either in W/O Tracking or Quick
> Reporting that would return all work ordered by priority for the particular
> user that is logged in. I want it to find the work by looking at the Work
> Group (person group) and seeing if the logged in user is part of that person
> group. All userids and personids should be the same, so that shouldn't be an
> issue. Ultimately, I would like to put this on a Result Set on the user's
> start center so that the worker can see their schedule from the start
> center.
>
> I am familiar with dynamic querying (i.e. using :USER), but I have not found
> a way to use the dynamic query while trying to look up information in
> another table.
>
> Any advice you could give would be helpful.
>
>
>
>
>
>
>
Thanks for the replies - this is exactly what I needed. The "(select persongroup from persongroupteam where(respparty = :USER or resppartygroup = :USER) " was the part I was after.
Thanks again! Off to create the query and test it.
--- In MAXIMO@yahoogroups.com, "Lauren" <ldoucette@...> wrote:
>
> Hello,
>
> Maximo 6.2.3, Oracle DB
>
> I would like to set up a public saved query either in W/O Tracking or Quick Reporting that would return all work ordered by priority for the particular user that is logged in. I want it to find the work by looking at the Work Group (person group) and seeing if the logged in user is part of that person group. All userids and personids should be the same, so that shouldn't be an issue. Ultimately, I would like to put this on a Result Set on the user's start center so that the worker can see their schedule from the start center.
>
> I am familiar with dynamic querying (i.e. using :USER), but I have not found a way to use the dynamic query while trying to look up information in another table.
>
> Any advice you could give would be helpful.
>
One other quick point of note - make sure that after you test and save this query that you go into the view/manage query function and change any user reference back to the variable :USER. If not - it will only save the result set 'where clause' with what it 'found' when you ran the query (it will swap your variable with the userid that was run at the time of the query). If you don't do this - the saved query will just be the value that was pulled at the time the query was first run so it will not be a 'dynamic' query that all users can use.
Hope this helps!
--- In MAXIMO@yahoogroups.com, "Lauren" <ldoucette@...> wrote:
>
> Thanks for the replies - this is exactly what I needed. The "(select persongroup from persongroupteam where(respparty = :USER or resppartygroup = :USER) " was the part I was after.
>
> Thanks again! Off to create the query and test it.
>
> --- In MAXIMO@yahoogroups.com, "Lauren" <ldoucette@> wrote:
> >
> > Hello,
> >
> > Maximo 6.2.3, Oracle DB
> >
> > I would like to set up a public saved query either in W/O Tracking or Quick Reporting that would return all work ordered by priority for the particular user that is logged in. I want it to find the work by looking at the Work Group (person group) and seeing if the logged in user is part of that person group. All userids and personids should be the same, so that shouldn't be an issue. Ultimately, I would like to put this on a Result Set on the user's start center so that the worker can see their schedule from the start center.
> >
> > I am familiar with dynamic querying (i.e. using :USER), but I have not found a way to use the dynamic query while trying to look up information in another table.
> >
> > Any advice you could give would be helpful.
> >
>
Helps tremendously - and one step ahead of you! Thanks!
--- In MAXIMO@yahoogroups.com, "john_gould14" <john_gould14@...> wrote:
>
> One other quick point of note - make sure that after you test and save this query that you go into the view/manage query function and change any user reference back to the variable :USER. If not - it will only save the result set 'where clause' with what it 'found' when you ran the query (it will swap your variable with the userid that was run at the time of the query). If you don't do this - the saved query will just be the value that was pulled at the time the query was first run so it will not be a 'dynamic' query that all users can use.
>
> Hope this helps!
>
> --- In MAXIMO@yahoogroups.com, "Lauren" <ldoucette@> wrote:
> >
> > Thanks for the replies - this is exactly what I needed. The "(select persongroup from persongroupteam where(respparty = :USER or resppartygroup = :USER) " was the part I was after.
> >
> > Thanks again! Off to create the query and test it.
> >
> > --- In MAXIMO@yahoogroups.com, "Lauren" <ldoucette@> wrote:
> > >
> > > Hello,
> > >
> > > Maximo 6.2.3, Oracle DB
> > >
> > > I would like to set up a public saved query either in W/O Tracking or Quick Reporting that would return all work ordered by priority for the particular user that is logged in. I want it to find the work by looking at the Work Group (person group) and seeing if the logged in user is part of that person group. All userids and personids should be the same, so that shouldn't be an issue. Ultimately, I would like to put this on a Result Set on the user's start center so that the worker can see their schedule from the start center.
> > >
> > > I am familiar with dynamic querying (i.e. using :USER), but I have not found a way to use the dynamic query while trying to look up information in another table.
> > >
> > > Any advice you could give would be helpful.
> > >
> >
>