Xata•9mo ago

Double filtering by table

Filtering by "chunk" fails and duplicate chunks occur.

13 Replies

kostas•9mo ago

Hi, in the screenshot the filter is on the column "chunk" but you're highlighting content in column chunk_number

АндрейOP•9mo ago

This is a different table and this column summarises the selected chunks.

АндрейOP•9mo ago

This table is searched

АндрейOP•9mo ago

Such filtering also gives an error. Or I am not making the query correctly.

kostas•9mo ago

The filter to exclude multiple chunks should be:

.filter({
  $not: {
    $any: [
      {
        chunk: '65'
      },
      {
        chunk: '78'
      },
      {
        chunk: '69'
      },
      {
        chunk: '66'
      },
    ]
  }
})

.filter({
  $not: {
    $any: [
      {
        chunk: '65'
      },
      {
        chunk: '78'
      },
      {
        chunk: '69'
      },
      {
        chunk: '66'
      },
    ]
  }
})

АндрейOP•9mo ago

Original function

АндрейOP•9mo ago

there's no 'topic' column

kostas•9mo ago

It will need to be refactored a bit to generate the filter like in my example above You can add the topic column, I just showed as an example how the chunk exclusion should look like 🙂

АндрейOP•9mo ago

I can't figure it out right off the bat 🙂

kostas•9mo ago

Here's an example including the topic:

.filter({
  $all: [
    {
      $not: {
        $any: [
          {
            chunk: "56",
          },
          {
            chunk: "54",
          },
        ],
      },
    },
    {
      $any: [{ topic: "12" }],
    },
  ],
})

.filter({
  $all: [
    {
      $not: {
        $any: [
          {
            chunk: "56",
          },
          {
            chunk: "54",
          },
        ],
      },
    },
    {
      $any: [{ topic: "12" }],
    },
  ],
})

Unless you actually want to exclude topics, in which case add a not to that as well

АндрейOP•9mo ago

Thank you! Now I'll think how to do it in a function ))

АндрейOP•9mo ago

Thanks again! It worked!!!

kostas•9mo ago

Awesome, glad there's progress!

Gaming

Programming

Double filtering by table

Did you find this page helpful?