1 files changed, 12 insertions, 1 deletions
diff --git a/ecomp-sdk/epsdk-app-overlay/src/main/webapp/ngapp/src/app/pages/analytics/Report_List/Report/sql/sql.component.ts b/ecomp-sdk/epsdk-app-overlay/src/main/webapp/ngapp/src/app/pages/analytics/Report_List/Report/sql/sql.component.ts
index afa84c63..7a547e3d 100644
--- a/ecomp-sdk/epsdk-app-overlay/src/main/webapp/ngapp/src/app/pages/analytics/Report_List/Report/sql/sql.component.ts
+++ b/ecomp-sdk/epsdk-app-overlay/src/main/webapp/ngapp/src/app/pages/analytics/Report_List/Report/sql/sql.component.ts
@@ -36,6 +36,7 @@ export class SQLComponent implements OnInit {
 
     @Input() SQLclosable = true;
     @Input() Validateclosable = true;
+    keyWordAssistance: any[];
 
 
     constructor(private _http: HttpClient, private _router: Router, private _sqlService: SqlService) {
@@ -43,13 +44,20 @@ export class SQLComponent implements OnInit {
         this.SQLPostResponse = true;
         this.ValidatePostResponse = {};
         this.showErrorSqlMessage = false;
+        this.keyWordAssistance = [];
+
     }
 
     ngOnInit() {
-        this.showSpinner = true;
         this.showSaveSQLDialog = false;
         this.SQLPostResponse = true;
         this.ValidatePostResponse = {};
+        this.keyWordAssistance.push( 'SELECT',  'DISTINCT', 'FROM', 'WHERE',
+            'GROUP BY', 'HAVING',  'ORDER BY',  'ASC',   'DESC', '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(',
+            'LTRM(', 'RTRIM(', 'LPAD(', 'RPAD(', 'linkToReport');
         this._sqlService.getSQLTabData(this.reportId1)
             .subscribe((response) => {
                 this.showSpinner = true;
@@ -153,4 +161,7 @@ export class SQLComponent implements OnInit {
         return this.ValidateResponseString;
     }
 
+    addText(word: string) {
+        this.sqlText =  this.sqlText + '  '  + word + '  ';
+    }
 }