15.10 - Example: JSONExtractValue with Filtered Results - Teradata Database

Teradata Database Teradata JSON

Product
Teradata Database
Release Number
15.10
Published
December 2015
Language
English (United States)
Last Update
2018-06-05
dita:mapPath
TeradataJSON_15_10.ditamap
dita:ditavalPath
ft:empty

This example shows how to use the JSONExtractValue method to filter results. This query gets the name of all persons older than 23.

JSONExtractLargeValue can be substituted for JSONExtractValue.
SELECT eno, edata.JSONExtractValue('$.[?(@.age > 23)].firstName') 
FROM my_table 
ORDER BY 1;
Result:
ENO edata.JSONExtractValue(…)
-----------------------------
1   Cameron	
2   ?          
3   Alex
4   David