Notifications
Clear all
Topic starter
I used to have a SQL script to remove a blank pharmacy from the contact list. Does anyone have one? Thank you.
Posted : January 9, 2020 3:47 am
Remove Line From Patient Contacts In Registration:
select * from patientprofile where patientid = 'XXXX'
select * from patientrelationship where patientprofileid = XXXX
Note ALL PatientRelationshipID's & Run new query
delete from patientrelationship where patientrelationshipid in (XXXX,XXXX)
If you run the query below again, it should return the remaining contacts
select * from patientrelationship where patientprofileid = XXXX
Posted : January 10, 2020 2:10 am
Topic starter
Thank you so much. I appreciate it.
Posted : January 10, 2020 5:59 am
