Revision as of 17:20, 17 October 2023

Verificando se esta sendo Work Orders de PMs

SELECT WONUM,STATUS,WORKTYPE,DESCRIPTION,LOCATION,JPNUM,PMNUM,ROUTE,REPORTDATE,REPORTEDBY
FROM workorder w
WHERE pmnum IS NOT NULL
AND istask = 0
order by reportdate desc

Ver também

Revision as of 17:18, 17 October 2023 (view source) Ebasso (talk \| contribs) (Created page with " Verificando se esta sendo gerando PMs SELECT WONUM,STATUS,WORKTYPE,DESCRIPTION,LOCATION,JPNUM,PMNUM,ROUTE,REPORTDATE,REPORTEDBY FROM workorder w WHERE pmnum IS NOT NULL AND istask = 0 order by reportdate desc = Ver também = * Artigos sobre IBM Maximo * Mais Artigos sobre Cloud / WebDev / Tecnologias Category:IBM Maximo Category:ibm-maximo-performance Category:ibm-maximo-properties")		Revision as of 17:20, 17 October 2023 (view source) Ebasso (talk \| contribs) No edit summary Newer edit →
Line 1:		Line 1:

	Verificando se esta sendo ~~gerando~~ PMs		Verificando se esta sendo Work Orders de PMs

	SELECT WONUM,STATUS,WORKTYPE,DESCRIPTION,LOCATION,JPNUM,PMNUM,ROUTE,REPORTDATE,REPORTEDBY		SELECT WONUM,STATUS,WORKTYPE,DESCRIPTION,LOCATION,JPNUM,PMNUM,ROUTE,REPORTDATE,REPORTEDBY