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

return null value RPTOBS.OBSVALUE

Trading Post

Last Post by rspartos 11 years ago

8 Posts

3 Users

0 Reactions

69 Views

RSS

rspartos

(@rspartos)

Posts: 85

Estimable Member

Topic starter

I have a simple report that returns all patients who have an entry in a certain obsterm.

it looks something like:

{PERSON.DATEOFBIRTH} <= DateTime (1954, 04, 01, 00, 00, 00) and
{OBSHEAD.NAME} = "AD DISCUSSED" and
{RPTOBS.CHANGE} = 2.00

I changed it to return patients who have no entries in the AD DISCUSSED field:

{PERSON.DATEOFBIRTH} <= DateTime (1954, 04, 01, 00, 00, 00) and
{OBSHEAD.NAME} = "AD DISCUSSED" and
{RPTOBS.CHANGE} = 2.00 and

isnull({RPTOBS.OBSVALUE})

but the report returns nothing. Any pointers on how to capture patients with no entry? In EMR 9.5 it is as simple as saying 'AD DISCUSSED' is blank.

Posted : March 23, 2014 11:52 pm

joeg1962

(@joeg1962)

Posts: 843

Noble Member

Are you trying to find patients where:

1) AD DISCUSSED was written, but with a blank value,

or

2) AD DISCUSSED was never written

Posted : March 24, 2014 12:40 am

rspartos

(@rspartos)

Posts: 85

Estimable Member

Topic starter

I am trying to do something like the following:

The obshead.name = "AD DISCUSSED" and

rptobs.obsvalue = " "

does that make sense? Nothing is written to the "AD DISCUSSED" field, but the field exists.

Posted : March 24, 2014 4:06 am

joeg1962

(@joeg1962)

Posts: 843

Noble Member

So, if you run a report for "AD DISCUSSED", do you get any patients? Start with that report. Do this:

{PERSON.DATEOFBIRTH} <= DateTime (1954, 04, 01, 00, 00, 00) and
{OBSHEAD.NAME} = "AD DISCUSSED" and
{RPTOBS.CHANGE} = 2.00

displaying all the important fields.

If you can see 'blanks' for the OBSVALUE of some records, then you can try to trap for it. Beware that a null field is not the same as a field that is equal to " ".

Posted : March 24, 2014 9:08 pm

rspartos

(@rspartos)

Posts: 85

Estimable Member

Topic starter

Yes, that returns all the patients age 60 and over who have an entry in "AD DISCUSSED"

Does a similar code not work for you? It seems like a standard query to return values from a specific observation term {OBSHEAD.NAME} = "AD DISCUSSED" in a given field but restrict it to patients over the age of 60 {PERSON.DATEOFBIRTH} <= DateTime (1954, 04, 01, 00, 00, 00) and values that have been 'signed' {RPTOBS.CHANGE} = 2.00.

Posted : March 24, 2014 10:10 pm

joeg1962

(@joeg1962)

Posts: 843

Noble Member

I do not use that field, and I don't know what you have in the field when you think it is blank.

If you can see the records in your current report while not trying to use an 'isnull' or other, perhaps try a 'len()' function and look for a 0 (zero).

Posted : March 24, 2014 10:49 pm

baj

(@baj)

Posts: 99

Estimable Member

I believe this can easily be done using subreports. In the main report, use the PERSON table and give the condition to check for age. In the sub report, use RPTOBS and OBSHEAD tables, give the conditions

{OBSHEAD.NAME} = "AD DISCUSSED" and
{RPTOBS.CHANGE} = 2.00

Link the main report to the subreport by PID.

Hope this helps.

Posted : March 24, 2014 11:37 pm

rspartos

(@rspartos)

Posts: 85

Estimable Member

Topic starter

Joseph,

I am not familiar with len(), could you write an example of how the function works?

Baj,

Your subreport advice worked pretty well. My formatting is a little screwy, but the null values seem to be posting!

Thanks so much, both of you!!! Laugh

Posted : March 25, 2014 12:27 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