Notifications
Clear all
Topic starter
Does anyone know where I could find this information:
Patient First Name, Last Name, Email Address.
I looked in the KUser table and found the fields: Firstname, Lastname, Username but the username field is not all email addresses.
Thanks!
Posted : August 28, 2015 6:36 am
Which portal are you using? Medfusion has a report of all the patients in their portal. If not medfusion you might want to check with your portal company.
Posted : August 28, 2015 6:52 am
The Person table is what you're looking for I believe.
Posted : August 28, 2015 7:17 am
Topic starter
We are using Kryptiq's Patient Portal.
Posted : August 28, 2015 8:25 am
Topic starter
It looks like in the Enterprise DB there is a table called KEmailAddress which has the user ID and email address. Then the Kuser table has the user ID and first name and last name. I just don't know how to query and have the system match up the user ID's from both tables to combine the data.
Posted : August 28, 2015 8:41 am
Topic starter
Ron helped me come up with:
SELECT
u.FirstName,
u.LastName,
e.EmailAddress
FROM KUser u
INNER JOIN KEmailAddress e
ON u.UserID = e.UserID
Which gave me exactly what I was looking for.
Posted : August 28, 2015 9:19 am
I thought you could get this report within the Kryptiq portal website as Admin?
Posted : August 31, 2015 2:13 am
