x Want to participate? Join the group to interact
  • State Not Answered
  • Replies 1 reply
  • Subscribers 74 subscribers
  • Views 197 views
  • Users 0 members are here
Browse Forums
Announcements
105
topics
32
replies
General Discussion
6k
topics
18k
replies
deirdrec

Person showing under company "people" tab but not in main search?

Posted By

Hi

Can someone please help me. I have a problem in that a person exists if I go into the company and click on the people tab, but the individual person doesn't show up when I do a search? Any ideas as to why this could be and how I can fix it, other than to re-enter the individual contact for each person? In each case the person is the main contact for the company.

I suspect something may have happened when the data was imported, so while the person looks as though they exist, they infact do not?

  • 0

    Hi,

    Do you have access to the database? If you do, first thing I would do is run: -

    SELECT pers_deleted,*

    FROM Person

    where pers_firstname = 'Firstname' AND pers_lastname = 'Lastname'

    For one of the people you can see against the tab, but not find in the search.

    Check if the deleted flag is set to be 1. If it is, then it would seem the tab against the company is not checking the deleted flag, but, the search does.

*Community Hub is the new name for Sage City