Question

Is there a way to export the latest case description into Excel? As of now I've set up my filters using the Title w/ comments column, but when I use the Export to Excel feature, this just gives me a snippet of the case description.

I would like to separate the description into a separate column. If not, I'd at least like to show more of the description in the Title w/ Comments column.

Related:

Getting all events for each case in an Excel export.

Answer 1

The column in the case list will always truncate.

The workaround to get the full event text is to use the XML API to fetch all the columns you want for a list of cases and include the "latestEvent" option. Save the response as an XML file, then open it in Excel.

e.g. for the search "project:widget" showing title, latest event, project and area columns, try this (substituting your URL and TOKEN):

https://URL/api.asp?token=TOKEN&cmd=search&q=project:widget&cols=sTitle,sProject,sArea,latestEvent