Fun_RemoveJsonEmptyKey (function)

• Type: FUNCTION
• Returns: longtext
• Deterministic: NO
• SQL data access: CONTAINS SQL

Parameters

#	Mode	Name	Type
1	IN	sJson	longtext

Body

Body is not pre-cached. To inspect: mysql --defaults-file=~/.my.cnf -e 'SHOW CREATE FUNCTIONFunRemoveJsonEmptyKey'._

Narrative

Business context: Filter-JSON sanitizer used by the production-scheduling Gantt/tree builders — strips list entries whose bFilterValue is blank or the placeholder null,null before the JSON is passed to a tree-rendering proc.

What it does: Iterates the JSON array; for each element extracts $.bFilterValue and removes that element when empty / null,null. Returns '' if the array empties out, otherwise the trimmed JSON.

Invocation: Called from sp_manufacture_productionplaninfotrace, sp_manufacture_productionplaninfotrace1, and Sp_Manufacture_ProductionPlanInfoTree_Base_TC — the production-plan info-tree builders (生产计划信息树 / 排产看板). These are themselves invoked dynamically from the scheduling front-end; no static Java caller exists.