View source for IBM Maximo: Tabelas que contêm consultas para revisar


As Tabelas que contêm consultas para revisar:

{| class="wikitable"
|-
! 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 =

* [[IBM Maximo| Artigos sobre IBM Maximo]]
* [[Tecnologias|  Mais Artigos sobre Cloud / WebDev / Tecnologias]]

[[Category:IBM Maximo]]
[[Category:ibm-maximo-sql]]
[[Category:ibm-maximo-performance]]