Dataset Query is Correct but Chart Query still shows oldest Query #20495
crosstowntraffic
started this conversation in
General
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
I know this question will go the route of my previous questions unresponded-to but I will try this blankety-thing one more time.
I cannot get rid of a first day of installing Superset query that starts like this --
SELECT
story_ID
ASstory_ID
,altersgruppe AS altersgruppe,
count(*) AS count,
count(collection_id) AS
COUNT(collection_id)
While the Dataset itself and all saved queries in the past 2 days start like this --
SELECT
story_ID
ASstory_ID
,altersgruppe AS altersgruppe,
count(*) AS count
When I edit a chart query, whether i give it as a new name or I save it as an overwrite of the existing named query I can never FIND the newly saved query if I give it a new name when I want to access it immediately and make sure I have updated the Query of a Chart -- no matter how I intiate a search for the newly saved query it does not display.
The way the Superset editor is set up If I have a Chart open in edit mode I see the OLDEST query if I click "View Query" in the right hand drop-down action selector.
If I click the SQL lab in the header to see the query I'm running I see the changes I made here correctly.
But when I return to the Chart editor to view my Chart in editing mode and once again click "View Query" in the right hand drop-down action selector I am going to see the old query from my setting up a Superset Dataset installation.
NOT even Editing the Dataset itself that I based my charts on makes any difference!
I have no assurance that my new query is running as I wrote it on this chart if "View Query" keeps popping up the old dataset query.
Even when I overwrite the Dataset itself in the Editor with the newly intended query to pull all of my table data it DOES NOT DELETE or OVERWRITE this Ghost Query!
Where can I go, into what file to finally correct what Superset is showing as the running query on my Charts when I click on "View Query"
And this OLD QUERY pops up in "View Query" even when I have edited the old dataset and updated it to my newer standards for retrieving the data from my table.
Thank you for any working response!
Beta Was this translation helpful? Give feedback.
All reactions