¿Cuál es la diferencia entre # Solved Tickets y # Tickets Solved?

Regresar al inicio
¿Tiene más preguntas? Enviar una solicitud

1 Comentarios

  • Neus Montserrat Omella

    Hola! Puedes corregir la segunda query de la documentación? Hay un problema y no se ve bien

     

    SELECT IFNULL(COUNT(<g id="1" ctype="x-span" equiv-text="&lt;span class=&quot;wysiwyg-color-purple110&quot;&gt;"><g id="2" ctype="x-strong" equiv-text="&lt;strong&gt;">Ticket Id</g></g>, <g id="3" ctype="x-span" equiv-text="&lt;span class=&quot;wysiwyg-color-purple110&quot;&gt;"><g id="4" ctype="x-strong" equiv-text="&lt;strong&gt;">Ticket Text Field Change</g></g>), 0) WHERE <g id="5" ctype="x-span" equiv-text="&lt;span class=&quot;wysiwyg-color-purple110&quot;&gt;"><g id="6" ctype="x-strong" equiv-text="&lt;strong&gt;">[Text Field] New Value<g id="7" ctype="x-span" equiv-text="&lt;span class=&quot;wysiwyg-color-orange&quot;&gt;"><g id="8" ctype="x-strong" equiv-text="&lt;strong&gt;"> IN (</g></g>[Status] solved</g></g>, <g id="9" ctype="x-span" equiv-text="&lt;span class=&quot;wysiwyg-color-orange&quot;&gt;"><g id="10" ctype="x-strong" equiv-text="&lt;strong&gt;">[Status] closed</g></g>) AND <><g id="13" ctype="x-span" equiv-text="&lt;span class=&quot;wysiwyg-color-orange&quot;&gt;">[Text Field] Previous Value <g id="14" ctype="x-strong" equiv-text="&lt;strong&gt;"><g id="11" ctype="x-span" equiv-text="&lt;span class=&quot;wysiwyg-color-purple110&quot;&gt;"><g id="12" ctype="x-strong" equiv-text="&lt;strong&gt;"></g></g>[Status] solved </g></g>AND <g id="15" ctype="x-span" equiv-text="&lt;span class=&quot;wysiwyg-color-purple110&quot;&gt;"><g id="16" ctype="x-strong" equiv-text="&lt;strong&gt;">Ticket Status <g id="25" ctype="x-span" equiv-text="&lt;span class=&quot;wysiwyg-color-purple110&quot;&gt;"><g id="26" ctype="x-strong" equiv-text="&lt;strong&gt;">IN (</g></g>Solved<g id="19" ctype="x-span" equiv-text="&lt;span class=&quot;wysiwyg-color-orange&quot;&gt;"><g id="20" ctype="x-strong" equiv-text="&lt;strong&gt;">, <g id="17" ctype="x-span" equiv-text="&lt;span class=&quot;wysiwyg-color-orange&quot;&gt;"><g id="18" ctype="x-strong" equiv-text="&lt;strong&gt;">Closed</g></g>) AND</g></g> Date (Event)<g id="21" ctype="x-span" equiv-text="&lt;span class=&quot;wysiwyg-color-purple110&quot;&gt;"><g id="22" ctype="x-strong" equiv-text="&lt;strong&gt;"> = (SELECT MAX(SELECT <g id="27" ctype="x-span" equiv-text="&lt;span class=&quot;wysiwyg-color-purple110&quot;&gt;"><g id="28" ctype="x-strong" equiv-text="&lt;strong&gt;">Date (Ticket Solved) </g></g>BY <g id="23" ctype="x-span" equiv-text="&lt;span class=&quot;wysiwyg-color-purple110&quot;&gt;"><g id="24" ctype="x-strong" equiv-text="&lt;strong&gt;">Ticket Id</g></g>) BY </g></g>Ticket Id</g></g>)

    0

Inicie sesión para dejar un comentario.

Tecnología de Zendesk