Return
-
Title
Visualizing a query in Query Builder removes calculated 'NULL AS' columns -
Description
In the Query Builder, when visualizing a query, all the calculated fields with NULL disappear. e.g.
Paste a SQL statement into the the Query tab of the Query Builder. Then click the 'Visualize the SQL statement in the Query Tab'
SELECT COL1,
COL2,
NULL AS COL3,
NULL AS COL4FROM tablename
Only shows COL1 and COL2 in the diagram
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.