# `Fun_RemoveJsonKey` (function)


- **Type:** FUNCTION
- **Returns:** `longtext`
- **Deterministic:** NO
- **SQL data access:** CONTAINS SQL

## Parameters

| # | Mode | Name | Type |
|---|---|---|---|
| 1 | IN | `sJson` | `longtext` |
| 2 | IN | `skey` | `varchar(50)` |
| 3 | IN | `sValue` | `varchar(50)` |

## Body

_Body is not pre-cached. To inspect: `mysql --defaults-file=~/.my.cnf -e 'SHOW CREATE FUNCTION `Fun_RemoveJsonKey`'`._

## Narrative

**Business context:** Generic JSON-array element remover used by the production-scheduling tree/Gantt builders to drop a single record matching `skey = sValue`.

**What it does:** Iterates the JSON array; the first element whose `$.<skey>` equals `sValue` is removed (`JSON_REMOVE`) and the modified array returned immediately.

**Invocation:** Called from `sp_manufacture_productionplaninfotrace`, `sp_manufacture_productionplaninfotrace1`, `Sp_Manufacture_ProductionPlanInfoTree_Base`, and `Sp_Manufacture_ProductionPlanInfoTree_Base_TC` — the production-plan info-tree builders that power the scheduling-board UI.