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.
My users want to hide the new 7.5 status values (broken, etc...) for locations and assets (sigh). I've set up a conditional a expression based on a signature option and associated to the domain, and that works great, for the list in the change status dialog.
Problem now is, the new status values are still showing up in the list on the advanced search screen. Anyone have any thoughts on how to hide them there as well?
The where clause for my conditional expression is listed below:
(EXISTS (
SELECT 1
FROM maximo.applicationauth aa
INNER JOIN maximo.groupuser gu
ON gu.groupname = aa.groupname
WHERE aa.app= :&APPNAME&
AND aa.optionname = 'NEWSTATUS'
AND gu.userid = :&USERNAME&))
Chris A Hanna, CTR
Application Programmer
Digital Management Inc.
US Coast Guard Operations Systems Center
christopher.a.hanna@uscg.mil
(304)433-3234
You may want to try:
In Application Designer for the application open the Adavanced Search Dialog. Check the status field there and get your condition applied there.
Hope this helps,
Andy
--- In MAXIMO@yahoogroups.com, "Hanna, Christopher CTR" <christopher.a.hanna@...> wrote:
>
> My users want to hide the new 7.5 status values (broken, etc...) for locations and assets (sigh). I've set up a conditional a expression based on a signature option and associated to the domain, and that works great, for the list in the change status dialog.
>
> Problem now is, the new status values are still showing up in the list on the advanced search screen. Anyone have any thoughts on how to hide them there as well?
>
> The where clause for my conditional expression is listed below:
>
> (EXISTS (
> SELECT 1
> FROM maximo.applicationauth aa
> INNER JOIN maximo.groupuser gu
> ON gu.groupname = aa.groupname
> WHERE aa.app= :&APPNAME&
> AND aa.optionname = 'NEWSTATUS'
> AND gu.userid = :&USERNAME&))
>
> Chris A Hanna, CTR
> Application Programmer
> Digital Management Inc.
> US Coast Guard Operations Systems Center
> christopher.a.hanna@...
> (304)433-3234
>
Wouldn't that hide the field and not the specific statuses in the list?
-----Original Message-----
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of andrew.tess
Sent: Tuesday, October 30, 2012 12:32 PM
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] Re: Hide status values
You may want to try:
In Application Designer for the application open the Adavanced Search Dialog. Check the status field there and get your condition applied there.
Hope this helps,
Andy
--- In MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> , "Hanna, Christopher CTR" <christopher.a.hanna@...> wrote:
>
> My users want to hide the new 7.5 status values (broken, etc...) for locations and assets (sigh). I've set up a conditional a expression based on a signature option and associated to the domain, and that works great, for the list in the change status dialog.
>
> Problem now is, the new status values are still showing up in the list on the advanced search screen. Anyone have any thoughts on how to hide them there as well?
>
> The where clause for my conditional expression is listed below:
>
> (EXISTS (
> SELECT 1
> FROM maximo.applicationauth aa
> INNER JOIN maximo.groupuser gu
> ON gu.groupname = aa.groupname
> WHERE aa.app= :&APPNAME&
> AND aa.optionname = 'NEWSTATUS'
> AND gu.userid = :&USERNAME&))
>
> Chris A Hanna, CTR
> Application Programmer
> Digital Management Inc.
> US Coast Guard Operations Systems Center christopher.a.hanna@...
> (304)433-3234
>
If you want to hide these locations and assets why not use an application
level restriction?
Chris.
On Tue, Oct 30, 2012 at 1:21 PM, Hanna, Christopher CTR <
christopher.a.hanna@uscg.mil> wrote:
> **
>
>
> Wouldn't that hide the field and not the specific statuses in the list?
>
>
> -----Original Message-----
> From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of
> andrew.tess
> Sent: Tuesday, October 30, 2012 12:32 PM
> To: MAXIMO@yahoogroups.com
> Subject: [MAXIMO List] Re: Hide status values
>
> You may want to try:
> In Application Designer for the application open the Adavanced Search
> Dialog. Check the status field there and get your condition applied there.
> Hope this helps,
> Andy
>
> --- In MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> , "Hanna,
> Christopher CTR" <christopher.a.hanna@...> wrote:
> >
> > My users want to hide the new 7.5 status values (broken, etc...) for
> locations and assets (sigh). I've set up a conditional a expression based
> on a signature option and associated to the domain, and that works great,
> for the list in the change status dialog.
> >
> > Problem now is, the new status values are still showing up in the list
> on the advanced search screen. Anyone have any thoughts on how to hide them
> there as well?
> >
> > The where clause for my conditional expression is listed below:
> >
> > (EXISTS (
> > SELECT 1
> > FROM maximo.applicationauth aa
> > INNER JOIN maximo.groupuser gu
> > ON gu.groupname = aa.groupname
> > WHERE aa.app= :&APPNAME&
> > AND aa.optionname = 'NEWSTATUS'
> > AND gu.userid = :&USERNAME&))
> >
> > Chris A Hanna, CTR
> > Application Programmer
> > Digital Management Inc.
> > US Coast Guard Operations Systems Center christopher.a.hanna@...
> > (304)433-3234
> >
>
>
>
Try using a Data Restriction? Don't think Search allows for filtering as it would still be possible for a value to exist.
--- Sean Clark-McCarthy
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Hanna, Christopher CTR
Sent: Tuesday, October 30, 2012 1:21 PM
To: MAXIMO@yahoogroups.com
Subject: RE: [MAXIMO List] Re: Hide status values
Wouldn't that hide the field and not the specific statuses in the list?
-----Original Message-----
From: MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com> [mailto:MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com>] On Behalf Of andrew.tess
Sent: Tuesday, October 30, 2012 12:32 PM
To: MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com>
Subject: [MAXIMO List] Re: Hide status values
You may want to try:
In Application Designer for the application open the Adavanced Search Dialog. Check the status field there and get your condition applied there.
Hope this helps,
Andy
--- In MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com> <mailto:MAXIMO%40yahoogroups.com> , "Hanna, Christopher CTR" <christopher.a.hanna@...<mailto:christopher.a.hanna@...>> wrote:
>
> My users want to hide the new 7.5 status values (broken, etc...) for locations and assets (sigh). I've set up a conditional a expression based on a signature option and associated to the domain, and that works great, for the list in the change status dialog.
>
> Problem now is, the new status values are still showing up in the list on the advanced search screen. Anyone have any thoughts on how to hide them there as well?
>
> The where clause for my conditional expression is listed below:
>
> (EXISTS (
> SELECT 1
> FROM maximo.applicationauth aa
> INNER JOIN maximo.groupuser gu
> ON gu.groupname = aa.groupname
> WHERE aa.app= :&APPNAME&
> AND aa.optionname = 'NEWSTATUS'
> AND gu.userid = :&USERNAME&))
>
> Chris A Hanna, CTR
> Application Programmer
> Digital Management Inc.
> US Coast Guard Operations Systems Center christopher.a.hanna@<mailto:christopher.a.hanna@>...
> (304)433-3234
>
In the domain if you want to switch off any usage of a status give it the condition 1=2
It should not appear even in a search value list
I think - will test tomorrow:-)
Brian Scott
Service Management Connect
Sent from my iPad
On 30 Oct 2012, at 18:22, Sean Clark-McCarthy <smccarthy@cohesivesolutions.com> wrote:
> Try using a Data Restriction? Don't think Search allows for filtering as it would still be possible for a value to exist.
>
> --- Sean Clark-McCarthy
>
> From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Hanna, Christopher CTR
> Sent: Tuesday, October 30, 2012 1:21 PM
> To: MAXIMO@yahoogroups.com
> Subject: RE: [MAXIMO List] Re: Hide status values
>
> Wouldn't that hide the field and not the specific statuses in the list?
>
> -----Original Message-----
> From: MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com> [mailto:MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com>] On Behalf Of andrew.tess
> Sent: Tuesday, October 30, 2012 12:32 PM
> To: MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com>
> Subject: [MAXIMO List] Re: Hide status values
>
> You may want to try:
> In Application Designer for the application open the Adavanced Search Dialog. Check the status field there and get your condition applied there.
> Hope this helps,
> Andy
>
> --- In MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com> <mailto:MAXIMO%40yahoogroups.com> , "Hanna, Christopher CTR" <christopher.a.hanna@...<mailto:christopher.a.hanna@...>> wrote:
> >
> > My users want to hide the new 7.5 status values (broken, etc...) for locations and assets (sigh). I've set up a conditional a expression based on a signature option and associated to the domain, and that works great, for the list in the change status dialog.
> >
> > Problem now is, the new status values are still showing up in the list on the advanced search screen. Anyone have any thoughts on how to hide them there as well?
> >
> > The where clause for my conditional expression is listed below:
> >
> > (EXISTS (
> > SELECT 1
> > FROM maximo.applicationauth aa
> > INNER JOIN maximo.groupuser gu
> > ON gu.groupname = aa.groupname
> > WHERE aa.app= :&APPNAME&
> > AND aa.optionname = 'NEWSTATUS'
> > AND gu.userid = :&USERNAME&))
> >
> > Chris A Hanna, CTR
> > Application Programmer
> > Digital Management Inc.
> > US Coast Guard Operations Systems Center christopher.a.hanna@<mailto:christopher.a.hanna@>...
> > (304)433-3234
> >
>
>
>
>
Hi
I guess what Brian has suggested works well in the application except on
list tab.
You may use Global data restriction on related tables if this restriction
applies to all users including list tab.
Amit
On Wed, Oct 31, 2012 at 12:18 AM, Brian Scott <bpscotty@yahoo.co.uk> wrote:
> In the domain if you want to switch off any usage of a status give it the
> condition 1=2
>
> It should not appear even in a search value list
>
> I think - will test tomorrow:-)
>
> Brian Scott
> Service Management Connect
>
> Sent from my iPad
>
> On 30 Oct 2012, at 18:22, Sean Clark-McCarthy <
> smccarthy@cohesivesolutions.com> wrote:
>
> > Try using a Data Restriction? Don't think Search allows for filtering as
> it would still be possible for a value to exist.
> >
> > --- Sean Clark-McCarthy
> >
> > From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf
> Of Hanna, Christopher CTR
> > Sent: Tuesday, October 30, 2012 1:21 PM
> > To: MAXIMO@yahoogroups.com
> > Subject: RE: [MAXIMO List] Re: Hide status values
> >
> > Wouldn't that hide the field and not the specific statuses in the list?
> >
> > -----Original Message-----
> > From: MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com> [mailto:
> MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com>] On Behalf Of
> andrew.tess
> > Sent: Tuesday, October 30, 2012 12:32 PM
> > To: MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com>
> > Subject: [MAXIMO List] Re: Hide status values
> >
> > You may want to try:
> > In Application Designer for the application open the Adavanced Search
> Dialog. Check the status field there and get your condition applied there.
> > Hope this helps,
> > Andy
> >
> > --- In MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com> <mailto:
> MAXIMO%40yahoogroups.com> , "Hanna, Christopher CTR" <christopher.a.hanna@
> ...<mailto:christopher.a.hanna@...>> wrote:
> > >
> > > My users want to hide the new 7.5 status values (broken, etc...) for
> locations and assets (sigh). I've set up a conditional a expression based
> on a signature option and associated to the domain, and that works great,
> for the list in the change status dialog.
> > >
> > > Problem now is, the new status values are still showing up in the list
> on the advanced search screen. Anyone have any thoughts on how to hide them
> there as well?
> > >
> > > The where clause for my conditional expression is listed below:
> > >
> > > (EXISTS (
> > > SELECT 1
> > > FROM maximo.applicationauth aa
> > > INNER JOIN maximo.groupuser gu
> > > ON gu.groupname = aa.groupname
> > > WHERE aa.app= :&APPNAME&
> > > AND aa.optionname = 'NEWSTATUS'
> > > AND gu.userid = :&USERNAME&))
> > >
> > > Chris A Hanna, CTR
> > > Application Programmer
> > > Digital Management Inc.
> > > US Coast Guard Operations Systems Center christopher.a.hanna@<mailto:
> christopher.a.hanna@>...
> > > (304)433-3234
> > >
> >
> >
> >
> >
>
>
>
>
>
>
> ------------------------------------
>
> 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
>
>
>
>
Sorry, maybe I wasn't clear, not trying to hide the assets, I'm trying to hide the status values.
-----Original Message-----
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Chris Lawless
Sent: Tuesday, October 30, 2012 2:18 PM
To: MAXIMO@yahoogroups.com
Subject: Re: [MAXIMO List] Re: Hide status values
If you want to hide these locations and assets why not use an application level restriction?
Chris.
On Tue, Oct 30, 2012 at 1:21 PM, Hanna, Christopher CTR < christopher.a.hanna@uscg.mil> wrote:
> **
>
>
> Wouldn't that hide the field and not the specific statuses in the list?
>
>
> -----Original Message-----
> From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf
> Of andrew.tess
> Sent: Tuesday, October 30, 2012 12:32 PM
> To: MAXIMO@yahoogroups.com
> Subject: [MAXIMO List] Re: Hide status values
>
> You may want to try:
> In Application Designer for the application open the Adavanced Search
> Dialog. Check the status field there and get your condition applied there.
> Hope this helps,
> Andy
>
> --- In MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> ,
> "Hanna, Christopher CTR" <christopher.a.hanna@...> wrote:
> >
> > My users want to hide the new 7.5 status values (broken, etc...) for
> locations and assets (sigh). I've set up a conditional a expression
> based on a signature option and associated to the domain, and that
> works great, for the list in the change status dialog.
> >
> > Problem now is, the new status values are still showing up in the
> > list
> on the advanced search screen. Anyone have any thoughts on how to hide
> them there as well?
> >
> > The where clause for my conditional expression is listed below:
> >
> > (EXISTS (
> > SELECT 1
> > FROM maximo.applicationauth aa
> > INNER JOIN maximo.groupuser gu
> > ON gu.groupname = aa.groupname
> > WHERE aa.app= :&APPNAME&
> > AND aa.optionname = 'NEWSTATUS'
> > AND gu.userid = :&USERNAME&))
> >
> > Chris A Hanna, CTR
> > Application Programmer
> > Digital Management Inc.
> > US Coast Guard Operations Systems Center christopher.a.hanna@...
> > (304)433-3234
> >
>
>
>
------------------------------------
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
I want them shown conditionally based on a signature option, so 1=2 won't fit the bill. However I did try 1=2, just to see if the condition is even being evaluated in the list on the advanced search, and it is not.
-----Original Message-----
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Brian Scott
Sent: Tuesday, October 30, 2012 2:48 PM
To: MAXIMO@yahoogroups.com
Cc: MAXIMO@yahoogroups.com
Subject: Re: [MAXIMO List] Re: Hide status values
In the domain if you want to switch off any usage of a status give it the condition 1=2
It should not appear even in a search value list
I think - will test tomorrow:-)
Brian Scott
Service Management Connect
Sent from my iPad
On 30 Oct 2012, at 18:22, Sean Clark-McCarthy <smccarthy@cohesivesolutions.com <mailto:smccarthy%40cohesivesolutions.com> > wrote:
> Try using a Data Restriction? Don't think Search allows for filtering as it would still be possible for a value to exist.
>
> --- Sean Clark-McCarthy
>
> From: MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com>
> [mailto:MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> ] On
> Behalf Of Hanna, Christopher CTR
> Sent: Tuesday, October 30, 2012 1:21 PM
> To: MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com>
> Subject: RE: [MAXIMO List] Re: Hide status values
>
> Wouldn't that hide the field and not the specific statuses in the list?
>
> -----Original Message-----
> 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 andrew.tess
> Sent: Tuesday, October 30, 2012 12:32 PM
> To: MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com>
> <mailto:MAXIMO%40yahoogroups.com>
> Subject: [MAXIMO List] Re: Hide status values
>
> You may want to try:
> In Application Designer for the application open the Adavanced Search Dialog. Check the status field there and get your condition applied there.
> Hope this helps,
> Andy
>
> --- In MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> <mailto:MAXIMO%40yahoogroups.com> <mailto:MAXIMO%40yahoogroups.com> , "Hanna, Christopher CTR" <christopher.a.hanna@...<mailto:christopher.a.hanna@...>> wrote:
> >
> > My users want to hide the new 7.5 status values (broken, etc...) for locations and assets (sigh). I've set up a conditional a expression based on a signature option and associated to the domain, and that works great, for the list in the change status dialog.
> >
> > Problem now is, the new status values are still showing up in the list on the advanced search screen. Anyone have any thoughts on how to hide them there as well?
> >
> > The where clause for my conditional expression is listed below:
> >
> > (EXISTS (
> > SELECT 1
> > FROM maximo.applicationauth aa
> > INNER JOIN maximo.groupuser gu
> > ON gu.groupname = aa.groupname
> > WHERE aa.app= :&APPNAME&
> > AND aa.optionname = 'NEWSTATUS'
> > AND gu.userid = :&USERNAME&))
> >
> > Chris A Hanna, CTR
> > Application Programmer
> > Digital Management Inc.
> > US Coast Guard Operations Systems Center christopher.a.hanna@<mailto:christopher.a.hanna@>...
> > (304)433-3234
> >
>
>
>
>
That thought did cross my mind. We may try that if the users complain really loudly, for now were just rolling forward with the values in the list on the advanced search. They can't see any of the new values in a status change dialog so that is the important thing. Schedule constraints ya know, everything needs to be done yesterday ;)
-----Original Message-----
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Sean Clark-McCarthy
Sent: Tuesday, October 30, 2012 2:22 PM
To: MAXIMO@yahoogroups.com
Subject: RE: [MAXIMO List] Re: Hide status values
Try using a Data Restriction? Don't think Search allows for filtering as it would still be possible for a value to exist.
--- Sean Clark-McCarthy
From: MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> [mailto:MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> ] On Behalf Of Hanna, Christopher CTR
Sent: Tuesday, October 30, 2012 1:21 PM
To: MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com>
Subject: RE: [MAXIMO List] Re: Hide status values
Wouldn't that hide the field and not the specific statuses in the list?
-----Original Message-----
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 andrew.tess
Sent: Tuesday, October 30, 2012 12:32 PM
To: MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> <mailto:MAXIMO%40yahoogroups.com>
Subject: [MAXIMO List] Re: Hide status values
You may want to try:
In Application Designer for the application open the Adavanced Search Dialog. Check the status field there and get your condition applied there.
Hope this helps,
Andy
--- In MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> <mailto:MAXIMO%40yahoogroups.com> <mailto:MAXIMO%40yahoogroups.com> , "Hanna, Christopher CTR" <christopher.a.hanna@...<mailto:christopher.a.hanna@...>> wrote:
>
> My users want to hide the new 7.5 status values (broken, etc...) for locations and assets (sigh). I've set up a conditional a expression based on a signature option and associated to the domain, and that works great, for the list in the change status dialog.
>
> Problem now is, the new status values are still showing up in the list on the advanced search screen. Anyone have any thoughts on how to hide them there as well?
>
> The where clause for my conditional expression is listed below:
>
> (EXISTS (
> SELECT 1
> FROM maximo.applicationauth aa
> INNER JOIN maximo.groupuser gu
> ON gu.groupname = aa.groupname
> WHERE aa.app= :&APPNAME&
> AND aa.optionname = 'NEWSTATUS'
> AND gu.userid = :&USERNAME&))
>
> Chris A Hanna, CTR
> Application Programmer
> Digital Management Inc.
> US Coast Guard Operations Systems Center christopher.a.hanna@<mailto:christopher.a.hanna@>...
> (304)433-3234
>
Hi,
Please refer to the following URL from IBM
http://www-01.ibm.com/support/docview.wss?uid=swg21596678
Mark
________________________________
From: "Hanna, Christopher CTR" <christopher.a.hanna@uscg.mil>
To: MAXIMO@yahoogroups.com
Sent: Tuesday, October 30, 2012 10:26 PM
Subject: [MAXIMO List] Hide status values
My users want to hide the new 7.5 status values (broken, etc...) for locations and assets (sigh). I've set up a conditional a expression based on a signature option and associated to the domain, and that works great, for the list in the change status dialog.
Problem now is, the new status values are still showing up in the list on the advanced search screen. Anyone have any thoughts on how to hide them there as well?
The where clause for my conditional expression is listed below:
(EXISTS (
SELECT 1
FROM maximo.applicationauth aa
INNER JOIN maximo.groupuser gu
ON gu.groupname = aa.groupname
WHERE aa.app= :&APPNAME&
AND aa.optionname = 'NEWSTATUS'
AND gu.userid = :&USERNAME&))
Chris A Hanna, CTR
Application Programmer
Digital Management Inc.
US Coast Guard Operations Systems Center
christopher.a.hanna@uscg.mil
(304)433-3234
Which way did you say you were restricting, Chris? In SigSec or in the
domain itself?
Shannon
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of
Hanna, Christopher CTR
Sent: October-31-12 4:16 AM
To: MAXIMO@yahoogroups.com
Subject: RE: [MAXIMO List] Re: Hide status values
That thought did cross my mind. We may try that if the users complain really
loudly, for now were just rolling forward with the values in the list on the
advanced search. They can't see any of the new values in a status change
dialog so that is the important thing. Schedule constraints ya know,
everything needs to be done yesterday ;)
-----Original Message-----
From: MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com>
[mailto:MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> ] On Behalf
Of Sean Clark-McCarthy
Sent: Tuesday, October 30, 2012 2:22 PM
To: MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com>
Subject: RE: [MAXIMO List] Re: Hide status values
Try using a Data Restriction? Don't think Search allows for filtering as it
would still be possible for a value to exist.
--- Sean Clark-McCarthy
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 Hanna, Christopher CTR
Sent: Tuesday, October 30, 2012 1:21 PM
To: MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com>
<mailto:MAXIMO%40yahoogroups.com>
Subject: RE: [MAXIMO List] Re: Hide status values
Wouldn't that hide the field and not the specific statuses in the list?
-----Original Message-----
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 andrew.tess
Sent: Tuesday, October 30, 2012 12:32 PM
To: MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com>
<mailto:MAXIMO%40yahoogroups.com> <mailto:MAXIMO%40yahoogroups.com>
Subject: [MAXIMO List] Re: Hide status values
You may want to try:
In Application Designer for the application open the Adavanced Search
Dialog. Check the status field there and get your condition applied there.
Hope this helps,
Andy
--- In MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com>
<mailto:MAXIMO%40yahoogroups.com> <mailto:MAXIMO%40yahoogroups.com>
<mailto:MAXIMO%40yahoogroups.com> , "Hanna, Christopher CTR"
<christopher.a.hanna@...
<mailto:christopher.a.hanna@...%3cmailto:christopher.a.hanna@...>
<mailto:christopher.a.hanna@...>> wrote:
>
> My users want to hide the new 7.5 status values (broken, etc...) for
locations and assets (sigh). I've set up a conditional a expression based on
a signature option and associated to the domain, and that works great, for
the list in the change status dialog.
>
> Problem now is, the new status values are still showing up in the list on
the advanced search screen. Anyone have any thoughts on how to hide them
there as well?
>
> The where clause for my conditional expression is listed below:
>
> (EXISTS (
> SELECT 1
> FROM maximo.applicationauth aa
> INNER JOIN maximo.groupuser gu
> ON gu.groupname = aa.groupname
> WHERE aa.app= :&APPNAME&
> AND aa.optionname = 'NEWSTATUS'
> AND gu.userid = :&USERNAME&))
>
> Chris A Hanna, CTR
> Application Programmer
> Digital Management Inc.
> US Coast Guard Operations Systems Center christopher.a.hanna@
<mailto:christopher.a.hanna@%3cmailto:christopher.a.hanna@>
<mailto:christopher.a.hanna@>...
> (304)433-3234
>
Interesting follow up note on this; My users (sigh) also asked for some of the new work types to be hidden. Since work types are driven from a table domain (kinda sorta, actually driven from the native code) rather than a synonym domain, I had to implement this slightly differently, using a data restriction. Using the data restriction WILL hide the values from the list in the advances search. So if the document is accurate, and not being able to hide values from a list in a search field (or list tab field) is by design. This shouldn't have worked either. Seems hard to argue that an inconsistency in implementation is by design.
-----Original Message-----
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Mark Dong
Sent: Thursday, November 01, 2012 11:48 PM
To: MAXIMO@yahoogroups.com
Subject: Re: [MAXIMO List] Hide status values
Hi,
Please refer to the following URL from IBM
http://www-01.ibm.com/support/docview.wss?uid=swg21596678
Mark
________________________________
From: "Hanna, Christopher CTR" <christopher.a.hanna@uscg.mil <mailto:christopher.a.hanna%40uscg.mil> >
To: MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com>
Sent: Tuesday, October 30, 2012 10:26 PM
Subject: [MAXIMO List] Hide status values
My users want to hide the new 7.5 status values (broken, etc...) for locations and assets (sigh). I've set up a conditional a expression based on a signature option and associated to the domain, and that works great, for the list in the change status dialog.
Problem now is, the new status values are still showing up in the list on the advanced search screen. Anyone have any thoughts on how to hide them there as well?
The where clause for my conditional expression is listed below:
(EXISTS (
SELECT 1
FROM maximo.applicationauth aa
INNER JOIN maximo.groupuser gu
ON gu.groupname = aa.groupname
WHERE aa.app= :&APPNAME&
AND aa.optionname = 'NEWSTATUS'
AND gu.userid = :&USERNAME&))
Chris A Hanna, CTR
Application Programmer
Digital Management Inc.
US Coast Guard Operations Systems Center christopher.a.hanna@uscg.mil <mailto:christopher.a.hanna%40uscg.mil>
(304)433-3234
I attached the conditional expressions to the values I wanted to hide in the domain itself.
-----Original Message-----
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Incomm Solutions Inc.
Sent: Friday, November 02, 2012 12:24 AM
To: MAXIMO@yahoogroups.com
Subject: RE: [MAXIMO List] Re: Hide status values
Which way did you say you were restricting, Chris? In SigSec or in the domain itself?
Shannon
From: MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> [mailto:MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> ] On Behalf Of Hanna, Christopher CTR
Sent: October-31-12 4:16 AM
To: MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com>
Subject: RE: [MAXIMO List] Re: Hide status values
That thought did cross my mind. We may try that if the users complain really loudly, for now were just rolling forward with the values in the list on the advanced search. They can't see any of the new values in a status change dialog so that is the important thing. Schedule constraints ya know, everything needs to be done yesterday ;)
-----Original Message-----
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 Sean Clark-McCarthy
Sent: Tuesday, October 30, 2012 2:22 PM
To: MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> <mailto:MAXIMO%40yahoogroups.com>
Subject: RE: [MAXIMO List] Re: Hide status values
Try using a Data Restriction? Don't think Search allows for filtering as it would still be possible for a value to exist.
--- Sean Clark-McCarthy
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 Hanna, Christopher CTR
Sent: Tuesday, October 30, 2012 1:21 PM
To: MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> <mailto:MAXIMO%40yahoogroups.com> <mailto:MAXIMO%40yahoogroups.com>
Subject: RE: [MAXIMO List] Re: Hide status values
Wouldn't that hide the field and not the specific statuses in the list?
-----Original Message-----
From: MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.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> <mailto:MAXIMO%40yahoogroups.com>] On Behalf Of andrew.tess
Sent: Tuesday, October 30, 2012 12:32 PM
To: MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> <mailto:MAXIMO%40yahoogroups.com> <mailto:MAXIMO%40yahoogroups.com> <mailto:MAXIMO%40yahoogroups.com>
Subject: [MAXIMO List] Re: Hide status values
You may want to try:
In Application Designer for the application open the Adavanced Search Dialog. Check the status field there and get your condition applied there.
Hope this helps,
Andy
--- In MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> <mailto:MAXIMO%40yahoogroups.com> <mailto:MAXIMO%40yahoogroups.com> <mailto:MAXIMO%40yahoogroups.com> <mailto:MAXIMO%40yahoogroups.com> , "Hanna, Christopher CTR"
<christopher.a.hanna@...
<mailto:christopher.a.hanna@...%3cmailto:christopher.a.hanna@...>
<mailto:christopher.a.hanna@...>> wrote:
>
> My users want to hide the new 7.5 status values (broken, etc...) for
locations and assets (sigh). I've set up a conditional a expression based on a signature option and associated to the domain, and that works great, for the list in the change status dialog.
>
> Problem now is, the new status values are still showing up in the list
> on
the advanced search screen. Anyone have any thoughts on how to hide them there as well?
>
> The where clause for my conditional expression is listed below:
>
> (EXISTS (
> SELECT 1
> FROM maximo.applicationauth aa
> INNER JOIN maximo.groupuser gu
> ON gu.groupname = aa.groupname
> WHERE aa.app= :&APPNAME&
> AND aa.optionname = 'NEWSTATUS'
> AND gu.userid = :&USERNAME&))
>
> Chris A Hanna, CTR
> Application Programmer
> Digital Management Inc.
> US Coast Guard Operations Systems Center christopher.a.hanna@
<mailto:christopher.a.hanna@%3cmailto:christopher.a.hanna@>
<mailto:christopher.a.hanna@>...
> (304)433-3234
>
here's a thought
why not create a new domain and replace the original status domain in db config as it's a status field it might not work but its worth a try
Rgds Ian
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Hanna, Christopher CTR
Sent: 02 November 2012 11:10
To: MAXIMO@yahoogroups.com
Subject: RE: [MAXIMO List] Re: Hide status values
I attached the conditional expressions to the values I wanted to hide in the domain itself.
-----Original Message-----
From: MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com> [mailto:MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com>] On Behalf Of Incomm Solutions Inc.
Sent: Friday, November 02, 2012 12:24 AM
To: MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com>
Subject: RE: [MAXIMO List] Re: Hide status values
Which way did you say you were restricting, Chris? In SigSec or in the domain itself?
Shannon
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 Hanna, Christopher CTR
Sent: October-31-12 4:16 AM
To: MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com> <mailto:MAXIMO%40yahoogroups.com>
Subject: RE: [MAXIMO List] Re: Hide status values
That thought did cross my mind. We may try that if the users complain really loudly, for now were just rolling forward with the values in the list on the advanced search. They can't see any of the new values in a status change dialog so that is the important thing. Schedule constraints ya know, everything needs to be done yesterday ;)
-----Original Message-----
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 Sean Clark-McCarthy
Sent: Tuesday, October 30, 2012 2:22 PM
To: MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com> <mailto:MAXIMO%40yahoogroups.com> <mailto:MAXIMO%40yahoogroups.com>
Subject: RE: [MAXIMO List] Re: Hide status values
Try using a Data Restriction? Don't think Search allows for filtering as it would still be possible for a value to exist.
--- Sean Clark-McCarthy
From: MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.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> <mailto:MAXIMO%40yahoogroups.com> ] On Behalf Of Hanna, Christopher CTR
Sent: Tuesday, October 30, 2012 1:21 PM
To: MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com> <mailto:MAXIMO%40yahoogroups.com> <mailto:MAXIMO%40yahoogroups.com> <mailto:MAXIMO%40yahoogroups.com>
Subject: RE: [MAXIMO List] Re: Hide status values
Wouldn't that hide the field and not the specific statuses in the list?
-----Original Message-----
From: MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com> <mailto:MAXIMO%40yahoogroups.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> <mailto:MAXIMO%40yahoogroups.com> <mailto:MAXIMO%40yahoogroups.com>] On Behalf Of andrew.tess
Sent: Tuesday, October 30, 2012 12:32 PM
To: MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com> <mailto:MAXIMO%40yahoogroups.com> <mailto:MAXIMO%40yahoogroups.com> <mailto:MAXIMO%40yahoogroups.com> <mailto:MAXIMO%40yahoogroups.com>
Subject: [MAXIMO List] Re: Hide status values
You may want to try:
In Application Designer for the application open the Adavanced Search Dialog. Check the status field there and get your condition applied there.
Hope this helps,
Andy
--- In MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com> <mailto:MAXIMO%40yahoogroups.com> <mailto:MAXIMO%40yahoogroups.com> <mailto:MAXIMO%40yahoogroups.com> <mailto:MAXIMO%40yahoogroups.com> <mailto:MAXIMO%40yahoogroups.com> , "Hanna, Christopher CTR"
<christopher.a.hanna@...
<mailto:christopher.a.hanna@...%3cmailto:christopher.a.hanna@...<mailto:christopher.a.hanna@...%0b%3cmailto:christopher.a.hanna@...%3cmailto:christopher.a.hanna@...>>
<mailto:christopher.a.hanna@...>> wrote:
>
> My users want to hide the new 7.5 status values (broken, etc...) for
locations and assets (sigh). I've set up a conditional a expression based on a signature option and associated to the domain, and that works great, for the list in the change status dialog.
>
> Problem now is, the new status values are still showing up in the list
> on
the advanced search screen. Anyone have any thoughts on how to hide them there as well?
>
> The where clause for my conditional expression is listed below:
>
> (EXISTS (
> SELECT 1
> FROM maximo.applicationauth aa
> INNER JOIN maximo.groupuser gu
> ON gu.groupname = aa.groupname
> WHERE aa.app= :&APPNAME&
> AND aa.optionname = 'NEWSTATUS'
> AND gu.userid = :&USERNAME&))
>
> Chris A Hanna, CTR
> Application Programmer
> Digital Management Inc.
> US Coast Guard Operations Systems Center christopher.a.hanna@<mailto:christopher.a.hanna@>
<mailto:christopher.a.hanna@%3cmailto:christopher.a.hanna@>
<mailto:christopher.a.hanna@>...
> (304)433-3234
>
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.
**************************************************************************************************************
Chris,
On List Tabs, the MBO behaves differently. These are referred to rather fittingly as a “Zombie” mbo. They have no smarts behind them. Data restrictions on the other had are essentially data filters placed on an object. It works in the case of the Worktype because it is its own table. Synonym domain wouldn’t because it is filtered at a different point in the process (not upon fetch, but programmatically, from my understanding).
--- Sean Clark-McCarthy
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Hanna, Christopher CTR
Sent: Friday, November 02, 2012 7:07 AM
To: MAXIMO@yahoogroups.com
Subject: RE: [MAXIMO List] Hide status values
Interesting follow up note on this; My users (sigh) also asked for some of the new work types to be hidden. Since work types are driven from a table domain (kinda sorta, actually driven from the native code) rather than a synonym domain, I had to implement this slightly differently, using a data restriction. Using the data restriction WILL hide the values from the list in the advances search. So if the document is accurate, and not being able to hide values from a list in a search field (or list tab field) is by design. This shouldn't have worked either. Seems hard to argue that an inconsistency in implementation is by design.
-----Original Message-----
From: MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com> [mailto:MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com>] On Behalf Of Mark Dong
Sent: Thursday, November 01, 2012 11:48 PM
To: MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com>
Subject: Re: [MAXIMO List] Hide status values
Hi,
Please refer to the following URL from IBM
http://www-01.ibm.com/support/docview.wss?uid=swg21596678
Mark
________________________________
From: "Hanna, Christopher CTR" <christopher.a.hanna@uscg.mil<mailto:christopher.a.hanna%40uscg.mil> <mailto:christopher.a.hanna%40uscg.mil> >
To: MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com> <mailto:MAXIMO%40yahoogroups.com>
Sent: Tuesday, October 30, 2012 10:26 PM
Subject: [MAXIMO List] Hide status values
My users want to hide the new 7.5 status values (broken, etc...) for locations and assets (sigh). I've set up a conditional a expression based on a signature option and associated to the domain, and that works great, for the list in the change status dialog.
Problem now is, the new status values are still showing up in the list on the advanced search screen. Anyone have any thoughts on how to hide them there as well?
The where clause for my conditional expression is listed below:
(EXISTS (
SELECT 1
FROM maximo.applicationauth aa
INNER JOIN maximo.groupuser gu
ON gu.groupname = aa.groupname
WHERE aa.app= :&APPNAME&
AND aa.optionname = 'NEWSTATUS'
AND gu.userid = :&USERNAME&))
Chris A Hanna, CTR
Application Programmer
Digital Management Inc.
US Coast Guard Operations Systems Center christopher.a.hanna@uscg.mil<mailto:christopher.a.hanna%40uscg.mil> <mailto:christopher.a.hanna%40uscg.mil>
(304)433-3234