Let's assume that we have the below code { "tasks": [ { "id": "task_1", "name": "task_1_name", "assignees": [ { "id": "assignee_1", "name": "assignee_1_name" } ] }, { "id": "task_2", "name": "task_2_name", "assignees": [ { "id": "assignee_2", "name": "assignee_2_name" }, {…
I have a two part question We have a PostgreSQL table with a jsonb column. The values in jsonb are valid jsons, but they are such that for some rows a node would come in as an array whereas for…
In PostgreSQL using jsonb column, is there a way to select / convert an attribute with actual datatype the datatype instead of getting it as a string object when using jsonpath? I would like to try to avoid cast as…
This works fine: jsonb_path_query(p.blah::jsonb, '$[*] ? (@.fruit == "banana") ') but if I want to compare the JSON "fruit" property to a value from a column, I cannot get Postgres to parse it, like so: jsonb_path_query(p.blah::jsonb, '$[*] ? (@.fruit ==…
I would like to create a dynamodb step using the resource arn:aws:states:::dynamodb:getItem where some attributes may not be available. The relevant portion of my task is as follows: "Get Config": { "Type": "Task", "Resource": "arn:aws:states:::dynamodb:getItem", "Next": "DummyPass", "Parameters": { "Key":…
I have a Dropwizard + Jdbi + Postgres 12 setup. I want to run following query with a SQL/Json Path Expression on a complex/nested JsonB column: try (Handle handle = jdbi.open()) { return handle.createQuery( "select data from company where" +…
For example: command kgp -o jsonpath='{range .items[]}{range @.spec.containers[]}{@.name}{"t"}{.items[].metadata.name}{"n"}{end}{"n"}{end}' output nginx istio-proxy sidecar-1 expected output nginx default istio-proxy default sidecar-1 default