«
»

Search Functions in Maximo

Hello;

After a long time I can write again…Meanwhile I changed my job. I am not a technical consultant anymore. I started to work in IS BANK (the biggest bank of Turkiye) as IBM CCMDB Developer. Now I prepared a flash to show you about maximo search functions. Most of you already know these stuff. But I think it will be good for someone. Hope you like it… If you like this kind of flash movies I will prepare more..

You can reach flash from here

Have a good day..

This entry was posted on Saturday, June 6th, 2009 at 9:27 am and is filed under Maximo Tips. You can leave a response, or trackback from your own site.

6 Responses

  1. Antonio Jacob Costa Says:
    June 8th, 2009 at 8:57 am

    Hi Burak,

    Thank you for your blog with all the information from Maximo.

    Regarding searches I’d like to add something that I didn’t find on the film which is Maximos hability of searching for NULL values using QBE searches.

    If you want to search for records having a field with NULL value just type:
    ~null~

    On the other hand if you want to search for records having a field with values that are NOT NULL type:
    !=~null~

    Hope this is useful.

    Best regards,
    –
    António Jacob Costa

  2. admin Says:
    June 9th, 2009 at 9:45 am

    Hello;
    Thanks for your reply.. I forgot about ~null~ but I didn’t know about !=~null~ but it makes sense:)

    Anyway another usage is smaller then and greater then (). We can use them to compare dates and integers..

    Have a good day…

  3. Chon Says:
    June 9th, 2009 at 5:08 pm

    This is a great video! The only thing I would change, if possible, is to change it so that I don’t have to click play at the end of every section. Just let the video play the whole way through.

  4. admin Says:
    June 11th, 2009 at 7:41 am

    Hello;
    I will solve it as soon as I learn it:) thanks…

    One last note about search: you can use underscores in search. They replace any character.. For example if you search
    WO___ : this will give you the records which starts with WO and which are 5 characters..
    WO__12: this will give you the records which starts with WO, ends with 12 and which are 6 characters..

    Have a good day…

  5. Fred Says:
    July 14th, 2009 at 11:40 am

    Hi,

    as you already know you can search into a Description field, for instance, using expression like Desc1,Desc2 that means you are looking for Desc1 OR Desc2, but do you know if it is possible to filter on Maximo using the following criteria: Desc1 OR NULL?
    I’ve tried with Desc1,~null~ but it does not work.
    Thanks for your suggestion.
    Have a good day.

  6. Karol Says:
    June 16th, 2010 at 12:57 pm

    Hi i want to find records created between 1.1.2001 and 1.2.2002
    how shoud find there records from list tab , without using where clause ?

Leave a Reply