Xata•11mo ago

Double filtering by table

Filtering by "chunk" fails and duplicate chunks occur.

13 Replies

kostas•11mo ago

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

АндрейOP•11mo ago

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

АндрейOP•11mo ago

This table is searched

АндрейOP•11mo ago

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

kostas•11mo 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•11mo ago

Original function

АндрейOP•11mo ago

there's no 'topic' column

kostas•11mo 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•11mo ago

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

kostas•11mo 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•11mo ago

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

АндрейOP•11mo ago

Thanks again! It worked!!!

kostas•11mo ago

Awesome, glad there's progress!

Gaming

Programming

Double filtering by table

Did you find this page helpful?