Xata•6mo ago

Double filtering by table

Filtering by "chunk" fails and duplicate chunks occur.

13 Replies

kostas•6mo ago

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

Андрей•6mo ago

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

Андрей•6mo ago

This table is searched

Андрей•6mo ago

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

kostas•6mo 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'
      },
    ]
  }
})

Андрей•6mo ago

Original function

Андрей•6mo ago

there's no 'topic' column

kostas•6mo 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 🙂

Андрей•6mo ago

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

kostas•6mo 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

Андрей•6mo ago

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

Андрей•6mo ago

Thanks again! It worked!!!

kostas•6mo ago

Awesome, glad there's progress!

Gaming

Programming

Double filtering by table