June 20, 2012

All about Maximo domains and lookups

A useful set of articles and tutorials from IBM about domain, crossover domain, lookup, value list.

Adding a valuelist (ALN Domain) in Maximo
Adding Lookup Functionality to a Field in Maximo
Setting Up Crossover Functionality in Maximo
Filtering an out of the box lookup in Maximo
Troubleshooting Crossover Domains
Setting Up A Conditional Domain
Associating Lookups in Maximo using the MAXLOOKUPMAP Table
Conditional Lookup Functionality
Displaying Additional Information Through a Relationship in Maximo
Limiting Lookups using WHERECLAUSE
The Hidden Feature of Crossover Domain

7 comments:

  1. Hi Bruno

    Can you pls see if you can help me out here - thanks.
    I have a field in Maximo for Contract Number (PURCHVIEW.CONTRACTNUM). I have created a BIRT Report and it works except I cannot seem to get the lookup working for it.

    There is a standard lookup called "contract" in Maximo and it is already set up with the PURCHVIEW table. However, in the database configuration, there is no domain or 'Class:' (java class) information attached to the PURCHVIEW.CONTRACTNUM attribute.

    I couldn't set up the lookup for this. However, some contractor has already setup a lookup using a CROSSOVER DOMAIN with the Work Order table and the PURCHVIEW and in that case, the PURCHVIEW.CONTRACTNUM is linked well and produces a lookup (with the WO Table). Do you know if you can help me here - thanks

    ReplyDelete
  2. Hi,

    I am using a table domain for one attribute in locations application. when i use same domain in advanced search tab of locations application it is giving invalid binding. Can you tell me if there is some different approach to be followed for table domains in advanced search tab?

    ReplyDelete
  3. How does one modify the columns that appear in a lookup? I want to remove some fields and add others... All part of the same table.

    ReplyDelete
    Replies
    1. You must modify the columns in the LOOKUPS.xml Just look at the existing records and you should be able to determine how to do this. Make sure you update the column numbers when you remove or ad an item.

      Delete
  4. Interesting Post about Creating Lookup for not primary key fields.

    http://sometimesiliketopretend.blogspot.com.es/2013/10/create-lookup-with-table-domain-in.html

    ReplyDelete
  5. Can i set default values in the look up(without takes it's values from object)?

    ReplyDelete
  6. What is the difference between MAXLOOKUPMAP and crossover domain ?

    ReplyDelete