Removing Blank Data from Search Selection Box

This question is not answered
Sage Search.jpg

I am using Sage 7.3a. In case of search selection box, search list does not appear exactly below. Please advice. Also Please let me know how to remove blank data from the search list.

All Replies
  • Hi,

    Assuming the field name would be comp_partner:

    Go to that field to edit it in Administration -> Entity -> Field

    You will see a field name Search SQL, put "comp_partner is not NULL " in that field and hit Save

    Lets see if this works for you.

    Cheers!

    Sharad

  • Thanks Sharad for your reply.

    I have already tries your suggestion. When I use it, search result is almost missing (Just see single horizontal line).

  • The issue is around data in the table/view the advanced search select field is looking at. You need to investigate why there are blank data rows in the source data rather than try to suppress the output to the field.

    Sage CRM specialist and all round fan! Please feel free to follow me on twitter @dannycrm

  • Got a required result by doing modifications in "View Fields" and "Search SQL".