Zum Hauptinhalt springen

Report to generate ticket custom field IDs - Developer & Reporting / DPQL Examples - Deskpro Support

Report to generate ticket custom field IDs

Autorenliste

It can be useful to have a list of ticket custom field IDs to hand when building reports, especially if you don't have admin permissions on your helpdesk.

You can generate a list of titles and IDs in the stat builder using the DPQL below:


SELECT custom_def_ticket.title, custom_def_ticket.id

FROM custom_def_ticket


This will actually output all fields and also the IDs for the options available within them.

If you just want to output the top level fields you can add a WHERE clause as below :


SELECT custom_def_ticket.title, custom_def_ticket.id

FROM custom_def_ticket

WHERE custom_def_ticket.parent.title = NULL


You can build reports for other types of custom data fields as well.

For example you could create an equivalent report for user field IDs:


SELECT Custom_Def_People.title, custom_def_people.id

FROM Custom_Def_people


View our reporting documentation to see the other custom data tables you can reference.


Hilfreich Nicht hilfreich

4 von 7 Personen fanden diese Seite hilfreich

Fügen Sie einen Kommentar hinzu

Bitte loggen Sie sich ein oder melden Sie sich an, um einen Kommentar zu hinterlassen.

Benötigen Sie eine Passwort-Erinnerung?