IBM Maximo: Tabelas que contêm consultas para revisar

From Wiki
Revision as of 16:25, 20 December 2021 by Ebasso (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

As Tabelas que contêm consultas para revisar:

Tabela Coluna Descrição
QUERY CLAUSE Example
CONDITION EXPRESSION Example
ESCALATION CONDITION Example
ESCREFPOINT EVENTCONDITION Example
WFCONDITION CONDITION Veja IBM Maximo: SQL Queries - WORKFLOW
MAXRELATIONSHIP WHERECLAUSE Example
MAXAPPS RESTRICTIONS e ORDERBY Example
MAXTABLEDOMAIN VALIDTNWHERECLAUSE e LISTWHERECLAUSE Example
MAXVIEW VIEWSELECT, VIEWWHERE e VIEWFROM Example
SLA CONDITION Example
MAXPRESENTATION PRESENTATION Example

Geral

Localizar fragmentos de código

ALTER SESSION SET CURRENT_SCHEMA = MAXIMO;
select * from CONDITION where lower(EXPRESSION) like lower('% fragmento %');
select * from ESCALATION where lower(CONDITION) like lower('% fragmento %');
select * from ESCREFPOINT where lower(EVENTCONDITION) like lower('% fragmento %');
select * from WFCONDITION where lower(CONDITION) like lower('% fragmento %');
select * from QUERY where lower(CLAUSE) like lower('% fragmento %');
select * from MAXRELATIONSHIP where lower(WHERECLAUSE) like lower('% fragmento %');
select * from MAXVIEW where lower(VIEWWHERE) like lower('% fragmento %');
select * from SLA where lower(CONDITION) like lower('% fragmento %');
select APP from MAXPRESENTATION where PRESENTATION like '% fragmento %';


Ver também