RodolpheG
RodolpheG
PostsComments
DTDrizzle Team
Created by RodolpheG on 11/14/2023 in #help
Help with query, how to use parent value in where condition ?
widgets.groupBrandCode seems to be the schema of the entity not it's value
4 replies
DTDrizzle Team
Created by RodolpheG on 11/14/2023 in #help
Help with query, how to use parent value in where condition ?
The query returns all the productFeedbacks for this product, but doesn't filter out the ones from an other groupBrand. It's like the where condition is not there 
{
  code: 'widget1',
  groupBrandCode: 'groupBrand1',
  product: {
    code: 'product1',
    productFeedbacks: [
      {
        groupBrandCode: 'groupBrand1',
        productCode: 'product1',
        order: 1,
        value: 'value',
        type: 'pro'
      },
      {
        groupBrandCode: 'groupBrand2',
        productCode: 'product1',
        order: 2,
        value: 'value2',
        type: 'pro'
      }
    ]
  }
}
{
  code: 'widget1',
  groupBrandCode: 'groupBrand1',
  product: {
    code: 'product1',
    productFeedbacks: [
      {
        groupBrandCode: 'groupBrand1',
        productCode: 'product1',
        order: 1,
        value: 'value',
        type: 'pro'
      },
      {
        groupBrandCode: 'groupBrand2',
        productCode: 'product1',
        order: 2,
        value: 'value2',
        type: 'pro'
      }
    ]
  }
}
4 replies