'Querying an array in JSON with nested arrays in Postgres via sequelize

I have a complicated structure of a field in a column. I'm using Postgres@11 and [email protected].

This is my model:-

 id: {
    type: Sequelize.BIGINT,
    primaryKey: true,
    autoIncrement: true
  },
  extra: {
    type: Sequelize.JSONB,
    defaultValue: {}
  }

This is the structure of extra column:-

{
    "contentAreas": [
        {
          "name": "Foundations - Part 1",
          "moments": [
            157,
            159,
            160,
            161
          ],
        },
        {
          "name": "Foundations - Part 2",
          "moments": [
            163,
            164,
            165,
            166,
            167
          ]
        }
      ],
  }

I've an array of ids that I need to be queried on extra.contentAreas.moments. If an moment that is present in my array, it that is also present in the contentAreas.moments, I want to fetch that document.

This is my array:- [4, 56, 33, 161].

Any help will be appreciated. Thanks!

I tried this:- SELECT COUNT(*) as count FROM "public"."simulation" WHERE "extra.contentAreas" @> "moments" IN (2,34,3), but it is giving an error - column "extra.contentAreas" does not exist, because for some documents their is no contenAreas. Any suggestions on this?

javascriptnode.jspostgresqlsequelize.jspostgresql-11paypalpaypal-webhooks


Solution 1:[1]

Do it for the merchant accounts (2).

You'll need them to onboard and provide a REST clientid + secret so you can use those credentials to create transactions for them and register for the webhooks you want.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Preston PHX

Related Questions