<%-- ================================================================================ eCOMP Portal SDK ================================================================================ Copyright (C) 2017 AT&T Intellectual Property ================================================================================ Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at http://www.apache.org/licenses/LICENSE-2.0 Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License. ================================================================================ --%> <%@ page import="org.openecomp.portalsdk.analytics.xmlobj.DataColumnType" %> <%@ page import="org.openecomp.portalsdk.analytics.util.AppConstants" %> <%@ page import="org.openecomp.portalsdk.analytics.model.definition.ReportDefinition" %> <%@ page import="org.openecomp.portalsdk.analytics.system.AppUtils" %> <%@ page import="org.openecomp.portalsdk.analytics.controller.WizardSequence" %> <%@ page import="java.util.List" %> <%@ page import="java.util.Iterator" %> <%@ page import="org.openecomp.portalsdk.analytics.system.Globals" %> <%@ page import="org.openecomp.portalsdk.analytics.util.Utils" %> <%@ page import="java.util.Vector" %> <%@ page import="org.openecomp.portalsdk.analytics.model.ReportLoader" %> <%@ page import="org.openecomp.portalsdk.analytics.model.base.IdNameValue" %> <%@ page import="org.openecomp.portalsdk.analytics.xmlobj.FormFieldType" %> <%@ page import="org.openecomp.portalsdk.analytics.model.base.ReportWrapper" %> <%@ page import="org.openecomp.portalsdk.analytics.model.DataCache" %> <%@ page import="org.openecomp.portalsdk.analytics.model.runtime.FormField" %> <%@ page import="org.openecomp.portalsdk.analytics.model.base.OrderBySeqComparator" %> <%@ page import="java.util.Collections" %> <%@ page import="org.openecomp.portalsdk.analytics.model.definition.TableSource" %> <% ReportDefinition rdef = (ReportDefinition) request.getAttribute(AppConstants.SI_REPORT_DEFINITION); WizardSequence ws = rdef.getWizardSequence(); String curSubStep = ws.getCurrentSubStep(); String reportID = rdef.getReportID(); boolean isCrossTab = rdef.getReportType().equals(AppConstants.RT_CROSSTAB); boolean isSQLBased = rdef.getReportDefType().equals(AppConstants.RD_SQL_BASED); %>

Step <%= ws.getCurrentStepIndex() %> of <%= ws.getStepCount() %> - Report <%= ws.getCurrentStep() %>
Report SQL: <% boolean sqlValidated = (nvl(AppUtils.getRequestValue(request, "sqlValidated"), nvl(rdef.getReportSQL())).length()>0); if(request.getAttribute(AppConstants.RI_ERROR_LIST)!=null) sqlValidated = false; String sql = nvl(rdef.getReportSQL(), "SELECT "); if(! sqlValidated) sql = nvl(AppUtils.getRequestValue(request, "reportSQL"), sql); %> ">  <%= sql %>	Keyword Assistance       SELECT  DISTINCT        FROM        WHERE        GROUP BY        HAVING        ORDER BY  ASC  DESC        UNION  ALL  INTERSECT  MINUS        AND  OR  NOT  EXISTS        IS  NULL  IN  BETWEEN        COUNT(  SUM(  AVG(  MAX(  MIN(        NVL(  DECODE(  SYSDATE        TO_CHAR(  TO_NUMBER(  TO_DATE(        TRUNC(  ROUND(  ABS(        SUBSTR(  REPLACE(  LOWER(  UPPER(        LTRIM(  RTRIM(  LPAD(  RPAD(
Tables: <% Vector reportTableSources = DataCache.getReportTableSources((String) session.getAttribute("remoteDB")); for(int i=0; i <%= tableSource.getTableName() %> <% } %> Add Table Columns Form Fields	Validate SQL   Test Run SQL
You need to click the "Validate SQL" button in order to store the SQL before going forward

<%! private String nvl(String s) { return (s==null)?"":s; } private String nvl(String s, String sDefault) { return nvl(s).equals("")?sDefault:s; } %>