# `Fun_GetListBy_BysCombineChild` (function)


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

## Parameters

| # | Mode | Name | Type |
|---|---|---|---|
| 1 | IN | `sCombineChildControlId` | `longtext` |

## Body

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

## Narrative

**Business context:** Combined-parts label builder used by the work-order data-pack reports. When a work-order has a 拼版 / combine layout that ganged-up several child parts, this function renders the part-name list (joined by `+`) for the work-order report row.

**What it does:** splits the comma-separated `sCombineChildControlId` via `Fn_split_string`, looks up `sPartsName` from `mftworkordercontrol` for each id, and concatenates with `+` separators. Returns empty string if no ids.

**Invocation:** called by `Sp_reportdata_WorkOrder`, `Sp_reportdata_WorkOrder1`, `Sp_reportdata_WorkOrder3` against `A.sCombineChildControlId` and `B.sCombineChildControlId` when rendering work-order print-data packs.
