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:

• chainlens/server/src/utils/filter.ts

  Line 9 in aa91091

  export function gapiFilter(tableName: string, filter: any = {}, select = '*') {

used in:

• chainlens/server/src/controllers/pfunction.controller.ts

  Line 65 in aa91091

  const lowlevelQuery = gapiFilter('pfunction', { where }, 'COUNT(*)');

• chainlens/server/src/controllers/pfunction.controller.ts

  Line 97 in aa91091

  lowlevelQuery = gapiFilter('pfunction', filter, '_id');

• chainlens/server/src/controllers/pclass.controller.ts

  Line 65 in aa91091

  const lowlevelQuery = gapiFilter('pclass', { where }, 'COUNT(*)');

• chainlens/server/src/controllers/pclass.controller.ts

  Line 97 in aa91091

  lowlevelQuery = gapiFilter('pclass', filter, '_id');

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