Notifications
Clear all
Topic starter
We use a previous button in our VFE forms to bring in the values from the flow sheet via the data symbol function “OBSPREV”. I know that there have been formulas that scrub for an obs term based on a timeline but I am looking for something that does not require us to write an expression for each historical obs term. Does anyone have a function or formula that can in general bring in any obs term for a given date range? We do not want obs terms from the beginning of time. Currently, we use a combination of questions to filter but this is problem prone. Is there a formula or watcher expression that says for example only pull in all obs terms signed in the last 7 days?
Thanks...
Posted : June 2, 2014 5:37 am
I would try something like this
{fn OBSRECENT(term){
if DURATIONDAYS(LAST_SIGNED_OBS_DATE(term),sub(str(document.clinicaldate),1,10))<=7 then
return OBSPREV(term)
else
return ""
endif
}
}
Posted : June 2, 2014 5:58 am
