Server - upstream fix for postgresql filter on jsonb arrays

[loredanacirstea]

jsonb array filter is not working properly in https://github.com/strongloop/loopback-connector-postgresql.

E.g. finding functions by input type: /pfunction?filter={"where":{"data.gapi.outputs.type":"address"}}

There is a temporary workaround in place now and the filter syntax looks like: /pfunction?filter={"where":{"data.gapi.outputs":{"inq":[{"type":"address"}]}}}. But it depends on a low-level query & limited filter support:

• https://github.com/pipeos-one/chainlens/blob/aa9109198079cea74890b4770bbd652285a3ee65/server/src/utils/filter.ts#L9

used in:

• https://github.com/pipeos-one/chainlens/blob/aa9109198079cea74890b4770bbd652285a3ee65/server/src/controllers/pfunction.controller.ts#L65
• https://github.com/pipeos-one/chainlens/blob/aa9109198079cea74890b4770bbd652285a3ee65/server/src/controllers/pfunction.controller.ts#L97
• https://github.com/pipeos-one/chainlens/blob/aa9109198079cea74890b4770bbd652285a3ee65/server/src/controllers/pclass.controller.ts#L65
• https://github.com/pipeos-one/chainlens/blob/aa9109198079cea74890b4770bbd652285a3ee65/server/src/controllers/pclass.controller.ts#L97

Ideally, this should be fixed upstream, the PostgreSQL connector.