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.
Here is my guess I'm on 7.5 sorry not on 7.6 yet
TOOLITEM is a view of ITEM so the view will inherit the attributes of the
table the view is based on hense read only in TOOLITEM
To Change the search type for TOOLITEM you will need to change the ITEM
DESCRIPTION field to TEXT which will the rolldown to the views dependent on
ITEM
On the ITEM object main tab screen there is a field "Text Search Enabled?"
out of the box its ticked i.e. true
Make sure it is ticked before you change the type it will state that at
least one field must have the type TEXT save then make the change on your
description screen
Rgds Ian
-------Original Message-------
From: 'InComm Solutions Inc.' incomm@shaw.ca [MAXIMO]
Date: 05/11/16 04:15:32
To: MAXIMO@yahoogroups.com
Subject: RE: [MAXIMO List] Re: Maximo 7.6 how to change search type on Tool
Description
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 7.5.0.8 out of the box install of Maximo with maxdemo data shows toolitem as a view and description shows as a search type of TEXT. Maybe 6.2 it was bug to have it be wildcard.
You know, 6.2 to 7.1 to 7.5 to 7.6 may fix these type of errors as part of the upgrade. Hope you are not doing unnecessary work when the upgrade process may take care of it.
http://i.imgur.com/9u7XvmO.jpg http://i.imgur.com/9u7XvmO.jpg
---In MAXIMO@yahoogroups.com, <ian_wright12000 yahoo #38219659.co.uk> wrote :
Here is my guess I'm on 7.5 sorry not on 7.6 yet
TOOLITEM is a view of ITEM so the view will inherit the attributes of the
table the view is based on hense read only in TOOLITEM
To Change the search type for TOOLITEM you will need to change the ITEM
DESCRIPTION field to TEXT which will the rolldown to the views dependent on
ITEM
On the ITEM object main tab screen there is a field "Text Search Enabled?"
out of the box its ticked i.e. true
Make sure it is ticked before you change the type it will state that at
least one field must have the type TEXT save then make the change on your
description screen
******************************
Good guess, but when I tried this on item.description, it failed there as well. Checking "Text Search Enabled?" and then trying to change item.description yields the same read-only error.
Not cool IBM.
-C