IBM Maximo: Tabelas que contêm consultas para revisar
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 %';