Created a Query Builder query with a subquery. It runs fine and I can see the tables diagram for the subquery OK. I save the file and when it is opened again, I can no longer see the table diagram for the subquery. The query still runs OK and the generated main query still runs with the subquery, but I can't see the table diagram for the subquery.
Found that the issue only happens if i use the 'Open Query' button on the workflow toolbar at the bottom. If the query is opened using menu File | Open File.. the subquery table diagram displays OK.
Or when opening the query builder file (.TSM) the following error occurs:
"There has been an error while decoding the Where Condition part of the saved model. The model will open without the Where Condition."
WORKAROUND 1:
Use File | Open File... to open the .tsm Query Builder file.
WORKAROUND 2:
1. Open the query builder file (.TSM) that causes the error.
2. Right-click and remove the sub-query from the tree-view queries of the Query Builder.
3. Open a new query builder file that does contain a sub-query or will not produce the error.
4. Go back to query builder file where the subquery was removed and close it and then re-open it.
STATUS
Waiting for fix in a future release of Toad for Data Analysts
