ID / Name label option for Native Filters

[polmonso]

Is your feature request related to a problem? Please describe.

In many DBs there's an ID / Name pattern. So the id is integer and name is String for human readable representation.

When using Native Filters you have to decide to use id field or String field,
but ideally you'd like to use the id field for the technical filter and
use the name for labelling only.

example table:

id	name	revenue
1	sports	1000
2	cars	3000
3	entertainment	20000

Benefits would be:

• User still sees a list of Strings to include (as if he selected name)
• preselecxt_fiter option could inject INTEGER values from the outside. This is especially useful from an integration perspective as normally APIs and applications that link directly into superset and want to preselect a filter will work on the ID rather than on the name
• imagine the name is changed -this would break the 'contract' between the url parameters and the DB values. The argument, it's based on the data is very weak as names are considered dimension data and thus any data tool should rely on the ID field.

Describe the solution you'd like
It would be great to have an option 'verbose column' (or similar) in the native filter's parameters. That column selection is optional, but would take care about the ID -> string mapping.

In the UI filter box a user would just see values like 'sports', 'cars', 'entertainment', but it could be controlled by preselect_filter using IDs 1, 2, 3.

Describe alternatives you've considered

If the 'verbose' field could be entered using a dedicated SQL expression
potentially controlled/secured by some JINJA templating, that would
maby more technical, but also more flexible.

This discussion is a copy of #19184 but updated to Native Filters. I didn't update the images, if it helps spring the discussion I'd do some mock ups.

[jaksmid]

Great idea, would make life a lot easier

[dimoha]

An additional and very important advantage of this approach is that, as it seems to me, there are usually indexes on IDs, and filtering by string will usually occur without an index

[linhmiyano99]

sound great, will you implement this feature soon ? @polmonso

[polmonso]

@linhmiyano99 I don't think I'll have time at the moment... Anybody can take it.

[TechAuditBI]

Well we've already implemented what looks like this feature almost exactly. I think we could contribute it to the upstream.

[ttauzo]

In which version it is available?

[TechAuditBI]

As for right now it is not available yet. I'll post a link to a PR as it is created. But you probably can expect this feature to appear in 4.0.1 and maybe in 3.1.2 but you should probably ask community member for a more certain answer.

[JealousyM]

As for right now it is not available yet. I'll post a link to a PR as it is created. But you probably can expect this feature to appear in 4.0.1 and maybe in 3.1.2 but you should probably ask community member for a more certain answer.

Has this update become available in any of the versions?

[LasseLegarth]

I can't find this in 4.0.1 - Any roadmap for when it will be here?