Parameter passing via URL Query String

[Kiranpatelbp]

Bug description

Here is a valid URL for id = 1, without the op key, which Superset interprets as ==:

http://localhost:8088/superset/dashboard/5/?native_filters=%7B%22filters%22%3A%5B%7B%22col%22%3A%22id%22%2C%22val%22%3A1%7D%5D%7D

Decoded:

{
"filters": [
{
"col": "id",
"val": 1
}
]
}

When I run the above URL, the dashboard is not filtering based on the condition ID=1. I.e. it showing all records in the table component.

Screenshots/recordings

No response

Superset version

master / latest-dev

Python version

3.9

Node version

16

Browser

Chrome

Additional context

No response

Checklist

• I have searched Superset docs and Slack and didn't find a solution to my problem.
• I have searched the GitHub issue tracker and didn't find a similar bug report.
• I have checked Superset's logs for errors and if I found a relevant Python stacktrace, I included it here as text in the "additional context" section.

[dosubot]

Hello @Kiranpatelbp! I'm Dosu, a bot here to help you solve bugs, answer questions, and assist you in becoming a contributor. I'm here while you wait for a human maintainer. How can I assist you today?

In Apache Superset, when no operation ('op' key) is specified in the filter configuration, the default behavior is to use the 'IN' operator for categorical filters ^[1]. This might be causing the issue you're experiencing, as the filter is not applying the expected equality condition (ID=1).

To resolve this, you can explicitly specify the 'op' key in your URL to ensure the correct operation is applied. For example, you can modify your URL to include the 'op' key with the '==' operator:

{
  "filters": [
    {
      "col": "id",
      "op": "==",
      "val": 1
    }
  ]
}

This should help in applying the filter correctly to show only the records where ID equals 1.

To continue talking to Dosu, mention @dosu.

---

^{Help Dosu learn! Give it feedback: Great Response | Irrelevant Answer | Incorrect Sources | Too Verbose | Hallucination | Bug Report | Other}

[rusackas]

The bot sounds right (let us know if you find otherwise). You can also use permalinks to a similar effect if that's your cup of tea. See this post for more info.