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.
Still working on migrating to 7.6. . .
Just discovered that for TOOLITEM.DESCRIPTION, the search type is Wildcard. I want it to be Text (for the full-text search engine) but it is read-only.
On (my current) Maximo 6.2, the search type is set to Text. The search type is also set to Text in both versions of Maximo for ITEM.DESCRIPTION. Since TOOLITEM is a View of ITEM, you'd think they'd be the same.
Any ideas on how to change this?
Travis Herron
Let me rephrase:
Other than a back-end update of
UPDATE maxattributecfg
SET searchtype = 'TEXT'
WHERE objectname = 'TOOLITEM' AND attributename ='DESCRIPTION';
UPDATE maxattribute
SET searchtype = 'TEXT'
WHERE objectname = 'TOOLITEM' AND attributename ='DESCRIPTION'
and then a restart of Maximo,
Is there a way to make the Search Type = TEXT for ToolItem.Description?
Travis Herron
Hi Travis,
To change the attribute property you should change the underlying table
attribute , so as you expected you should change the search type in item
table , then it will affect both item and tools description search type
BR
Samir Khodair
On May 11, 2016 12:04 AM, "therron@pcci.edu [MAXIMO]" <
MAXIMO@yahoogroups.com> wrote:
>
>
>
> Still working on migrating to 7.6. . .
>
>
> Just discovered that for TOOLITEM.DESCRIPTION, the search type is
> Wildcard. I want it to be Text (for the full-text search engine) but it is
> read-only.
>
>
> On (my current) Maximo 6.2, the search type is set to Text. The search
> type is also set to Text in both versions of Maximo for ITEM.DESCRIPTION.
> Since TOOLITEM is a View of ITEM, you'd think they'd be the same.
>
>
> Any ideas on how to change this?
>
>
> Travis Herron
>
>
>
>
>
Hi Travis: is ITEM.DESCRIPTION set to Wildcard too, in the 7.6 database?
If not, I would think that's an error of some kind, having WILDCARD for
TOOLITEM.DESCRIPTION when ITEM.DESCRIPTION is TEXT.
In which case, I think the only way to fix that would be to do your table
update.
Shannon
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com]
Sent: Tuesday, May 10, 2016 3:13 PM
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] Re: Maximo 7.6 how to change search type on Tool
Description
Let me rephrase:
Other than a back-end update of
UPDATE maxattributecfg
SET searchtype = 'TEXT'
WHERE objectname = 'TOOLITEM' AND attributename ='DESCRIPTION';
UPDATE maxattribute
SET searchtype = 'TEXT'
WHERE objectname = 'TOOLITEM' AND attributename ='DESCRIPTION'
and then a restart of Maximo,
Is there a way to make the Search Type = TEXT for ToolItem.Description?
Travis Herron
---In MAXIMO@yahoogroups.com, <incomm@shaw.ca> wrote :
Hi Travis: is ITEM.DESCRIPTION set to Wildcard too, in the 7.6 database?
If not, I would think that's an error of some kind, having WILDCARD for
TOOLITEM.DESCRIPTION when ITEM.DESCRIPTION is TEXT.
****************************************************************************
On this system type below we have the same limitation. File a PMR, get an explanation. It might be a limit of the view, though, so see what they say.
App Server IBM WebSphere Application Server 8.5.5.3 Version Tivoli's process automation engine 7.6.0.3 Build 20160114-1313 DB Build V7603-151IBM TPAE Integration Framework 7.6.0.3 Build 20160108-1912 DB Build V7603-21IBM Maximo Calibration 7.6.0.0 Build 20160114-1313 DB Build V7600-03IBM Maximo Asset Management 7.6.0.3 Build 20160113-2204 DB Build V7603-01 Server OS Windows 2012 Server DB Oracle 12.1 (Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit
Yeah, in 7.6 it's a Text search on ITEM.DESCRIPTION but a wildcard search on TOOLITEM.DESCRIPTION.
Travis Herron
Strange ... I'm inclined to think that's a slip on IBM's part, in which case
I really think you're into a back-end update. But I agree: it's rather an
unknown doing a back-end update in this case.
Shannon
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com]
Sent: Wednesday, May 11, 2016 1:30 PM
To: MAXIMO@yahoogroups.com
Subject: RE: [MAXIMO List] Re: Maximo 7.6 how to change search type on Tool
Description
Yeah, in 7.6 it's a Text search on ITEM.DESCRIPTION but a wildcard search on
TOOLITEM.DESCRIPTION.
Travis Herron