Versions Compared

Old Version 23

changes.mady.by.user Rudrangi Anupriya

Saved on

compared with

New Version 24

changes.mady.by.user Lee Anjella Macabuhay

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Native query for Contains Operator  using Like Keyword :

{  "lang": "en",   "price": 699,   "title": "The Golden Compass",   "authors": [            "Philip Pullman"  ],  "pub_year":1995 }                                                                                                 {  "lang": "English",   "price": 895,   "title": "Feersum Endjinn",   "authors": [             "Iain M. Banks"  ],  "pub_year":1994 }  
  •  


#

Issue

Notes

Decisions
1Which keyword to use ? Do we want case sensitivity or not? Do we follow the Xpath contains or do we become specific?
  • like %en% 
  • ilike %En% 
  • like 'en'

cpsdb=# SELECT * FROM FRAGMENT WHERE anchor_id = 4 and attributes->>'lang' ilike '%En%';

Query Response :

Code Block
titleJson Response
collapsetrue

  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.

...