Adding custom fields of type Highlight in reports (error: class not found)

Hi all,

We have the following issue: there are two custom fields of the type 'Highlight' which were made by our developer to have color-coded cells in the user interface. That works fine. Now, these two fields contain relevant metadata to also include in our reports. Sadly, we are not able to include the fields in the reports, since Sugar produces the following error:

LayoutManager: Class not found:SugarWidgetFieldHighLightfield.

They are selectable in the report wizard, but when generating the report the above error is produced.

As a workaround, we thought about creating a new field of the type 'TextField' in the Studio, with a calculated formula that references the original field of the type 'Highlight'. That way we can just copy the data and use this copied field instead. However, in the formula wizard it is not possible to select these fields of the highlight type (not OOTB at least)... so on first sight it doesn't seem possible.

Does anyone have experience with this type of fields, and if so, can you share your experience/advice on how to best work with them?

We found following article/bug that might be related to this issue, which mentions to add the calculated formula directly in the vardef file and then run a Quick Repair and Rebuild. However, as an admin we only control the system via Studio and have no experience with writing in the vardef files directly, let alone where to find/edit/update them. Any help is much appreciated.

Thank you!

Parents
  • Reports use the widgets to control how it handles the field when selecting and processing the data. Based on the name of the field I suspect the developers have followed this guide as its the same field name. At the bottom you will see it references a widget, though I think from memory most of those methods are for filtering on the field which you may or may not want. But either way a custom widget is what you will need due to it being a custom field type.

    support.sugarcrm.com/.../

  • Hi Liam,

    Thank you for your insight. As it seems like this is a code-level customization, we will contact the developer to see how we can best resolve this. It may be an oversight from during the development phase. (It feels like one of those things that belongs to the category unknown unknowns... Not easy to spot during UAT.)

Reply
  • Hi Liam,

    Thank you for your insight. As it seems like this is a code-level customization, we will contact the developer to see how we can best resolve this. It may be an oversight from during the development phase. (It feels like one of those things that belongs to the category unknown unknowns... Not easy to spot during UAT.)

Children
No Data