Truncate Category for Reporting and Views

[Rob]

We have nested profile categories setup which can display in reports as a long string e.g. Requests>Hornbill Service Manager>xxxxxx>yyyyy>zzzzz

Does anyone know if there is a way and how to truncate this in specific service reporting, views and dashboards so that only the zzzzzz is shown

I assume this must be possible as the ticket only shows the zzzz against the category with an "i" that can be hovered over with the full string (see screenshot below)

Thank you

[Rob]

I think the issue is that we are taking our self service form categories as a custom variable aligned to direct placement or simple lists (e.g. user selects product) to store the category ID as the value 

 

e.g. product zzzz = 1000 (profile ID assigned by system) ... store 1000 in h_custom_a ... use the workflow to update the actual category aligned to h_custom_a

 

This variable is storing the full string when mapped to category by the workflow (updateReqCategory) ... if we then run a view, create a chart or report that includes category we get the full string ... which just looks messy : (

 

Hope that makes sense and appreciate setups will vary

[Rob]

We can see from the ticket code below h_category_id is fetched and converted to name

Can we request an enhancement (tag added) to have this code available for charts aligned to views or use the translated display that is available from the simple list that drives the selection

Thank you

[katy_palmer]

@Victor Are you aware of anything on the backlog that will address this please?

 

[Victor]

@katy_palmer Sorry, no.