Noob question: Filter in Xano

Options

Hi guys,

I have a table events that has a column called id_neighbourhood. And I have the table neighbourhood with the name of it.

I'm calling an API with an array with the neighbourhoods to use in the filter. That means I can get all the events in one or more neighbourhoods.

But when I do this search:




get this error:

Plase help :-) Thank you!

Tagged:

Answers

  • Chris Coleman
    Chris Coleman Administrator

    ADMIN

    Options

    Your area input is an object array, which means that it's expecting a format like this:

    {"name": "Chris",

    "email": "chris@email.com"}

    That means that we can't just search for a text string like it appears you're trying to do here. I would expect that it would be enough to change this input to an array of text strings instead.

  • Edgard
    Options

    That's what I'm doing. But one of the fields it's an array.

    {area: ["Southl","East"],

    city: Miami,

    end_date: 2023-02-19,

    begin_date: 2023-02-18

    }

  • Edgard
    Options

    I mean

    {

    "area": ["South","East"],

    "city": "Miami",

    "end_date": "2023-02-19",

    "begin_date": "2023-02-18"

    }

  • Edgard
    Options

    Solved. On Input I chose type of object when I has to choose Text with list structure.