As per discussion , with Toine Siebelink Prefers Contains Xpath is case sensitive , So ilike keyword would be suitable to implement the contains query which support case sensitive attribute values.
Need to discuss with stakeholders.
#
Json Data
CPS-PATH Syntax
Output
1
Below is the sample data , Here are ways to use contains keyword :
As per discussion , with Toine Siebelink Contains Xpath is case sensitive , So ilike keyword would be suitable to implement the contains query which support case sensitive attribute values
3
cpsdb=# SELECT * FROM FRAGMENT WHERE anchor_id = 4 and attributes->>'lang' like 'en';
Code Block
title
Json Response
collapse
true
{
"lang": "en",
"price": 699,
"title": "The Golden Compass",
"authors": [
"Philip Pullman"
],
"pub_year":1995
}