Here's how to find orphaned Personal Profile records

Got a question or comment about PowerChurch that doesn't belong anywhere else? Why not post it here!?

Moderators: Moderators, Tech Support

Locked
pbumc
Posts: 77
Joined: Sat Mar 10, 2007 4:28 pm
Location: San Diego, CA

Here's how to find orphaned Personal Profile records

Post by pbumc »

I had a situation where going from a Personal Profile record to the Family record brought up an unrelated family. I used this script from Utilities > Database Manager to confirm that the Personal Profile was not linked to a Family (its mail_no field is empty). In this case, the Personal Profile was a duplicate, so I merged the orphan into the other record to fix the problem.

Code: Select all

select ma.mail_no, me.mail_no, me.pers_no, me.lastname, me.firstname 
from me 
left outer join ma on me.mail_no = ma.mail_no 
where ma.mail_no is null 
order by me.lastname, me.firstname
For more tips and tricks about using the Database Manager, see this thread:

viewtopic.php?f=1&t=13911
Mark Berry

Locked