Retrieve accounts whose last name or first name is blank.

[pallavi_an]

Hi all,

I want to retrieve all accounts whose last name or first name is blank. I have to do this using BOL programming (BuilHeaderAdvancedSearch).

If we pass space as selection param it will fetch all accounts. Please suggest what i need to do.

Thanks and Regards,

Pallavi

[former_member188098 · Accepted solution]

HI Pallavi,

You can use filter method to filter the collection using parameter(first name & last name) name and its value(as space) after execution of get query result method.

code exp:-

CALL METHOD lr_col_iterator->filter_by_property

      EXPORTING

        iv_attr_name = 'Attrbute_name'  "" Your attribute name First name or last name

        iv_value     = '  ' .              ""  filter value (space  '  ' )

Regard