SugarPro 624 : Custom Sugarwidget type field in Reports filters

[yannick038]

Hello all,

We're using SugarPro 624 and have created new fields to extend the base types of SugarCRM

So we created a new fields' type "customType" (for example), and we added a new field of this given type to accounts using studio. This works well for edit/detail/list/search view.

But we are using reports too, and so we wanted to filter's the results of the accounts using this new field.

But when I'm trying to add the filter critera there's a problem in reports.js as the type "CustomType" is not definied in filter_defs[] javascript array.

And so, as it's not defined, there's no filter's input, nor delete filter link, the module is freezed and we need to reload the page loosing all modifications. I've searched through all sugar code, to look where this filder_defs array could been defined but didn't find it (there's template.php in reports module, but I think this is old code not used anymore ?)

I think we need to modify the reports module to tell sugar there's a new field's type so I'm looking on how to perform this steps, what are the files and if we were able to make the changes in an upgrade-safe way.

If you have any information, thanks in advance for sharing it.

Regards

[Captivea]

Reports modules uses a JS cache file generated by PHP file to store all the fields defs per module and the filter's available per Sugarwidget type.

Problem is that the code is not dynamic and so adding a new type using module loader will result in patching the PHP file in a not upgrade-safe way.

cached JS file : cache/modules/modules_def_<lang>_<md5>.js
php file generating the cache file : modules/Reports/templates/templates_modules_def_js.php

Maybe Sugar should try to make an opened and dynamically built cache file based also on custom types ?