RelatorioPorTicketAtendimentoRelatorio Por Ticket Atendimento127<?xml version="1.0" encoding="ISO-8859-1" ?> <PARAMETERS> <PARAM name='requestId' type='java.lang.Integer' typeHTML='text' size='10' value='' description='visao.idSolicitacao' fix='false' mandatory='false'/> <PARAM name='typeDate' type='java.lang.Integer' typeHTML='select' value='1' description='citcorpore.texto.periodo' fix='false' mandatory='false' reload='true' onload='true' default='1'> <OPTION value='0' text='expression.function.serviceRequest.getRequestTimestamp'/> <OPTION value='1' text='citcorpore.comum.dataEncerramento'/> </PARAM> <PARAM name='startDate' type='java.sql.Date' size='10' value='' description='citcorpore.comum.datainicio' fix='false' mandatory='false' default='{MONTH_AGO}'/> <PARAM name='endDate' type='java.sql.Date' size='10'value='' description='citcorpore.comum.datafim' fix='false' mandatory='false' default='{TODAY}'/> <PARAM name='contractId' type='java.lang.Integer' typeHTML='select' value='' description='Contract' fix='false' mandatory='false' reload='true' onload='true'> <OPTION value='-1' text='ALL'/> <OPTIONS type='SQL' onload='true'> SELECT idcontrato, numero||' ('||nomefantasia||')' FROM contratos ct join clientes cl on cl.idcliente = ct.idcliente and (ct.deleted is null OR ct.deleted = 'N' OR ct.deleted = 'n') AND (ct.datafimcontrato IS NULL OR ct.datafimcontrato >= CURRENT_TIMESTAMP) AND (ct.situacao = 'A' ) ORDER BY 2 </OPTIONS> </PARAM> </PARAMETERS>GGC,GIR,GIRG,GL,GM,GP