How to Collect Number of Tickets Only about autotask-samples HOT 9 OPEN

You want to query all tickets?

Like this?

sb.Append ("<queryxml><entity>Ticket</entity>").Append (System.Environment.NewLine);
sb.Append ("<query><field>id<expression op=\"greaterthan\">0</expression></field></query>").Append (System.Environment.NewLine);
sb.Append ("</queryxml>").Append (System.Environment.NewLine);

from autotask-samples.

Yes, you can do multiple queries "conditions" together.

QueryXML:
<queryxml> <entity>contact</entity>
<query> <condition>
<field>firstname
<expression op=”equals”>Joe</expression>
</field> </condition>
<condition> <field>lastname
<expression op=”equals”>Smith</expression> </field>
</condition> </query>
</queryxml>

Just review whatever entity you want to query and then you can query on any of the fields that it supports.

from autotask-samples.

Thanks mate.

When i used the query u give me. It only shows the dates from 2012 not the current year.
We currenlty using Autotask, Did i missed something?
Does the query have limit, it seems the length is only 500 queries?
Thank you.

from autotask-samples.

Yes that is true, You have to page through the results for each 500 entries.
You could also change the query to something like createDateTime greaterThan some date.

Have you seen the API Docs about creating queries?

from autotask-samples.

Thank you so much

from autotask-samples.

How to i make this as queryxml?
"SELECT * from Ticket where CreatedDate >= 'Whole day ex.YYYY-MM-DD, will get all tickets within that day' AND 'select all ticket who have not been completed' "
Thank you

from autotask-samples.

Thank you very much.

from autotask-samples.

Hi Mate,
How can i retrieve the ticket history of a ticket and how would i get the task of a ticket?

from autotask-samples.

@abon22 have you looked at the Web Services API Documentation? It basically outlines all these questions. You usually have to get the Service Call, or Resource and then track down through associations to get this information.

from autotask-samples.