Seal Report Forum
»
Report Edition
»
Reports
»
My Report not data,Would you help me?
Rank: Member
Groups: Registered
Joined: 11/10/2016(UTC) Posts: 14  Location: 江苏 Thanks: 2 times
|
I create bi report connect to mysql and had added a table to table list,
but i put column to page elements and run excute but no data,
so i found "View sql" :
"SELECT DISTINCT
ts_ty_project.project AS C0,
ts_ty_project.class AS C1,
ts_ty_project.realname AS C2,
ts_ty_project.xy AS C3
FROM ts_ty_project
WHERE 1=0
ORDER BY ts_ty_project.project ASC,ts_ty_project.class ASC,ts_ty_project.realname ASC,ts_ty_project.xy ASC
"
Why to have 'where 1=0'
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209  Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
well, the 1=0 is only added when showing and/or checking the SQL, it is only for performances reason.
The restriction is of course removed when executing the report...
|
 1 user thanked epf for this useful post.
|
|
|
|
Seal Report Forum
»
Report Edition
»
Reports
»
My Report not data,Would you help me?
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
