Hi,
I'm building queries for a low-code app. I have one query called "Top 10 CableTelemundo" that uses a left join with another query "VL CONV All2". However, I get this error when I visualize it as a table.
"VL Conviva All2" is the old name of the same query. Thinking that the query may have been corrupt, I recreated "Top 10 CableTelemundo" but I was still getting this error. Then I changed the name of "VL Conviva All2" to "VL CONV All2" but it keeps referring to a query that is no longer there.
Here is the "Top 10 CableTelemundo" query. As you can see, I am joining "VL CONV All2", not "VL Conviva All2" which no longer exists.
Below shows the table with the query "VL CONV All2". As you can see, the query is working.
How can I get around this bug? Has anyone encountered this before? I am on the verge of redoing all the queries in another version of the app but would prefer not to. Any help our guidance is appreciated.
Hello, that error typically occurs when a query that was deleted is still used in other queries.
Queries are identified by a unique id, and it's that id that is consumed by other queries. So creating new queries with the same name will not fix broken references.
I see your query also starts from another query "General Services Data". I suppose that query is not using any reference to that old query?
If that's not the case, you might be facing a software issue and a ticket can be created.
What version are you on? Depending on the root cause of the issue, it can typically be resolved by doing some manual file changes of the low-code app, without the need to recreate the queries from scratch.