Fun_getPartNameStatus.md
1.02 KB
Fun_getPartNameStatus (function)
- Type: FUNCTION
-
Returns:
longtext - Deterministic: NO
- SQL data access: CONTAINS SQL
Parameters
| # | Mode | Name | Type |
|---|---|---|---|
| 1 | IN | str |
longtext |
Body
Body is not pre-cached. To inspect: mysql --defaults-file=~/.my.cnf -e 'SHOW CREATE FUNCTIONFungetPartNameStatus'._
Narrative
Business context: Part-name path cleaner — given a ->-joined hierarchy like A#abc->B#xyz->C#qrs, strips everything after # in each segment and re-joins with ->, yielding A->B->C. Intended to drop status / suffix metadata from a part-name breadcrumb before display.
What it does: Counts -> separators, walks segment-by-segment with SUBSTRING_INDEX, applies Fn_split_string(seg, '#', 1) to each, and concatenates with ->.
Invocation: Status: appears orphaned. No caller found in any channel (form-master, gdsmodule hooks, other routines, xly-src grep beyond the routine's own deployment SQL) — candidate for maintainer audit.