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

Text Component Error

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

5 Posts

3 Users

0 Reactions

65 Views

RSS

mvolkert

(@mvolkert)

Posts: 143

Reputable Member

Topic starter

I am trying to pull the patient's last DOS into a text component using the following code...

{IF(APPT_PRIOR() "") THEN sub(str(APPT_PRIOR()), 1, 10) ELSE "" ENDIF}

When the patient has a prior appointment it works just fine, however if they haven't been in yet, instead of getting a blank, I am getting this error...

{IF(APPT_PRIOR() "") THEN sub(str(APPT_PRIOR()), 1, 10) ELSE "" ENDIF <-Bad length

Any help would be much appreciated. Thanks!

Posted : June 12, 2017 4:14 am

bhoover

(@bhoover)

Posts: 360

Honorable Member

You are missing an operator in your if statement. You want something like this:

{IF(APPT_PRIOR() <> “”) THEN sub(str(APPT_PRIOR()), 1, 10) ELSE “” ENDIF}

With out the <> it sounds like it is just returning as true based on the error you are seeing.

Posted : June 12, 2017 4:42 am

mvolkert

(@mvolkert)

Posts: 143

Reputable Member

Topic starter

The formula I'm using does have the
For some reason it didn't copy over into my original post.

Posted : June 12, 2017 4:47 am

Lee

(@lee-cooper)

Posts: 348

Reputable Member

Try:

{IF(APPT_PRIOR() <> “”) and (size(APPT_PRIOR()) >= 10 THEN sub(str(APPT_PRIOR()), 1, 10) ELSE “” ENDIF}

Since we know the forum here loves to strip out operation text:

if APPT_PRIOR() doesn't equal "" and size(APPT_PRIOR() is greater than or equal to 10) then ...

I believe that the data symbol returns a blank space (if memory serves correctly), which is not the same as being NULL, hence why you are seeing that error. The addition of the size check will ensure that the value returned is at least 10 characters, which is required for the sub function.

Footnote - whenever using sub, it is always a good idea to check the size of the string before invoking it, otherwise it will throw an error. If the size is less than 'expected', you might use 'else userok("Unexpected Data Format, Please screenshot and notify (whomever) of this error" + HRET + string value here)'. It will aid in determining an appropriate course of action.

Hope this helps!

Posted : June 12, 2017 5:10 am

mvolkert

(@mvolkert)

Posts: 143

Reputable Member

Topic starter

That worked perfectly. Thanks!

And great idea, I'll keep that in mind.

Posted : June 12, 2017 5:45 am

Share:

24 Forums
9,940 Topics
39.9 K Posts
4 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