Report Configure Function Field help - Returning sys_id instead of value

[Maria20]

The requirement is to group a number of CIs on a report based on the first 6 letters of the CI.  So, I tried using the configure function field builder and used this code:

glidefunction:substring(cmdb_ci,'1','6')

The problem is that the function is returning the first six letters of the sys_id and not the actual value of the CI.  I've tried dot walking to the value and using GetValue() but it indicates that that those functions are not supported.  See screenshot:

Can anyone help?  TIA

[Jaspal Singh]

What did you select as Return type?

Can you change it to Field Name as below

[Maria20]

Hello Jaspal,

Thank-you for the response.

I originally had "Text" as the Return Type.

I tried changing it to "Field Name" as indicated, but no-go.  Same result. 😞

Maria.

[Maria20 · Accepted solution]

For those interested in a fix for this...

I filed a ticket with HI and they recommended that I add a field to the cmdb_ci table which contained the glidefunction substring function there.  Then, use the field itself as the Group By criteria.  Some screenshots to help explain:

Hope this helps others that may be experiencing the same problem.

Maria.

[G_30]

Hi I tried this but still had no luck, it is still showing sys_id instead of value, did you create other configuration than this? Please advice. thank you!