Query by nested object does not work

ivandominguezdomi

2 months ago

5

fields: [
        {
            name: 'order',
            label: 'Order',
            type: 'relationship',
            relationTo: 'orders',
            required: true,
            unique: true,
        }
    ],

    fields: [
        {
            name: 'orderId',
            type: 'text',
            required: true,
            label: 'ID de Pedido',
        }
              ]

• 

  tylandavis

  Payload Team

  2 months ago

  Hi @ivandominguezdomi , it looks like you have a typo in your query.

  [equeals]

  should be

  [equals]
• 

  ivandominguezdomi

  2 months ago

  Sorry, it was my mistake when making the post, but in my tests I put

  equals

  and it does not work.

• 

  tylandavis

  Payload Team

  2 months ago

  okay, let me take a closer look

• 

  ivandominguezdomi

  2 months ago

  thank you very much, do you need more information?

• 

  tylandavis

  Payload Team

  2 months ago

  Okay I got it. For nested query strings, instead of using dot notation, use bracket notation.

  
  
  

  So, instead of

  [order.orderId]

  , use

  [order][orderId]