I am trying to get a report from WHD using the REST API using the example found here: http://www.webhelpdesk.com/api/#rest-support
The example I am refining is "Searching for Tickets" where you use the qualifier query parameter. The example shown for using "location.locationName" as the qualifier attribute works fine for me.
I want to change this attribute to search for tickets using a specific request type. Looking at the the list of variables it seems that the correct qualifier attribute to do this should be "problemtype.id" And the Request type ID is 33 based on what is listed in Setup -> Tickets -> Request Types.
I then inputted the query as:
Unfortunately this gets returned:
sqlStringForKeyValueQualifier: attempt to generate SQL for com.webobjects.eocontrol.EOKeyValueQualifier (problemtype.id = '33') failed because attribute identified by key 'problemtype.id' was not reachable from from entity 'JobTicket'.
It seems I can't access the request type attribute using /ra/Tickets ? Am I doing something wrong or can you advise if there's another way to do this?
Your help would greatly be appreciated.
Have resolved this through trial and error - the attribute name for Request Type is "problemTypeId"
Case sensitivity matters!
It's strange as the full ticket details show it as:
<problemtype id="33" type="RequestType">
<detailDisplayName>Repair &#8226; Computer</detailDisplayName>