I looking at generating some new helpdesk reports but I don't see any selection in the wizard for custom fields I have added.
For example I need to have the Location show in the report as our field tech do visit sites for some repairs.
Is there as way to add this or will I need to learn MySQL to have this show in a helpdesk report?
0 Comments   [ - ] Hide Comments


Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.
Answer this question or Comment on this question for clarity


You could definitely write the report in the SQL editor.

I would recommend that you open a ticket with support to troubleshoot this. If you do not have a support agreement to get the schema then you could use the wizard to give you the report and then tweak it in the SQL editor. In the database custom fields have a name of CUSTOM_FIELD_VALUEX where the field is called CUSTOM_FIELD(X+1)
Answered 10/16/2009 by: GillySpy
Seventh Degree Black Belt

Please log in to comment
Kace is telling me that this is a bug that they are working on. My support tech from Kace says he has a sql scrip I can use when I'm ready.
Answered 10/16/2009 by: kdasanmartino
Second Degree Green Belt

Please log in to comment