CiviCRM Community Forums (archive)

In Search Builder I can put in a search for Individual + On Hold = 1

This is good.

But if I try to extend it to find non-primary emails On Hold it falls over. I.E. if I do the above for Home instead of Primary it presents me with this. Is this behaviour to be expected? Or is there a tweak required on my search ... or ...
Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> -19
    [message] => DB Error: no such field
    [mode] => 16
    [debug_info] => SELECT DISTINCT UPPER(LEFT(contact_a.sort_name, 1)) as sort_name  FROM civicrm_contact contact_a
LEFT JOIN civicrm_email `Home-email` ON contact_a.id = `Home-email`.contact_id AND `Home-email`.location_type_id = 1 AND `Home-email`.is_primary = 1   
LEFT JOIN civicrm_location_type `Home-location_type` ON (  ( `Home-email`.location_type_id = `Home-location_type`.id ) )  WHERE  (  ( LOWER( `Home-address`.on_hold ) = '1' AND contact_a.contact_type IN ('Individual') )  )  AND  ( 1 )   GROUP BY contact_a.id   [nativecode=1054 ** Unknown column 'Home-address.on_hold' in 'where clause']
    [type] => DB_Error
    [user_info] => SELECT DISTINCT UPPER(LEFT(contact_a.sort_name, 1)) as sort_name  FROM civicrm_contact contact_a
LEFT JOIN civicrm_email `Home-email` ON contact_a.id = `Home-email`.contact_id AND `Home-email`.location_type_id = 1 AND `Home-email`.is_primary = 1   
LEFT JOIN civicrm_location_type `Home-location_type` ON (  ( `Home-email`.location_type_id = `Home-location_type`.id ) )  WHERE  (  ( LOWER( `Home-address`.on_hold ) = '1' AND contact_a.contact_type IN ('Individual') )  )  AND  ( 1 )   GROUP BY contact_a.id   [nativecode=1054 ** Unknown column 'Home-address.on_hold' in 'where clause']
    [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT DISTINCT UPPER(LEFT(contact_a.sort_name, 1)) as sort_name  FROM civicrm_contact contact_a
LEFT JOIN civicrm_email `Home-email` ON contact_a.id = `Home-email`.contact_id AND `Home-email`.location_type_id = 1 AND `Home-email`.is_primary = 1   
LEFT JOIN civicrm_location_type `Home-location_type` ON (  ( `Home-email`.location_type_id = `Home-location_type`.id ) )  WHERE  (  ( LOWER( `Home-address`.on_hold ) = '1' AND contact_a.contact_type IN ('Individual') )  )  AND  ( 1 )   GROUP BY contact_a.id   [nativecode=1054 ** Unknown column 'Home-address.on_hold' in 'where clause']"]
)