# `Fun_AnalysisListJsonEnter` (function)

> 根据 JSON字符串LIST类型解析函数


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

## Parameters

| # | Mode | Name | Type |
|---|---|---|---|
| 1 | IN | `p_json` | `longtext` |
| 2 | IN | `cloumnNames` | `varchar(255)` |
| 3 | IN | `splitNames` | `varchar(10)` |

## Body

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

## Narrative

**Business context:** Variant of [`Fun_AnalysisListJson`](Fun_AnalysisListJson.md) tuned for work-order report rendering — on the last row of the JSON array it strips embedded newlines from the per-column suffix so the final display string doesn't end with a trailing line break.

**What it does:** same loop as `Fun_AnalysisListJson` (walks the JSON array, extracts `$[i].col` per column, joins with `splitNames` suffixes). The only difference is the special-case at `p_handle = p_length`: applies `REPLACE(splitName, '\n', '')` to the suffix.

**Invocation:** called only by the work-order data-prep reports `Sp_reportdata_WorkOrder`, `Sp_reportdata_WorkOrder1`, `Sp_reportdata_WorkOrder3`.
