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

Selection Criteria to Filter the Data in Group Not the Hidden Data

Trading Post

Last Post by Anonymous 1 second ago

7 Posts

3 Users

0 Reactions

62 Views

RSS

wsc27

(@sclayton)

Posts: 142

Estimable Member

Topic starter

I have a report showing the most recent OB & it's value by doing a record sort in ascending order. Then I put the recent OB & value into a group then set the remaining data underneath the group to hidden so it won't show up on the report. But when go to selection criteria it searches in the data values eventhough its set to "hidden". How can I have the selelction criteria to search by the data thats in the group only?

Thanks!

Posted : September 27, 2013 12:51 am

jjordet

(@jjordet)

Posts: 545

Honorable Member

can't. selection criteria compares to database data, not report data (displayed or suppressed).

Posted : September 27, 2013 4:18 am

wsc27

(@sclayton)

Posts: 142

Estimable Member

Topic starter

🙁 I was hoping it could be done. So there isnt a way to pull the most recent Observation for the given OBSHEAD.NAME without having to do record sort to have the unnecessary data as part of the report. I only need to pull the most recent OB for a certain OBSHEAD.NAME. ?????

Posted : September 27, 2013 4:26 am

jjordet

(@jjordet)

Posts: 545

Honorable Member

Connect the LASTLABS table to RPT_OBS by PID, HDID, & MAXLABDATE.

Posted : September 29, 2013 10:43 pm

wsc27

(@sclayton)

Posts: 142

Estimable Member

Topic starter

Thanks for your reply but I am not seeing LASTLABS or RPT_OBS in my list of tables. I am on Centricity 9.5????

Posted : September 29, 2013 11:19 pm

DavidShower

(@davidshower)

Posts: 1255

Noble Member

They are views.

Posted : September 29, 2013 11:57 pm

wsc27

(@sclayton)

Posts: 142

Estimable Member

Topic starter

Thanks!! When I put in the PERSON.SEARCHNAME, LASTLABS.MAXLABDATE, & OBSHEAD.NAME in the report. It lists the searchname more than once for the one OBSHEAD.NAME rather than listing it one time with the latest lab date (LASTLABS.MAXLABDATE) as I thought it would? The goal I am trying to get at is to list the patient once with the max lab date with its lab value for the OB rather than having to hide/surpress the duplicate patient names.

Posted : September 30, 2013 12:08 am

Share:

24 Forums
9,942 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