Notifications
Clear all
Topic starter
Does anyone have a Quick Text that will pull all labs in past 30 days into the note?
Posted : August 4, 2016 5:47 am
I have done something similar in the past, but will need to find it.
To get started, you will use:
GET_FLOWSHEET_VALUES([FSV_path], [list_type])
To get a list of all, using the 'DELIM' list type, and passing all data to an array.
Posted : August 4, 2016 9:37 am
Here was the quicktext (set to only look at one item) that would show last ten and last 180 days of an OBS. So, answer to your question is a combination of these two.
{local sA1, a1, s1="", i=0, imax=0, edays=0
local mdays=180
sA1 = getfield(LIST_OBS("LDL","signed","list","valuedate"),")",HRET)
if size(sA1)<=10 then imax = size(sA1) else imax = 10 endif
s1=""
for i=1,i<imax,i=i+1 do
a1 = getfield(str(sA1[i])," ","")
a1[2] = sub(a1[2],2)
edays =durationdays(a1[2],str(._TODAYSDATE))
if edays<=mdays
then s1 = s1 + a1[2] + ", " + a1[1] + ", " + edays + HRET
else "" endif
endfor
s1
}
Posted : August 4, 2016 9:48 am
