process_union_list_query bug with offset

[Trelane]

Hi I'm not sure if you know about this or not, i discovered a bug with the target lists, when you go over 10 prospects and use the paging it doesnt work. (Using sugar 6 and Microsoft SQL)
There is a bug in process_union_list_query.

Shortly after:
if($rows_found != 0 or $parent_bean->db->dbType != 'mysql')
{
It does:
$index = $row_offset;

This results in it trying to offset the search results which are already offset, (the results only contain 10 results) so on page 2 you get no data displayed.
I simply swapped the line out for;
$index = 0;
and it is now displaying the paging data correctly.

Best Regards,
Mike

[jnassi]

Thanks Mike. I submitted bug #38886 on your behalf.

In the future, you can submit bugs at http://bugs.sugarcrm.com