Filter by multiple relation columns

[kirrg001]

CASE 1

{
  $and: [
                    {
                        'tags.slug': 'animal'
                    },
                    {
                        'posts_tags.sort_order': 0
                    }
   ]
};

"Filter all posts which are tagged with animal and it's the first tag"

This case is important.

CASE 2

{
  $and: [
                    {
                        'tags.slug': 'animal'
                    },
                    {
                        'tags.title': 'something'
                    }
   ]
};

"Filter all posts which are tagged with animal and the tag title is something".

This case is less important.

CASE 3 (combination)

{
  $and: [
    $and: [
                    {
                        'tags.slug': 'animal'
                    },
                    {
                        'tags.title': 'something'
                    }
     },
     {
        featured: true
     }
   ]
};

"Filter all posts which are tagged with animal and the tag title is something".

This case is important.

Known Problems

The architecture must order where statements which belong together.

Futhermore: posts_tags is the many-to-many lookup table of posts and tags. If you pass posts_tags.sort_order, we first check if the table name is a relation, if not, we check if the table name is a join table. I think this could work.

Tasks

• play with the cases
• implement

[kirrg001]

We can open a new issue if there are more cases.