Exporting Reports to CSV taking lots of time

jrawoot · 17 March 2021 14:25

Hello Developers,
I have Case report with relate module columns with more that 1000 records.
While exporting report taking lots of time.
I got below link where mention “Use a joined query rather than related module bean loads”.
I’m not able to find where related module bean is loading. Can you please mention file name or any other solution for the same?

URL : https://github.com/salesagility/SuiteCRM/issues/8698

pgr · 17 March 2021 14:32

Why not do it directly from SQL? For large reports that would probably be wiser. You can quietly work on a nice joined query and then use some Reporting tool (like Excel or Access or many others) to get even nicer looking results.

jrawoot · 17 March 2021 14:46

Thanks for reply.
I have multiple reports. and it is not possible to write sql for every report in limited time.
and thats why i’m looking for core customization. can you please suggest file name where can i customize query.

Thanks,

pgr · 17 March 2021 16:27

I also don’t know where, I also posted a comment on that issue that you linked above asking that.

But I think that the code that builds the Reports query is very complex, since it allows for all the drag-and-drop options and builds it from there. I am not sure if you will be able to do anything there without spending a ton of time…

jrawoot · 18 March 2021 04:33

Thanks for your help. I also check in aor_reports files. But i don’t get any code which load related bean.

pgr · 18 March 2021 10:12

I’d say it’s probably this GetRelatedModule call

github.com

salesagility/SuiteCRM/blob/master/modules/AOR_Reports/AOR_Report.php#L1058


$path = unserialize(base64_decode($field->module_path));
$field_bean = new $beanList[$this->report_module]();
$field_module = $this->report_module;
$field_alias = $field_bean->table_name;
if ($path[0] != $this->report_module) {
    foreach ($path as $rel) {
        if (empty($rel)) {
            continue;
        }
        $field_module = getRelatedModule($field_module, $rel);
        $field_alias = $field_alias . ':' . $rel;
    }
}
$label = str_replace(' ', '_', $field->label) . $i;
$fields[$label]['field'] = $field->field;
$fields[$label]['display'] = $field->display;
$fields[$label]['function'] = $field->field_function;
$fields[$label]['module'] = $field_module;
$fields[$label]['alias'] = $field_alias;
$fields[$label]['format'] = $field->format;

which calls this

github.com

salesagility/SuiteCRM/blob/master/modules/AOW_WorkFlow/aow_utils.php#L149


    if (isset($data['module']) && $data['module'] != '') {
        return getModuleFields($data['module'], $view, $value);
    }
}
/**
 * @param string $module
 * @param string $linkFields
 * @return string
 */
function getRelatedModule($module, $linkFields)
{
    $linkField = explode(':', $linkFields, 2);
    $link = $linkField[0];
    $relatedModule = $module;
    if ($module === $link) {
        $relatedModule = $module;
    } else {
        $bean = BeanFactory::newBean($module);

which does a bunch of recursive work creating Beans as it goes along.