Fishbowl
Tables
(current)
Columns
Constraints
Orphan Tables
Routines
CustomFieldByName
Parameters
Name
Type
Mode
jdoc
json
IN
name
text
IN
Definition
return json_unquote(json_extract(jdoc, json_unquote(replace(json_search(jdoc, 'one', replace(replace(replace(name, '!', '!!'), '%', '!%'), '_', '!_'), '!', '$.*.name'), '.name', '.value')))) COLLATE utf8mb4_unicode_ci