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.
Dear all,
Afaik, in the installation process, there is a fulltextsearch configuration. I just curious, is it similar with search engine in google / yahoo? So i can find string in any field in Maximo within module.
Thanks & Best Regards,
Yudi
I am afraid there no standard functionality to make a general search in all tables / all columns in Maximo unlike Google n Yahoo etc.
There are many tools available in market (like Toad etc) that might help you in this.If you like PL/SQL option and you are not sure about value (say value to search is 'Value-I-Want-To-Search') directly from which table/column, below may help:
SET SERVEROUTPUT ON SIZE 100000
DECLARE match_count INTEGER; BEGIN FOR t IN (SELECT objectname as table_name, attributename as column_name FROM maxattribute where persistent=1) LOOP
EXECUTE IMMEDIATE 'SELECT COUNT(*) FROM '||t.table_name||' WHERE '||t.column_name||' = :1' INTO match_count USING 'Value-I-Want-To-Search';
IF match_count > 0 THEN dbms_output.put_line( t.table_name ||' '||t.column_name||' '||match_count ); END IF;
END LOOP;
END; / Regards...Kuldeep
--- On Thu, 8/11/11, yd_ir <yudi.irianto@ytljt.com> wrote:
From: yd_ir <yudi.irianto@ytljt.com>
Subject: [MAXIMO List] Is there any best practise about searching data in any fields in Maximo 75
To: MAXIMO@yahoogroups.com
Date: Thursday, August 11, 2011, 8:58 PM
Dear all,
Afaik, in the installation process, there is a fulltextsearch configuration. I just curious, is it similar with search engine in google / yahoo? So i can find string in any field in Maximo within module.
Thanks & Best Regards,
Yudi