get_config_data.md
1.13 KB
get_config_data (function)
- Type: FUNCTION
-
Returns:
varchar(50) - Deterministic: NO
- SQL data access: CONTAINS SQL
Parameters
| # | Mode | Name | Type |
|---|---|---|---|
| 1 | IN | sUserId |
varchar(100) |
| 2 | IN | sConfigSlaveId |
varchar(100) |
| 3 | IN | sKey |
varchar(100) |
Body
Body is not pre-cached. To inspect: mysql --defaults-file=~/.my.cnf -e 'SHOW CREATE FUNCTIONgetconfig_data'._
Narrative
Business context: Per-user dropdown-label resolver. Given a gdsconfigformslave.sId (a single dropdown row) and a JSON key, returns the localized display value matching the user's sftlogininfo.sLanguage setting.
What it does: Reads sLanguage from sftlogininfo for sUserId (default 'sChinese'), then selects sChineseDropDown / sBig5DropDown / sEnglishDropDown from the gdsconfigformslave row, and returns JSON_UNQUOTE(JSON_EXTRACT(dropdown, '$.<sKey>')).
Invocation: Status: appears orphaned. No form-master, gdsmodule, other-routine, or xly-src caller. Candidate for maintainer audit — overlaps Fun_Sis_GetConstNew which is the live i18n path.