50 lines
1.1 KiB
Plaintext
50 lines
1.1 KiB
Plaintext
maintenance:
|
|
|
|
title: MLM_config_tool_reader;;
|
|
mlmname: MLM_config_tool_reader;;
|
|
arden: version 2.5;;
|
|
version: 5.50;;
|
|
institution: ;;
|
|
author: Allscripts Custom Services;;
|
|
specialist: ACS;;
|
|
date: 2011-08-11;;
|
|
validation: testing;;
|
|
|
|
library:
|
|
purpose: read the MLM Configuration Tool Tables and return site data.
|
|
;;
|
|
explanation:
|
|
;;
|
|
keywords:
|
|
;;
|
|
knowledge:
|
|
type: data-driven;;
|
|
data:
|
|
(MLM_name) := argument;
|
|
|
|
// pull all config data for this mlm
|
|
(var_id, mlm_var_list, site_config_name_list) := read
|
|
{"select c.var_id, c.MLMvar, "
|
|
||" case "
|
|
||" when l.allowmult = 0 then " //remove the beginning end quotes
|
|
||" substring(SiteConfigName, 2, datalength(SiteConfigName) - 2 ) "
|
|
||" else SiteConfigName " //leave quotes
|
|
||" end "
|
|
||" from ACSMLMLocalConfig c "
|
|
||" join AcsMLMlibrary l on c.var_id = l.var_id "
|
|
||" where c.MLMname like " || sql(MLM_Name)
|
|
||" and c.active = 1 "
|
|
||" and l.active = 1 "
|
|
};
|
|
;;
|
|
priority: 50
|
|
;;
|
|
evoke:
|
|
;;
|
|
logic: conclude true;
|
|
;;
|
|
action: return var_id, mlm_var_list, site_config_name_list;
|
|
;;
|
|
Urgency: 50;;
|
|
end:
|