Skip to content

Conversation

@betodealmeida
Copy link
Member

SUMMARY

New solution to #25196.

When GENERIC_CHART_AXES is enabled some charts that were saved with granularity_sqla might have an incorrectly applied filter. For example, notice that this chart has no temporal filter defined:

Screenshot 2023-09-06 at 12-25-32 test

Screenshot 2023-09-06 at 12-25-39 test

But when loaded on a dashboard, a time filter is applied by default:

Screenshot 2023-09-06 at 12-24-53 test

With this fix, the query is generated correctly:

Screenshot 2023-09-06 at 12-25-22 test

BEFORE/AFTER SCREENSHOTS OR ANIMATED GIF

See above.

TESTING INSTRUCTIONS

ADDITIONAL INFORMATION

  • Has associated issue:
  • Required feature flags:
  • Changes UI
  • Includes DB Migration (follow approval process in SIP-59)
    • Migration is atomic, supports rollback & is backwards-compatible
    • Confirm DB migration upgrade and downgrade tested
    • Runtime estimates and downtime expectations provided
  • Introduces new feature or API
  • Removes existing feature or API

Copy link
Member

@michael-s-molina michael-s-molina left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Wow! Way better solution to the problem. Thank you for adding tests, I left some non-blocking comments to improve tests readability.

@michael-s-molina michael-s-molina added the v3.0 Label added by the release manager to track PRs to be included in the 3.0 branch label Sep 6, 2023
@betodealmeida betodealmeida added the merge-if-green If approved and tests are green, please go ahead and merge it for me label Sep 7, 2023
@betodealmeida betodealmeida merged commit 749274e into master Sep 7, 2023
jinghua-qa pushed a commit to preset-io/superset that referenced this pull request Sep 7, 2023
sebastiankruk added a commit to sebastiankruk/superset that referenced this pull request Sep 9, 2023
* fix: Issue apache#24493; Resolved report selection menu in chart and dashboard page (apache#25157)

* fix: DML failures in SQL Lab (apache#25190)

* fix: All values being selected in Select (apache#25202)

* docs: fix wrong type in PREFERRED_DATABASES example (apache#25200)

Signed-off-by: cmontemuino <[email protected]>

* docs: add CVEs for 2.1.1 (apache#25206)

* chore: back port 2.1.1 doc changes (apache#25165)

* feat(sqllab): Show sql in the current result (apache#24787)

* docs(FAQ): add answer re: necessary specs, copy-edit existing answer (apache#24992)

* fix: `is_select` (apache#25189)

* fix: Cypress test to force mouseover (apache#25209)

* fix(sqllab): Force trino client async execution (apache#24859)

* fix: granularity_sqla and GENERIC_CHART_AXES (apache#25213)

* chore: Convert deckgl class components to functional (apache#25177)

* fix: Cypress test to force mouseover (follow-up) (apache#25223)

* fix(docs): Fixing a typo in README.md (apache#25216)

* chore(read_csv): remove deprecated argument (apache#25226)

* chore(trino): remove unnecessary index checks (apache#25211)

---------

Signed-off-by: cmontemuino <[email protected]>
Co-authored-by: Sandeep Patel <[email protected]>
Co-authored-by: Hugh A. Miles II <[email protected]>
Co-authored-by: Michael S. Molina <[email protected]>
Co-authored-by: Carlos M <[email protected]>
Co-authored-by: Daniel Vaz Gaspar <[email protected]>
Co-authored-by: Elizabeth Thompson <[email protected]>
Co-authored-by: JUST.in DO IT <[email protected]>
Co-authored-by: Sam Firke <[email protected]>
Co-authored-by: Beto Dealmeida <[email protected]>
Co-authored-by: Rob Moore <[email protected]>
Co-authored-by: Kamil Gabryjelski <[email protected]>
Co-authored-by: yousoph <[email protected]>
Co-authored-by: Ville Brofeldt <[email protected]>
cccs-rc pushed a commit to CybercentreCanada/superset that referenced this pull request Mar 6, 2024
@mistercrunch mistercrunch added 🍒 3.0.0 Cherry-picked to 3.0.0 🍒 3.0.1 Cherry-picked to 3.0.1 🍒 3.0.2 Cherry-picked to 3.0.2 🍒 3.0.3 Cherry-picked to 3.0.3 🍒 3.0.4 Cherry-picked to 3.0.4 🏷️ bot A label used by `supersetbot` to keep track of which PR where auto-tagged with release labels 🚢 3.1.0 First shipped in 3.1.0 labels Mar 8, 2024
@mistercrunch mistercrunch deleted the fix_granularity_sqla branch March 26, 2024 18:03
vinothkumar66 pushed a commit to vinothkumar66/superset that referenced this pull request Nov 11, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

🏷️ bot A label used by `supersetbot` to keep track of which PR where auto-tagged with release labels merge-if-green If approved and tests are green, please go ahead and merge it for me preset:2023.35 size/L v3.0 Label added by the release manager to track PRs to be included in the 3.0 branch 🍒 3.0.0 Cherry-picked to 3.0.0 🍒 3.0.1 Cherry-picked to 3.0.1 🍒 3.0.2 Cherry-picked to 3.0.2 🍒 3.0.3 Cherry-picked to 3.0.3 🍒 3.0.4 Cherry-picked to 3.0.4 🚢 3.1.0 First shipped in 3.1.0

Projects

None yet

Development

Successfully merging this pull request may close these issues.

4 participants