...
Issues & decisions
# | Issue | Notes | 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 : { | Syntax: <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 : { | Syntax: <cps-path> ( contains '[@leafname,'<string-partial value> ']' ) Examples
|
---|
|
Here , it search the books that contains '99' as sub string value in attribute pub_year. | |
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 : { | Syntax: <cps-path> ( contains '[@text(),' <string-value> ']' ) Examples
|
|
|
Query format for contains keyword
# | Query | Output |
---|---|---|
1 | cpsdb=# SELECT * FROM FRAGMENT WHERE anchor_id = 4 and attributes->>'title' like '%Feersum End%'; | 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->>'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 | |
3 | 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 | |