...
Issues & decisions
#Issue | Json DataNotes | Syntax | Decision | ||||||
---|---|---|---|---|---|---|---|---|---|
1 | In this example, we can identify the element by using leaf-name and leaf-value. In this cps-path expression leaf-name=lang and leaf-value=english. sample json data Below is the sample data , Here are ways to use contains keyword : { | Syntax: 1. <cps-path> ( contains '[@leafname,' <string-value> ']' ) Examples
| 2 | In this example, we can identify the element by using partial value of the attribute. In this cps-path expression partial value ‘en’ is used in place of english and science sample json data : {"test:bookstore":{ "bookstore-name": "Chapters", "categories": [ { "code": "01", "name": "SciFi", "books": [ { "authors": [ "Iain M. Banks" ], "lang": "
"price": "895", "pub_year": "1994", "title": "Feersum Endjinn" } ] }, { "name": "kids", "code": "02", "books": [ { "authors": [ "Philip Pullman" ], "lang": "Science", "price": "699", "pub_year": "1995", "title": "The Golden Compass" } ] } ] } }Syntax: <cps-path> ( contains '[@leafname,
| 3 | In this example, we can identify the element by using text() element and its value. In this cps-path expression leaf-name=title and leaf-value=The Golden Compass. sample json data : { |
| ]
Query format for contains keyword
# | Query | Output |
---|---|---|
1 | cpsdb=# SELECT * FROM FRAGMENT WHERE anchor_id = 4 and attributes->>' |
lang |
' |
like '%en%'; | 155 | /bookstore/categories[@code='01']/books[@title='Feersum Endjinn'] | {"lang": "en", "price": 895, "title": "Feersum Endjinn", "authors": ["Iain M. Banks"], "pub_year": 1994} | 4 | 154 | 5 | |
2 | cpsdb=# SELECT * FROM FRAGMENT WHERE anchor_id = 4 and attributes->>'pub_year' like '%99%'; | 153 | /bookstore/categories[@code='02']/books[@title='The Golden Compass'] | {"lang": "en", "price": 699, "title": "The Golden Compass", "authors": ["Philip Pullman"], "pub_year": 1995} | 4 | 152 | 5 | |
---|