When I am in any of the modules, I can search (filter) for things like FIELD NAME - STARTS WITH - some value. For example, I can find all leads where the company name starts with ACME. If I want to find all leads where the company name is blank, though, it seems impossible. The REPORTS module allows me to report on a field being empty, but if I want to bring up those companies in the Leads (or Contacts or Accounts or any other) module, I see no way to do it. Yes, in some cases I can sort by the field, but
1) That limits me to one field of filtering and
2) That brings up other values at the bottom of the list, which I can't have since I am doing mass updates and need the list to contain only records that meet my "null" or "empty" criteria.
I have tried searching for company-IS-space and company-IS-null or IS "" or BLANK or EMPTY. How can I do this search without writing new custom PHP pages? Surely, Sugar has a feature to allow end users to filter for records that are empty.