Welcome to the NEW CHUG— your ultimate destination for cutting-edge insights and discussions at the intersection of healthcare and technology.

Our platform is dedicated to exploring the dynamic landscape of healthcare technology, empowering professionals, enthusiasts, and innovators alike with the knowledge and resources to navigate the rapidly evolving field.

From telemedicine revolutionizing patient care to the transformative potential of artificial intelligence in diagnostics, we delve into a myriad of topics shaping the future of healthcare delivery. Whether you’re a seasoned healthcare IT professional, an aspiring entrepreneur in the digital health space, or simply curious about the latest innovations, our curated content, expert interviews, and thought-provoking articles provide a comprehensive exploration of healthcare technology’s most pressing issues.

Join us as we navigate the forefront of innovation, driving forward the transformation of healthcare for a healthier, more connected world.

Have questions or suggestions? Please use the contact button below.

Notifications

Clear all

Report to run on users preference

General Discussion

Last Post by Beth Ann 8 years ago

4 Posts

3 Users

0 Reactions

63 Views

RSS

Beth Ann

(@beth-ann)

Posts: 135

Estimable Member

Topic starter

Does anyone happen to have a report which will run a report on how users have their preferences set up as. We are trying to clean-up our banners and would be sure we do not remove any banners which may be selected as the preferences.

Thanks so much

Posted : June 7, 2016 5:47 am

gpincomb

(@gpincomb)

Posts: 278

Reputable Member

SQL Script to see who is using the Centricity Standard Banner:

select df.LAST, df.First, df.LoginUser, p.PREFNAME

from PREF p, DoctorFacility df

where p.PREFNAME like'%ban%'

and p.PREFNAME ='STANDARDBANNER'

and p.DoctorFacilityId = df.DoctorFacilityId

and df.Inactive = 0

and p.PREFVALUE <>'F'

SQL Script to see who are not using the Centricity Standard Banner and what Banner they are using:

select df.LAST, df.First, df.LoginUser, p.PREFVALUE

from PREF p, DoctorFacility df

where p.PREFNAME like'%ban%'

and p.PREFNAME <>'STANDARDBANNER'

and p.DoctorFacilityId = df.DoctorFacilityId

and df.Inactive = 0

Posted : June 7, 2016 6:23 am

jryan

(@jryan)

Posts: 119

Estimable Member

Here is one from emr. I have a crystal report also if you need it.

SELECT P.PREFNAME, P.PREFVALUE, U.SEARCHNAME, U.STATUS
FROM ML.PREF P INNER JOIN ML.USRINFO U ON P.GROUPID=U.PVID
WHERE U.STATUS='A' AND P.PREFNAME LIKE '%BAN%'
ORDER BY U.SEARCHNAME

Posted : June 7, 2016 7:02 am

Beth Ann

(@beth-ann)

Posts: 135

Estimable Member

Topic starter

If you would please send the Crystal Report to [email protected]

That would be terrific, thanks so much and have a wonderful rest of your week.

Posted : June 7, 2016 10:09 am

Share:

24 Forums
9,940 Topics
39.9 K Posts
0 Online
6,470 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo Powered by wpForo version 2.4.0