Report identifier
"_SFR5oIilEd2vLpRtgJZmlg"
Analysis executed date filter from
Analysis executed date filter to
Analysis identifier
"__6n18P2mEd265aRYEVmmqg"
Logo file
0: Catalog 1: Schema 2: PostgreSQL
new Boolean(true)
SELECT TDQ_ANALYSIS.AN_UUID AS AN_UUID, TDQ_ANALYSIS.AN_LABEL AS AN_LABEL, TDQ_ANALYSIS.REP_UUID AS REP_UUID, TDQ_ANALYSIS.AN_CREATION_DATE AS AN_CREATION_DATE, TDQ_ANALYSIS.AN_AUTHOR AS AN_AUTHOR, TDQ_ANALYSIS.AN_DATA_FILTER AS AN_DATA_FILTER, TDQ_ANALYSIS.AN_STATUS AS AN_STATUS, TDQ_ANALYSIS.REP_CREATION_DATE AS REP_CREATION_DATE, TDQ_ANALYSIS.REP_LABEL AS REP_LABEL, TDQ_ANALYSIS.REP_AUTHOR AS REP_AUTHOR, TDQ_ANALYSIS.REP_STATUS AS REP_STATUS, TDQ_ANALYSIS.AN_BEGIN_DATE AS AN_BEGIN_DATE, TDQ_ANALYSIS.AN_END_DATE AS AN_END_DATE, TDQ_ANALYSIS.AN_VERSION AS AN_VERSION, TDQ_OVERVIEW_INDVALUE.TV_NAME AS TV_NAME, TDQ_OVERVIEW_INDVALUE.ELT_PK AS ELT_PK, TDQ_OVERVIEW_INDVALUE.IND_PK AS IND_PK, TDQ_OVERVIEW_INDVALUE.TV_CATALOGCOUNT AS TV_CATALOGCOUNT, TDQ_OVERVIEW_INDVALUE.TV_SCHEMACOUNT AS TV_SCHEMACOUNT, TDQ_OVERVIEW_INDVALUE.TV_TABLECOUNT AS TV_TABLECOUNT, TDQ_OVERVIEW_INDVALUE.TV_ROWCOUNT AS TV_ROWCOUNT, TDQ_OVERVIEW_INDVALUE.TV_KEYCOUNT AS TV_KEYCOUNT, TDQ_OVERVIEW_INDVALUE.TV_INDEXCOUNT AS TV_INDEXCOUNT, TDQ_OVERVIEW_INDVALUE.TV_TRIGGERCOUNT AS TV_TRIGGERCOUNT, TDQ_OVERVIEW_INDVALUE.TV_VIEWCOUNT AS TV_VIEWCOUNT, TDQ_OVERVIEW_INDVALUE.TV_TABLE_FILTER AS TV_TABLE_FILTER, TDQ_OVERVIEW_INDVALUE.TV_VIEW_FILTER AS TV_VIEW_FILTER, TDQ_OVERVIEW_INDVALUE.AN_RUNTIME AS AN_RUNTIME, TDQ_OVERVIEW_INDVALUE.AN_DURATION AS AN_DURATION, TDQ_ANALYZED_ELEMENT.ELT_CATALOG_NAME AS ELT_CATALOG_NAME, TDQ_ANALYZED_ELEMENT.ELT_SCHEMA_NAME AS ELT_SCHEMA_NAME, TDQ_ANALYZED_ELEMENT.ELT_CONNECTION_NAME AS ELT_CONNECTION_NAME, TDQ_ANALYZED_ELEMENT.ELT_UUID AS ELT_UUID FROM TDQ_OVERVIEW_INDVALUE TDQ_OVERVIEW_INDVALUE INNER JOIN TDQ_ANALYSIS TDQ_ANALYSIS ON TDQ_OVERVIEW_INDVALUE.AN_PK = TDQ_ANALYSIS.AN_PK INNER JOIN TDQ_ANALYZED_ELEMENT TDQ_ANALYZED_ELEMENT ON TDQ_OVERVIEW_INDVALUE.ELT_PK = TDQ_ANALYZED_ELEMENT.ELT_PK WHERE AN_UUID = $P{ANA_UUID} AND AN_RUNTIME = ( SELECT max(AN_RUNTIME) FROM TDQ_OVERVIEW_INDVALUE TDQ_OVERVIEW_INDVALUE INNER JOIN TDQ_ANALYSIS TDQ_ANA on TDQ_OVERVIEW_INDVALUE.AN_PK = TDQ_ANA.AN_PK where TDQ_OVERVIEW_INDVALUE.AN_RUNTIME>=$P{RUN_TIME_FROM} AND TDQ_OVERVIEW_INDVALUE.AN_RUNTIME <=$P{RUN_TIME_TO} AND TDQ_ANA.AN_UUID=$P{ANA_UUID} ) ORDER BY TDQ_ANALYZED_ELEMENT.ELT_CATALOG_NAME ASC, TDQ_ANALYZED_ELEMENT.ELT_SCHEMA_NAME ASC, TDQ_OVERVIEW_INDVALUE.TV_NAME ASC
Boolean.valueOf($F{ELT_SCHEMA_NAME} != null)
$P{REPORT_UUID} != null ? Boolean.valueOf($F{REP_UUID}.equals( $P{REPORT_UUID} )) : Boolean.FALSE
$F{AN_UUID}
$F{AN_LABEL}
Analysis:
Summary:
Connection:
Execution date:
Execution duration (s):
$F{AN_DURATION} != null ? String.valueOf($F{AN_DURATION}.intValue()/1000.0d) : "N/A"
$F{ELT_CONNECTION_NAME}
$F{AN_RUNTIME}
$F{AN_AUTHOR}
Author:
$F{ELT_CATALOG_NAME}
new Boolean(!$F{ELT_CATALOG_NAME}.equals( "N/A (TDQ)" ))
Catalog:
$F{ELT_CATALOG_NAME}
$F{ELT_SCHEMA_NAME}
new Boolean(!$F{ELT_SCHEMA_NAME}.equals( "N/A (TDQ)" ))
Schema:
$F{ELT_SCHEMA_NAME}
$F{TV_NAME}
new Boolean((($P{DB_TYPE}.intValue()==1?true:!$F{ELT_CATALOG_NAME}.equals("N/A (TDQ)"))&&($P{DB_TYPE}.intValue()!=2?true:!$F{ELT_SCHEMA_NAME}.equals("N/A (TDQ)")))&&($F{TV_NAME}==null||$F{TV_NAME}.trim().equals( "" )))
new Boolean($F{TV_TABLECOUNT}.longValue()+$F{TV_VIEWCOUNT}.longValue()>0)
Tables/Views
#Tables
new Boolean($F{TV_TABLECOUNT}.longValue()+$F{TV_VIEWCOUNT}.longValue()>0)
#Rows
$F{TV_KEYCOUNT}
$F{TV_TABLECOUNT}
#Keys
Summary:
new Boolean($F{TV_TABLECOUNT}.longValue()+$F{TV_VIEWCOUNT}.longValue()>0)
#Indexes
#Rows
$F{TV_INDEXCOUNT}
new Boolean($F{TV_TABLECOUNT}.longValue()+$F{TV_VIEWCOUNT}.longValue()>0)
#Indexes
$F{TV_VIEWCOUNT}
new Boolean($F{TV_TABLECOUNT}.longValue()+$F{TV_VIEWCOUNT}.longValue()>0)
#Keys
$F{TV_ROWCOUNT}
#Views

# $P{NEED_TITLE} "Report \"" + $F{REP_LABEL} + "\"" "Report \"" + $F{REP_LABEL} + "\"" $P{LOGO_FILE}

""
""
""
""
""
""
new Boolean($F{TV_NAME}!=null&&!$F{TV_NAME}.trim().equals( "" ))
$F{TV_NAME}
$F{TV_INDEXCOUNT}
$F{TV_ROWCOUNT}
$F{TV_KEYCOUNT}
""
""
""
""
""
""