Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Migrating legacy filters to ad-hoc filters (Slices filter disappear after metadata DB upgrade) #7214

Closed
heisenberg1205 opened this issue Apr 3, 2019 · 3 comments
Labels
inactive Inactive for >= 30 days

Comments

@heisenberg1205
Copy link

Make sure these boxes are checked before submitting your issue - thank you!

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

Superset version

0.27

Expected results

While upgraded the Superset (0.15 to 0.27) if metadata DB is same then all the filters for slices in the new Superset(Upgraded one) should retain as they were in old Superset.

Is there a way to retain the filters for all slices/dashboards while upgrading the metadata DB ?

Actual results

All the filters stored in Metadata DB for slices in old version got disappear after we upgraded Superset and metadata DB from 0.15 to 0.27.

How filter model was there in Superset 0.15 -:
"flt_col_0": "",
"flt_col_1": "id",
"flt_eq_0": "",
"flt_eq_1": "1",
"flt_op_0": "in",
"flt_op_1": "in",
How filters model is there in Superset 0.27 -:
"adhoc_filters": [{"comparator": "Model TV", "expressionType": "SIMPLE", "clause": "WHERE", "fromFormData": true, "sqlExpression": null, "operator": "==", "filterOptionName": "filter_c2ih6juqp56_md3q9zf1ij", "subject": "id"}]

Steps to reproduce

@heisenberg1205 heisenberg1205 changed the title Slices filter disappear after metadata DB upgrade (Upgraded Superset version 0.15 to 0.27) Migrating legacy filters to ad-hoc filters (Slices filter disappear after metadata DB upgrade) Apr 4, 2019
@heisenberg1205
Copy link
Author

Hello,
Is there any solution exists for it ? We've lost all our filters after upgrade from 0.15 to 0.27.

@mistercrunch
Copy link
Member

We all migrated successfully. I'm not sure what's happening on your side. Can you try upgrade beyond 0.27? I'd recommend the latest in branch release--0.31 or lyftga

@stale
Copy link

stale bot commented Jun 4, 2019

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions. For admin, please label this issue .pinned to prevent stale bot from closing the issue.

@stale stale bot added the inactive Inactive for >= 30 days label Jun 4, 2019
@stale stale bot closed this as completed Jun 11, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
inactive Inactive for >= 30 days
Projects
None yet
Development

No branches or pull requests

2 participants