Query Report "Nothing to show"

Hello, Community ERPNext!

I am try create new query report, but i can’t see the result


after “show report”

what am I doing wrong?

The result is accurate.

The report you presented here is one that you created as a new report. The problem is that you did not include any database queries in the code section at the bottom of the first screen shot. When you create a query report, it is assumed that you have knowledge of myslq syntax so that you can generate your own queries.

Try opening existing query reports to see examples of such code provided by the original report authors.

BKM

i am writed sql (1st picture):

select name from tabReport

i am try with formating, but it’s not work:

SELECT
tabReport.creation as “Date:Date:120”
FROM
tabReport
WHERE
tabReport.docstatus=1

after button “show report” i am try save, but i can’t

Installed Apps

ERPNext: v12.10.1 (version-12)
Frappe Framework: v12.8.4 (version-12)

i am try with dev mode - work
I can only write query with enable dev mode?

what will happen after “bench update”? will my report be deleted?