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.



Is there any best practise about searching data in any fields in Maximo 75

From: yd_ir (2011-08-12 01:58)

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


From: kuldeep lakhani (2011-08-12 21:25)

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