# `Fun_GetListByJson_ByKey_split` (function)


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

## Parameters

| # | Mode | Name | Type |
|---|---|---|---|
| 1 | IN | `sJson` | `longtext` |
| 2 | IN | `sKey` | `varchar(100)` |
| 3 | IN | `sKeyValue` | `varchar(100)` |
| 4 | IN | `sGetKey` | `varchar(100)` |
| 5 | IN | `iNum` | `int` |

## Body

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

## Narrative

**Business context:** Pretty-printer for a JSON array of key/value objects with periodic line-break wrapping — same family as `Fun_GetListByJson_ByKey`, but inserts a `\n` every `iNum` items so long parameter lists wrap cleanly in a fixed-width report cell.

**What it does:** iterates `sJson`, extracts `$.sKey` and `$.sGetKey` from each element, strips quotes, and appends `name:【value】` joined by `;`. When the row index modulo `iNum` is zero (and not the first row), inserts `\n` before the next `;`. Returns empty string for invalid JSON.

**Invocation:** Status: appears orphaned. No caller found in any channel (form-master sSqlStr, gdsmodule hooks, other routines, exhaustive xly-src grep, dynamic-dispatch search) — candidate for maintainer audit.
