Xata•10mo ago

Double filtering by table

Filtering by "chunk" fails and duplicate chunks occur.

13 Replies

kostas•10mo ago

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

АндрейOP•10mo ago

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

АндрейOP•10mo ago

This table is searched

АндрейOP•10mo ago

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

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

Original function

АндрейOP•10mo ago

there's no 'topic' column

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

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

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

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

АндрейOP•10mo ago

Thanks again! It worked!!!

kostas•10mo ago

Awesome, glad there's progress!

Gaming

Programming

Double filtering by table

Did you find this page helpful?