How to query a Maximo domain with SQL?
I have a domain in Maximo 18.104.22.168 called DIVISIONS.
I would like to write a SELECT statement that queries the DIVISIONS domain to get the VALUE and DESCRIPTION fields.
The query would be made into a view; to be used in a separate database via a dblink.
How can I query a Maximo domain with SQL?
Just to add the MAXDOMAIN table identifies the domain description and type (DOMAINTYPE).
For Table Domains and Crossover Domains (both look up values from a database table, there will be an additional entry in the MAXTABLEDOMAIN. The OBJECTNAME attribute on this record will identify the source table being referenced.
For Crossover Domains, the CROSSOVERDOMAIN table will contain a number of Source and Destination pairs for the target Domain - and when used will cause the source values to be copied from the table identified as OBJECTNAME to the target table which is associated with the Crossover Domain.
You can see whats domains are linked to individual attributes by looking at the MAXATTRIBUTE table (WHERE ATTRIBUTENAME = 'target attribute' AND OBJECTNAME = 'target_object' and then inspecting the DOMAINID value)
Adding crossover domains, The application does not validate SQL statements. Procedure. Open the Domains application. In the Domains table window, add a domain and select Add� A DBA or Maximo Administrator can develop useful date range queries to meet the user's needs, and make them available as public saved queries in the various application query screens. You can then pick date queries and enhance them to add personal criteria, such as ENTEREDBY, SUPERVISOR, etc. and save them as your own.
I can query the ALNDOMAIN table (ALN stands for alphanumeric):
select * from alndomain where domainid = 'DIVISIONS'
For what it's worth, there is also a parent domain table (for lack of a better word).
select * from maxdomain where domainid = 'DIVISIONS'
Guidelines for troubleshooting TPAE and Maximo domain look up , Use database configuration or direct sql query maxattribute to find out the classname and/or domain associate to the field. 4. Check the� relevant Maximo application's list page, in the Advanced Searchwindow. You can do a query by example on the field combinations of interest. Once executed, you can see and modify the SQL statement in the Where
In maximo, there's a table which contains entries for all types of domain. In order to query that table you can query like
SELECT * FROM MAXDOMAIN WHERE DOMAINID='DOMAINID' AND DOMAINTYPE='SYNONYM';
maximo has seperate tables based upon the type of domains.
SELECT * FROM NUMRANGEDOMAIN WHERE DOMAINID='NUMRANGEDOMAINID'; SELECT * FROM CROSSOVERDOMAIN WHERE DOMAINID='CROSSOVERDOMAINID'; SELECT * FROM ALNDOMAIN WHERE DOMAINID='ALNDOMAINID'; SELECT * FROM SYNONYMDOMAIN WHERE DOMAINID='SYNONYMDOMAINID';
Query to Create New Synonym domain, Query for inserting values in domain Methods of Bean Classes of Maximo Reset Method This method is called when a new filter is applied for� Creating advanced SQL queries If you are familiar with SQL, then you can continue reading this section as there are many ways to create advanced queries to find records in Maximo. First, instead of using the ‘Advanced Search’ button, we can click on the yellow arrow to expand the list so we can click on ‘Where Clause’.
IBM Maximo Lookup selecting another value not default - html, I want to select from PERSON table - if I select a value through lookup, person id on the target attribute so Maximo knows what attribute returned by the domain � Write 'where clause' statements to filter data in Maximo UI. Develop complex SELECT statements to extract data from multiple tables when developing report. Optimize existing queries to solve performance issues. If you need to improve your SQL skills I suggest you to read few chapters of the SQL Getting Started guide of IBM DB2. This is not just
Maximo Languages and Language Tables – Maximo Secrets, Maximo supports the following languages: English, French, Spanish, German, Italian, field and report labels, messages and field help, lookups (domains), companies, items, queries, reports and solutions all have language tables. A SQL script is needed to change the attribute MLSUPPORTED to 1. Maximo then generated the SQL queries that can be viewed from the 'Where Clause' dialog box, including the EXISTS statements. These are being shown to demonstrate where a user can see and learn how to write a more complex SQL query.
Creating a Table Domain in Anywhere Builder, This video demonstrates recreating a Maximo table domain inside of Maximo Anywhere Duration: 8:14 Posted: Jun 7, 2018 When you open Inventory, you can enter text into the Description field and the actual SQL query looks like this: (status != 'OBSOLETE' and siteid = 'ACME') and (exists (select 1 from dbo.item where ((description like '%BEARING%')) and (itemnum = inventory.itemnum and itemsetid = inventory.itemsetid)))