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.


Hii

From: Jagan Rajan (2012-01-20 06:54)

Hi Everyone,
                        I have an issue in workorders I am not able to filter any data from workorder description. I know its confusing, I go to advance search and create a query work type 'PM' and status 'WSCH' and hit find to get the data populated, and it will bring in workorders but now if i try to filter it by description of the work order it will not do it. Anyone have any idea...
apreciate your help.
thanks
 

From: Michael Dougherty (2012-01-20 09:56)

What exactly do you mean filter by description? What are you typing for example?
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Jagan Rajan
Sent: Friday, January 20, 2012 9:54 AM
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] Hii
Hi Everyone,
I have an issue in workorders I am not able to filter any data from workorder description. I know its confusing, I go to advance search and create a query work type 'PM' and status 'WSCH' and hit find to get the data populated, and it will bring in workorders but now if i try to filter it by description of the work order it will not do it. Anyone have any idea...
apreciate your help.
thanks

From: Jagan Rajan (2012-01-20 07:07)

I am trying to search for a work order by its description  and it is not coming up a few workorders are populated but the particular one i was looking for didnt show up. But if i put the workorder number it is populated.
________________________________
From: Michael Dougherty <mdougherty@njdwsc.com>
To: "MAXIMO@yahoogroups.com" <MAXIMO@yahoogroups.com>
Sent: Friday, January 20, 2012 9:56 AM
Subject: RE: [MAXIMO List] Hii
 
What exactly do you mean filter by description? What are you typing for example?
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Jagan Rajan
Sent: Friday, January 20, 2012 9:54 AM
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] Hii
Hi Everyone,
I have an issue in workorders I am not able to filter any data from workorder description. I know its confusing, I go to advance search and create a query work type 'PM' and status 'WSCH' and hit find to get the data populated, and it will bring in workorders but now if i try to filter it by description of the work order it will not do it. Anyone have any idea...
apreciate your help.
thanks

From: Kevin Egolf (2012-01-20 10:12)

Check the filter type for the field. If it is a text search it is looking for full words. Try to do your search using the wild card on each side of your value “%XXXX%’. See if you get a return then. The text search creates a query that looks like ‘% XXXX %’ and will only return complete word matches. If this is an issue for your users you will have to change your search type to wildcard

Kevin Egolf
Director Asset Management Programs
kegolf@techopsolutions.net
Office: 703-984-0575
Cell: 571-344-3221
cid:image002.jpg@01CA9B5E.8477B830

From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Jagan Rajan
Sent: Friday, January 20, 2012 10:08 AM
To: MAXIMO@yahoogroups.com
Subject: Re: [MAXIMO List] Hii


I am trying to search for a work order by its description and it is not coming up a few workorders are populated but the particular one i was looking for didnt show up. But if i put the workorder number it is populated.
________________________________
From: Michael Dougherty <mdougherty@njdwsc.com <mailto:mdougherty%40njdwsc.com> >
To: "MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> " <MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> >
Sent: Friday, January 20, 2012 9:56 AM
Subject: RE: [MAXIMO List] Hii

What exactly do you mean filter by description? What are you typing for example?
From: MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> [mailto:MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> ] On Behalf Of Jagan Rajan
Sent: Friday, January 20, 2012 9:54 AM
To: MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com>
Subject: [MAXIMO List] Hii
Hi Everyone,
I have an issue in workorders I am not able to filter any data from workorder description. I know its confusing, I go to advance search and create a query work type 'PM' and status 'WSCH' and hit find to get the data populated, and it will bring in workorders but now if i try to filter it by description of the work order it will not do it. Anyone have any idea...
apreciate your help.
thanks

From: Jagan Rajan (2012-01-20 07:25)

tried all that it is not pulling the work order
________________________________
From: Kevin Egolf <kegolf@techopsolutions.net>
To: MAXIMO@yahoogroups.com
Sent: Friday, January 20, 2012 10:12 AM
Subject: RE: [MAXIMO List] Hii
 
