I have a custom date field added to my Accounts module, followup_date. I have added the field to the search options for the Accounts module as well and it is working fine except for one situation:
When I search between a date range on followup_date I am shown the records I would expect in the list view. I then choose "Select All" and Actions > Export. The csv file that is produced as a result contains ALL of the Accounts in my database, not just those selected. This bug does not appear if I choose "Select This Page" or check them off individually, but this is not an ideal workaround for larger data sets. I have compared the SQL queries that are produced when exporting after choosing "Select All" vs "Select This Page" and found that the former seems to be missing part of the where clause. It just shows:

"where ( accounts.deleted IS NULL OR accounts.deleted=0 )"

instead of: "where (accounts.id in ... ) AND ( accounts.deleted IS NULL OR accounts.deleted=0 )"

Can anyone please help me fix this? I am using Sugar Version 6.3.0 (Build 7004)

Thanks,
John