UFN_UTIL_GETVALUEBYNAMEINJSON
This is a utility function to get value from name in JSON, mainly used in form engine layout xml
Return
| Return Type |
|---|
| varchar(max) |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @input | nvarchar(max) | IN | |
| @name | varchar(50) | IN |
Definition
Copy
create function dbo.UFN_UTIL_GETVALUEBYNAMEINJSON(@input nvarchar(max), @name varchar(50))
returns varchar(max)
as begin
declare @nameWithQuote as varchar(60) = '"'+@name+'":"'
declare @startingPosition as int = charindex(@nameWithQuote, @input)+len(@nameWithQuote)
return substring(@input,@startingPosition, cast(charindex('"',@input, @startingPosition) as int) -@startingPosition)
end