Query by nested object does not work

default discord avatar
ivandominguezdomi11 months ago
5

Hello

@everyone

!



I am trying to do a rest api query on a collection using a nested object attribute



/api/tickets?where[order.orderId][equeals]=1363580640437-01


Tickets has this structure


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

And orders:


    fields: [
        {
            name: 'orderId',
            type: 'text',
            required: true,
            label: 'ID de Pedido',
        }
              ]
  • discord user avatar
    tylandavis
    11 months ago

    Hi @Iván Dominguez (Domi) , it looks like you have a typo in your query.

    [equeals]

    should be

    [equals]
  • default discord avatar
    ivandominguezdomi11 months ago

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

    equals

    and it does not work.

  • discord user avatar
    tylandavis
    11 months ago

    okay, let me take a closer look

  • default discord avatar
    ivandominguezdomi11 months ago

    thank you very much, do you need more information?

  • discord user avatar
    tylandavis
    11 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]
Star on GitHub

Star

Chat on Discord

Discord

online

Can't find what you're looking for?

Get help straight from the Payload team with an Enterprise License.