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

Function help, text translation

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

6 Posts

3 Users

0 Reactions

74 Views

RSS

Adam Daniel

(@adaniel)

Posts: 524

Prominent Member

Topic starter

{!
fn OrdersStat() {
local temp = getfield(ORDERS_NEW("Delimited"),"|","")
local hold
local rslt =""

for i=1, i<=size(temp),i=i+1 do
hold = getfield(temp[i],"^","")
if hold[12] =="S" then
if rslt <>"" then
rslt = rslt + hret
endif
rslt = + rslt + hold[1]
endif
endfor
return cfmt(rslt, ",1")
}}

This function populates my data display fine.

The trouble comes with the text. I doesn't populate unless I place the document on hold and reenter it.

Any thoughts?

Posted : October 30, 2015 9:53 am

jfitzmd

(@jfitzmd)

Posts: 419

Reputable Member

I recall vaguely this issue in the remote past. Just a thought, put rslt into a document field, use the field for your data display, translate the document field not the data display. Although you could use a global variable, these disappear on putting document on hold.

Posted : October 30, 2015 10:16 am

Adam Daniel

(@adaniel)

Posts: 524

Prominent Member

Topic starter

Not quite following, rslt into a document field? Like so, {!DOCUMENT.RSLT = OrdersStat()}? This seems to evaluate the function the same.

Posted : October 30, 2015 10:21 am

cecild

(@cecild)

Posts: 314

Reputable Member

Create a data display field and have it set to type= Mel Expression then use {OrdersStat()} this should call the function each time a field is updated.

You can hide this field so it doesn't show up on your form.

Posted : November 2, 2015 8:15 am

Adam Daniel

(@adaniel)

Posts: 524

Prominent Member

Topic starter

This is what I'm doing and it does update the display continuously but not the text translation.

Posted : November 2, 2015 8:55 am

Adam Daniel

(@adaniel)

Posts: 524

Prominent Member

Topic starter

Here was my solution:

Data display hooked to function:

{!fn OrdersStat() {
local temp = getfield(ORDERS_NEW("delimited"),"|","")
local hold
local rslt =""

for i=1, i<=size(temp),i=i+1 do
hold = getfield(temp[i],"^","")
if hold[12] =="S" then
if rslt <>"" then
rslt = rslt + hret
endif
rslt = "THIS ORDER IS STAT: " + hold[1] + hret + rslt
endif
endfor
return rslt
}}

in the data display text translation:

{if DOCUMENT.SHOW_IN_NOTE = "yes" then FMT(OrdersStat(), "1") else "" endif}

Created rad btn with "yes,no"

In white space trick the rad btn:

{if ORDER_LIST_CHANGES() <> "" then DOCUMENT.SHOW_IN_NOTE = "yes" else DOCUMENT.SHOW_IN_NOTE = "no" endif}

{if ORDER_LIST_CHANGES() <> "" then DOCUMENT.SHOW_IN_NOTE = "no" else DOCUMENT.SHOW_IN_NOTE = "yes" endif}

This allows the text translation to reevaluate to grab addition Stat orders.

Posted : November 2, 2015 9:41 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