Check the filter type for the field. If it is a text search it is looking for full words. Try to do your search using the wild card on each side of your value “%XXXX%’. See if you get a return then. The text search creates a query that looks like ‘% XXXX %’ and will only return complete word matches. If this is an issue for your users you will have to change your search type to wildcard
Kevin Egolf
Director Asset Management Programs
kegolf@techopsolutions.net
Office: 703-984-0575
Cell: 571-344-3221
cid:image002.jpg@01CA9B5E.8477B830
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Jagan Rajan
Sent: Friday, January 20, 2012 10:08 AM
To: MAXIMO@yahoogroups.com
Subject: Re: [MAXIMO List] Hii
I am trying to search for a work order by its description and it is not coming up a few workorders are populated but the particular one i was looking for didnt show up. But if i put the workorder number it is populated.
________________________________
From: Michael Dougherty <mdougherty@njdwsc.com <mailto:mdougherty%40njdwsc.com> >
To: "MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> " <MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> >
Sent: Friday, January 20, 2012 9:56 AM
Subject: RE: [MAXIMO List] Hii
What exactly do you mean filter by description? What are you typing for example?
From: MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> [mailto:MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> ] On Behalf Of Jagan Rajan
Sent: Friday, January 20, 2012 9:54 AM
To: MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com>
Subject: [MAXIMO List] Hii
Hi Everyone,
I have an issue in workorders I am not able to filter any data from workorder description. I know its confusing, I go to advance search and create a query work type 'PM' and status 'WSCH' and hit find to get the data populated, and it will bring in workorders but now if i try to filter it by description of the work order it will not do it. Anyone have any idea...
apreciate your help.
thanks

From: Chris McClinch (2012-01-20 10:40)

How long ago was the work order created? We've found that all other fields
are searchable right away, but that description isn't searchable until
about 10-15 minutes after the work order was created.
Chris McClinch
On Fri, Jan 20, 2012 at 10:25 AM, Jagan Rajan <lensman511@yahoo.com> wrote:
> **
>
>
> tried all that it is not pulling the work order
>
> ________________________________
> From: Kevin Egolf <kegolf@techopsolutions.net>
> To: MAXIMO@yahoogroups.com
> Sent: Friday, January 20, 2012 10:12 AM
>
> Subject: RE: [MAXIMO List] Hii
>
>
> Check the filter type for the field. If it is a text search it is looking
> for full words. Try to do your search using the wild card on each side of
> your value “%XXXX%’. See if you get a return then. The text search creates
> a query that looks like ‘% XXXX %’ and will only return complete word
> matches. If this is an issue for your users you will have to change your
> search type to wildcard
>
> Kevin Egolf
>
> Director Asset Management Programs
>
> kegolf@techopsolutions.net
>
> Office: 703-984-0575
>
> Cell: 571-344-3221
>
> cid:image002.jpg@01CA9B5E.8477B830
>
> From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of
> Jagan Rajan
> Sent: Friday, January 20, 2012 10:08 AM
> To: MAXIMO@yahoogroups.com
> Subject: Re: [MAXIMO List] Hii
>
> I am trying to search for a work order by its description and it is not
> coming up a few workorders are populated but the particular one i was
> looking for didnt show up. But if i put the workorder number it is
> populated.
>
> ________________________________
> From: Michael Dougherty <mdougherty@njdwsc.com <mailto:
> mdougherty%40njdwsc.com> >
> To: "MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> " <
> MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> >
> Sent: Friday, January 20, 2012 9:56 AM
> Subject: RE: [MAXIMO List] Hii
>
> What exactly do you mean filter by description? What are you typing for
> example?
>
> From: MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> [mailto:
> MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> ] On Behalf Of
> Jagan Rajan
> Sent: Friday, January 20, 2012 9:54 AM
> To: MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com>
> Subject: [MAXIMO List] Hii
>
> Hi Everyone,
> I have an issue in workorders I am not able to filter any data from
> workorder description. I know its confusing, I go to advance search and
> create a query work type 'PM' and status 'WSCH' and hit find to get the
> data populated, and it will bring in workorders but now if i try to filter
> it by description of the work order it will not do it. Anyone have any
> idea...
> apreciate your help.
> thanks
>
>
>
>
>
>
>
>
>
>
>
>
>

From: Kevin Egolf (2012-01-20 10:45)

Have you looked at the where clause to see what is states?

Kevin

From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Jagan Rajan
Sent: Friday, January 20, 2012 10:25 AM
To: MAXIMO@yahoogroups.com
Subject: Re: [MAXIMO List] Hii


tried all that it is not pulling the work order
________________________________
From: Kevin Egolf <kegolf@techopsolutions.net <mailto:kegolf%40techopsolutions.net> >
To: MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com>
Sent: Friday, January 20, 2012 10:12 AM
Subject: RE: [MAXIMO List] Hii

