Error in Exporting ALL Tasks

[bernyperera]

Hi Forum,

Sugarcrm 5.5.0 CE

I have included the "Created By" select option in the advanced search for Tasks.

I get the following SQL error when I try to export ALL tasks for a given "Created By" user.

It works fine if I select export page by page for the same "Created By" user.

Error exporting Tasks:
.SELECT tasks.* FROM tasks where (join_created_by_name.user_name like 'sampath%') AND tasks.deleted=0 ORDER BY tasks.name Query Failed:SELECT tasks.* FROM tasks where (join_created_by_name.user_name like 'sampath%') AND tasks.deleted=0 ORDER BY tasks.name::MySQL error 1054: Unknown column 'join_created_by_name.user_name' in 'where clause'

Please help me to get rid of this.

Thanks & Regards

Berny