select query在apache camel中搜索json文本

Question

我试图运行postgresql选择查询从数据库中获取json有效载荷。

{
"transactionId": "a9S4Y044545F71UAE",
"results": {
"overall": "PASS",
"documents": [
{
"documentId": "4d7cad3165a6-ce0d-49ae-bfd8-4d7cad3165a6",
"document": {
"country": "Australia",
"type": "Driver Licence",
"typeLabel": "Driver Licence"
},

"extractedData": {
"firstName": "ABC",
"lastName": "YUZ",
"cardType": "Driver Licence",

},
} ]
}
}

我的查询就像

SELECT doc_payload
from DB.doc_payload
where
jsonb_path_match(identity_verification,'exists($.results.documents[*].confirmedData.firstName ? (@ == "ABC"))')
and
jsonb_path_match(identity_verification,'exists($.results.documents[*].document.type ? (@ == "Driver Licence"))')

误差

Caused by: org.apache.camel.ResolveEndpointFailedException
There are 1 parameters that couldn't be set on the endpoint. Check the uri if the parameters are spelt correctly and that they are properties of the endpoint. Unknown parameters=[{ (@/" == "ABC"))') and jsonb_path_match(identity_verification,'exists($.results.documents[*].document.type ? (@/" == "Driver Licence"))')

Answer 1

SELECT doc_payload::text from DB.doc_payload where jsonb_path_match(doc_payload,'($.results.documents[*]. extractedData.firstName == "$simple{exchangeProperty.firstname}")') and jsonb_path_match(doc_payload,'($.results.documents[*].document.type == "$simple{exchangeProperty.doctype}")')