Notifications
Clear all
Topic starter
We are using the Kryptiq patient portal (their name may have changed) and I am wondering what kind of reporting anyone can get out of it? Our admin would like to be able to report on the number of patients accessing the portal and the number of new patients joining the portal each month. The number of messages the staff receive and respond to and which staff login and are utilizing the portal.
I have reviewed the reports in the user administration area through CPS and find the reports are a bit lacking. I am curious how others are reporting.
Thanks!!
Posted : December 30, 2015 11:37 am
Built-in reporting is pretty lame.
We run SQL queries on the Enterprise database on the portal's server.
A couple of sample queries:
SELECT KEmailAddress.EmailAddress, KEmailAddress.LastUpdate, KUser.Name, KUser.Description, KUser.LastUpdate AS Expr1, KUser.Identifier, KUser.FirstName,
KUser.MiddleName, KUser.LastName, KUser.LastLogin, KUser.CreationDate, KUser.Flags, KUser.UserName, KUser.NotificationAddress
FROM KUser INNER JOIN
KEmailAddress ON KUser.UserID = KEmailAddress.UserID
SELECT m.ReceivedDate, m.SenderName, m.Sender, m.Subject, mi.IsRead, mi.EmailAddress, mi.RecipientName, mi.OriginalEmail
FROM Message m inner join MessageInstance mi on m.MessageGuid = mi.MessageGuid
WHERE
m.sender = '[email protected]'
and m.MessageStatus = 'MESSAGE_DELIVERED'
and mi.IsSender = '0'
and m.SentDate > '10/18/2015'
ORDER BY m.sentdate desc
Posted : December 31, 2015 4:38 am
They do not publish a database guide either so reporting is, unfortunately, a bit of a guess and check endeavor - and very frustrating at times.
We've asked them for it multiple times and have been denied every time.
Posted : December 31, 2015 4:56 am
Here's an earlier post where I loaded Crystal Reports that query the Enterprise database. Will require a bit of Crystal skill in order to link the reports to your internal db -- try this and let me know if it doesn't work: https://centricityusers.com/forum/anyone-reporting-on-response-time-for-secure-messaging/
Posted : December 31, 2015 4:17 pm
Julie
Is that something that you can show me at a time in the near future. As iam not as tech savy as you are?
Thanks
Terry
Posted : January 4, 2016 5:39 am
