Getting error: Failed to execute 'only' on 'IDBKeyRange': The parameter is not a valid key.

[SpicyCatGames]

Title

Getting error: (message: "Failed to execute 'only' on 'IDBKeyRange': The parameter is not a valid key.", type: 'DataError')

Description

If I run the following query (this is after I call JSON.stringify() on the object):

{
  "from": "data",
  "skip": 0,
  "limit": 200,
  "order": {
    "by": "INDEX_NUM",
    "type": "asc"
  },
  "where": {
    "Field3": {
      "!=": "1.0"
    },
    "or": {
      "Field7": {
        "!=": "1.0"
      },
      "or": {
        "Field11": {
          "!=": "1.0"
        }
      }
    }
  }
}

I get this error:

(message: "Failed to execute 'only' on 'IDBKeyRange': The parameter is not a valid key.", type: 'DataError')

Don't mind the double quotes around the names. That's just the result of JSON.stringify().

Any help would be appreciated. Thanks!

[SpicyCatGames]

Please ignore the edits. There was another error before which was due to my middleware. I ripped away my middleware to isolate the problem, and what you see now is the issue I still have.

[SpicyCatGames]

Thinking the problem might be with != operator being paired with the or query, I tried the following:

{
  "from": "data",
  "skip": 0,
  "limit": 200,
  "order": {
    "by": "INDEX_NUM",
    "type": "asc"
  },
  "where": {
    "Field3": "1.0",
    "or": {
      "Field7": "1.0",
      "or": {
        "Field11": "1.0"
      }
    }
  }
}

This produces the following error:

{message: "No index found for column 'or'. Query can not be executed without index.", type: 'no_index_found'}

[ujjwalguptaofficial]

Extremely sorry for late reply, my github account was locked.

For multilevel nesting, it is recommended to build query with array.

check this example -

connection.select({
    from: "Table_Name",
    where: {
        Column1: value1,
        or: [
            {
                Column2: value2
            },
            {
                or:{
                    Column3: value3
                }
            }
        ]
    }
});

let me know if this also doesnot work.