In an adhoc view created on CABI, you click on "view SQL query" button and nothing is displayed:
Also, the view does not show any data, and the message "Set the data mode to Sample or Full to see data" is displayed:
CABI 6.30, 6.43. 7.1.1
In the adhoc view, the "no data" option was selected in the dropdown menu:
In the dropdown menu, you must select "sample data" or "full data" to see both SQL query and report data displayed: