From 9185b3621ec4b5b8f5e5efd7b71efed458db572d Mon Sep 17 00:00:00 2001
From: "Welch, Lorraine (lb2391)" <lb2391@att.com>
Date: Fri, 13 Sep 2019 12:32:27 -0400
Subject: Created a test report for Raptor

Issue-ID: PORTAL-737

Signed-off-by: Welch, Lorraine (lb2391) <lb2391@att.com>
Change-Id: I69ebf4da7a66462d2fa280e3a65aa6c17c3879ce
---
 .../db-scripts/EcompSdkDMLMySql_3_0_OS.sql         | 56 ++++++++++++++++++++++
 1 file changed, 56 insertions(+)

(limited to 'ecomp-sdk/epsdk-app-os')

diff --git a/ecomp-sdk/epsdk-app-os/db-scripts/EcompSdkDMLMySql_3_0_OS.sql b/ecomp-sdk/epsdk-app-os/db-scripts/EcompSdkDMLMySql_3_0_OS.sql
index 685d1784..a397f2d0 100644
--- a/ecomp-sdk/epsdk-app-os/db-scripts/EcompSdkDMLMySql_3_0_OS.sql
+++ b/ecomp-sdk/epsdk-app-os/db-scripts/EcompSdkDMLMySql_3_0_OS.sql
@@ -36,4 +36,60 @@ Insert into fn_app (APP_ID,APP_NAME,APP_IMAGE_URL,APP_DESCRIPTION,APP_NOTES,APP_
 -- fn_user_role
 Insert into fn_user_role (USER_ID,ROLE_ID,PRIORITY,APP_ID) values (1,1,null,1);
 
+INSERT INTO CR_REPORT(REP_ID, TITLE, DESCR, PUBLIC_YN, REPORT_XML, CREATE_ID, CREATE_DATE, MAINT_ID, MAINT_DATE, MENU_ID, MENU_APPROVED_YN, OWNER_ID, FOLDER_ID, DASHBOARD_TYPE_YN, DASHBOARD_YN) VALUES
+(1, 'test report', 'test report', 'Y', '<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
+<customReport pageSize="50" reportType="Linear">
+    <reportName>test report</reportName>
+    <reportDescr>test report</reportDescr>
+    <dbInfo>local</dbInfo>
+    <chartType></chartType>
+    <showChartTitle>false</showChartTitle>
+    <public>false</public>
+    <hideFormFieldAfterRun>false</hideFormFieldAfterRun>
+    <createId>1</createId>
+    <createDate>2019-09-11-04:00</createDate>
+    <reportSQL>SELECT 
+      first_name fi1 
+from fn_user</reportSQL>
+    <frozenColumns>0</frozenColumns>
+    <emptyMessage>Your Search didn''t yield any results.</emptyMessage>
+    <dataGridAlign>left</dataGridAlign>
+    <numFormCols>100</numFormCols>
+    <displayOptions>NNNNNNN</displayOptions>
+    <allowSchedule>N</allowSchedule>
+    <sizedByContent>N</sizedByContent>
+    <comment>N|</comment>
+    <dataSourceList>
+        <dataSource tableId="du0">
+            <tableName>DUAL</tableName>
+            <tablePK></tablePK>
+            <displayName>DUAL</displayName>
+            <dataColumnList>
+                <dataColumn colId="fi1">
+                    <tableId>du0</tableId>
+                    <dbColName>first_name</dbColName>
+                    <colName>first_name</colName>
+                    <displayName>first_name</displayName>
+                    <displayWidth>10</displayWidth>
+                    <displayAlignment>Left</displayAlignment>
+                    <orderSeq>1</orderSeq>
+                    <visible>true</visible>
+                    <calculated>true</calculated>
+                    <colType>VARCHAR2</colType>
+                    <groupBreak>false</groupBreak>
+                    <dbColType>VARCHAR2</dbColType>
+                </dataColumn>
+            </dataColumnList>
+        </dataSource>
+    </dataSourceList>
+    <maxRowsInExcelDownload>500</maxRowsInExcelDownload>
+    <isOneTimeScheduleAllowed>N</isOneTimeScheduleAllowed>
+    <isHourlyScheduleAllowed>N</isHourlyScheduleAllowed>
+    <isDailyScheduleAllowed>N</isDailyScheduleAllowed>
+    <isDailyMFScheduleAllowed>N</isDailyMFScheduleAllowed>
+    <isWeeklyScheduleAllowed>N</isWeeklyScheduleAllowed>
+    <isMonthlyScheduleAllowed>N</isMonthlyScheduleAllowed>
+</customReport>', 1, sysdate(), 1, sysdate(), 'HOME', 'N', 1, NULL, 'N', 'N');
+
+
 commit;
\ No newline at end of file
-- 
cgit 1.2.3-korg