Issue with Filtering Using Logical Operators

[MainqueQwavee]

I'm experiencing issues with filtering using logical operators in our current implementation. Specifically, I'm trying to apply a filter where multiple conditions are combined using AND, and one of these conditions involves an OR between two fields. However, I haven't been able to get this working as expected.

Here's an example of what I'm trying to achieve:

Condition 1: Field A equals value X
Condition 2: (Field B equals value Y OR Field C equals value Z)
Condition 3: Field D is greater than value W

Currently, the library provides and and or fields. As I understand it, the and field is an array of filters where each filter is combined using AND comparatives, while the or field is another array of filters combined using OR comparatives. In my case, I need to use a combination of both.

However, the current implementation does not seem to support this structure, or there is a misunderstanding on how to properly use the logical operators in this context.

Example Query with TypeORM QueryBuilder

Let's assume we have an entity called ExampleEntity with the following fields: fieldA, fieldB, fieldC, and fieldD.
Here’s an example of the query using QueryBuilder in TypeORM:

async function getFilteredResults() {
  const repository = getRepository(ExampleEntity);
  
  const results = await repository.createQueryBuilder('example')
    .where('example.fieldA = :valueA', { valueA: 'X' })
    .andWhere(
      new Brackets(qb => {
        qb.where('example.fieldB = :valueB', { valueB: 'Y' })
          .orWhere('example.fieldC = :valueC', { valueC: 'Z' });
      })
    )
    .andWhere('example.fieldD > :valueD', { valueD: 'W' })
    .getMany();

  return results;
}

Questions:

Is the current implementation capable of handling logical operations like the one described above?
If so, could you provide an example of the correct syntax or approach?
If not, are there plans to support this functionality in the future?

Thank you for your assistance!

[Adrinalin4ik]

@MainqueQwavee Hey! Thanks for the feedback. Just implemented this feature in the 1.10.0 version https://github.com/Adrinalin4ik/Nestjs-Graphql-Tools/releases/tag/0.10.0

[MainqueQwavee]

Hi @Adrinalin4ik! Thank you so much for the quick update. I've tested the new feature in version 1.10.0, and it's working perfectly! I really appreciate your support and the quick turnaround.