From 220a25a2566c90bc540e7190342f73824d2ff54a Mon Sep 17 00:00:00 2001 From: mravula Date: Mon, 31 Aug 2020 12:29:32 -0400 Subject: Raptor UI Changes, user profile, folder restructure Issue-ID: PORTAL-902 Change-Id: Ib76bb3fce7efe55504b75d2fc4764bafb9f8e908 Signed-off-by: mravula --- .../pages/analytics/Report_List/Report/sql/sql.component.ts | 13 ++++++++++++- 1 file changed, 12 insertions(+), 1 deletion(-) (limited to 'ecomp-sdk/epsdk-app-overlay/src/main/webapp/ngapp/src/app/pages/analytics/Report_List/Report/sql/sql.component.ts') 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 + ' '; + } } -- cgit 1.2.3-korg