Skip to main content

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

Report to generate ticket custom field IDs

Authors list

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.


Hjälpfull Oanvändbar

44 av 81 personer tyckte att sidan var användbar

Posta en kommentar

Please log in or register to submit a comment.

Need a password reminder?