cannot be filtered using Verbose_name

[xuningyang]

A clear and concise description of what the bug is.

Columns and filters in the raw data cannot be filtered using Verbose_name
Dimensions in grouping aggregation can be filtered using Verbose_name
When filtering or selecting raw data columns, the last column cannot be displayed when there are too many columns

in Chinese：原始数据中列和筛选无法使用verbose_name进行筛选
分组聚合中维度可以使用verbose_name进行筛选
筛选或选择原始数据列时，当列过多时 最后一列无法显示

Expected results

Actual results

Environment

python: python 3.6
npm: 6.14.6
Superset 0.999.0dev
node:v12.18.3

Checklist

Make sure to follow these steps before submitting your issue - thank you!

• I have checked the superset logs for python stacktraces and included it here as text if there are any.
• I have reproduced the issue with at least the latest released version of superset.
• I have checked the issue tracker for the same issue and I haven't found one similar.

Additional context

Add any other context about the problem here.

[issue-label-bot]

Issue-Label Bot is automatically applying the label #bug to this issue, with a confidence of 0.74. Please mark this comment with 👍 or 👎 to give our bot feedback!

Links: app homepage, dashboard and code for this bot.

[zhaoyongjie]

@xuningyang 请问你的意思是说: 在 table viz 中的聚合tab中可以使用 verbose_name 进行搜索维度, 而非聚合 tab 无法使用verbose_name 搜索维度?
我有点没有理解您的问题.

please clearly ask your question. can not filter verbose name of dimension in no-agg-query tab ?

[xuningyang]

@xuningyang 请问你的意思是说: 在 table viz 中的聚合tab中可以使用 verbose_name 进行搜索维度, 而非聚合 tab 无法使用verbose_name 搜索维度?
我有点没有理解您的问题.

@zhaoyongjie 是的 在非聚合查询中 列和筛选字段都无法使用verbose_name进行搜索
且筛选字段若过多 最后一列无法显示

[zhaoyongjie]

@xuningyang Oh.... I reproduced it. it seems a UI bug.

[xuningyang]

@zhaoyongjie yes,but I don't know how to solve it

[xuningyang]

@junlincc 🙏

[zhaoyongjie]

I wil check codebase tonight

…

On Wed, Nov 4, 2020 at 4:12 PM xuningyang ***@***.***> wrote: @junlincc <https://github.com/junlincc> 🙏 — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#11545 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAPMKUX6ZST3WHNSNUYMANDSOEEFDANCNFSM4TJRFJRA> .

[zhaoyongjie]

Hi @xuningyang. this issue root cause is all_columns control is missing filterOption in plugin-chart-table. but this component populated in superset-ui repo.

In Chinese
plugin-chart-table 这个组件中的all_columns缺少filterOption选项(而这个插件在superset-ui仓库中, 并不在superset仓库). 您如果需要快速修复, 可以自行添加一下. 稍后我会提交该PR

[xuningyang]

嗨@xuningyang。此问题的根本原因是在plugin-chart-table中all_columns缺少控件filterOption。但是此组件已存储在superset-ui回购中。

在中文
plugin-chart-table这个组件中的all_columns过滤器选项选项（而此插件在superset-ui仓库中，并不在superset仓库）。您如果需要快速修复，可以自行添加一下。以后我会提交该PR

@zhaoyongjie Hi, I have another problem, when filtering, the field have verbose_name, but after selection, it still displays column_name,Could you please help to check it,thank you!
in chinese：
您好，我还有一个问题，当筛选时，字段存在verbose_name，但是选择后，显示的仍然为column_name，您能帮忙看下吗，实际应该显示verbose_name，我试图解决这个问题，但是未能解决

[junlincc]

resolved - closing

the second issue still open but I'm not sure we should display verbose name instead of actual column name. @xuningyang