Check the filter type for the field. If it is a text search it is looking for full words. Try to do your search using the wild card on each side of your value “%XXXX%’. See if you get a return then. The text search creates a query that looks like ‘% XXXX %’ and will only return complete word matches. If this is an issue for your users you will have to change your search type to wildcard
Kevin Egolf
Director Asset Management Programs
kegolf@techopsolutions.net <mailto:kegolf%40techopsolutions.net>
Office: 703-984-0575
Cell: 571-344-3221
cid:image002.jpg@01CA9B5E.8477B830 <mailto:image002.jpg%4001CA9B5E.8477B830>
From: MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> [mailto:MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> ] On Behalf Of Jagan Rajan
Sent: Friday, January 20, 2012 10:08 AM
To: MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com>
Subject: Re: [MAXIMO List] Hii
I am trying to search for a work order by its description and it is not coming up a few workorders are populated but the particular one i was looking for didnt show up. But if i put the workorder number it is populated.
________________________________
From: Michael Dougherty <mdougherty@njdwsc.com <mailto:mdougherty%40njdwsc.com> <mailto:mdougherty%40njdwsc.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: Friday, January 20, 2012 9:56 AM
Subject: RE: [MAXIMO List] Hii
What exactly do you mean filter by description? What are you typing for example?
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 Jagan Rajan
Sent: Friday, January 20, 2012 9:54 AM
To: MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> <mailto:MAXIMO%40yahoogroups.com>
Subject: [MAXIMO List] Hii
Hi Everyone,
I have an issue in workorders I am not able to filter any data from workorder description. I know its confusing, I go to advance search and create a query work type 'PM' and status 'WSCH' and hit find to get the data populated, and it will bring in workorders but now if i try to filter it by description of the work order it will not do it. Anyone have any idea...
apreciate your help.
thanks


From: cnwinston (2012-01-21 16:54)

For reference, there can be issues with the description field in comparison to the syntax you are using to search. There is a page on the IBM support site "User cannot find records when querying the Description field" that you should probably check.
https://www-304.ibm.com/support/docview.wss?uid=swg21262037
Best of luck,
Chris.
--- In MAXIMO@yahoogroups.com, Jagan Rajan <lensman511@...> wrote:
>
> Hi Everyone,
>                         I have an issue in workorders I am not able to filter any data from workorder description. I know its confusing, I go to advance search and create a query work type 'PM' and status 'WSCH' and hit find to get the data populated, and it will bring in workorders but now if i try to filter it by description of the work order it will not do it. Anyone have any idea...
> apreciate your help.
> thanks
>  
>
>
>
>
>
>

From: Jagan Rajan (2012-01-23 07:16)

Thanks everyone the problem was identified.
 We found that the searching was working in our development system but not production.  We also found that the job procedure didn’t compile in production. It was discovered that the CTX option wasn’t installed.  Once that was done, the searching started working
 
________________________________
From: cnwinston <cnwinston@usa.net>
To: MAXIMO@yahoogroups.com
Sent: Saturday, January 21, 2012 11:54 AM
Subject: [MAXIMO List] Re: Hii
 
For reference, there can be issues with the description field in comparison to the syntax you are using to search. There is a page on the IBM support site "User cannot find records when querying the Description field" that you should probably check.
https://www-304.ibm.com/support/docview.wss?uid=swg21262037
Best of luck,
Chris.
--- In MAXIMO@yahoogroups.com, Jagan Rajan <lensman511@...> wrote:
>
> Hi Everyone,
>                         I have an issue in workorders I am not able to filter any data from workorder description. I know its confusing, I go to advance search and create a query work type 'PM' and status 'WSCH' and hit find to get the data populated, and it will bring in workorders but now if i try to filter it by description of the work order it will not do it. Anyone have any idea...
> apreciate your help.
> thanks
>  
>
>
>
>
>
>

From: Jagan Rajan (2012-01-23 19:58)

Thanks everyone the problem was identified. We found that the searching was working in our development system but not production. We also found that the job procedure didn’t compile in production. It was discovered that the CTX option wasn’t installed. Once that was done, the searching started working

________________________________
From: cnwinston <cnwinston@usa.net>
To: MAXIMO@yahoogroups.com
Sent: Saturday, January 21, 2012 11:54 AM
Subject: [MAXIMO List] Re: Hii


 

For reference, there can be issues with the description field in comparison to the syntax you are using to search. There is a page on the IBM support site "User cannot find records when querying the Description field" that you should probably check.
https://www-304.ibm.com/support/docview.wss?uid=swg21262037
Best of luck,
Chris.
--- In MAXIMO@yahoogroups.com, Jagan Rajan <lensman511@...> wrote:
>
> Hi Everyone,
>                         I have an issue in workorders I am not able to filter any data from workorder description. I know its confusing, I go to advance search and create a query work type 'PM' and status 'WSCH' and hit find to get the data populated, and it will bring in workorders but now if i try to filter it by description of the work order it will not do it. Anyone have any idea...
> apreciate your help.
> thanks
>  
>
>
>
>
>
>