diff options
Diffstat (limited to 'ecomp-sdk/epsdk-app-overlay/src/main/webapp/ngapp/src/app/pages/analytics/Report_List/Report/sql/sql.component.html')
-rw-r--r-- | ecomp-sdk/epsdk-app-overlay/src/main/webapp/ngapp/src/app/pages/analytics/Report_List/Report/sql/sql.component.html | 50 |
1 files changed, 45 insertions, 5 deletions
diff --git a/ecomp-sdk/epsdk-app-overlay/src/main/webapp/ngapp/src/app/pages/analytics/Report_List/Report/sql/sql.component.html b/ecomp-sdk/epsdk-app-overlay/src/main/webapp/ngapp/src/app/pages/analytics/Report_List/Report/sql/sql.component.html index 270ee870..01215576 100644 --- a/ecomp-sdk/epsdk-app-overlay/src/main/webapp/ngapp/src/app/pages/analytics/Report_List/Report/sql/sql.component.html +++ b/ecomp-sdk/epsdk-app-overlay/src/main/webapp/ngapp/src/app/pages/analytics/Report_List/Report/sql/sql.component.html @@ -9,7 +9,7 @@ <label>{{SQLmessage}}</label> </div> <div class="card-footer"> - <button (click)="showSaveSQLDialog = !showSaveSQLDialog" class="btn btn-alt btn-small close-model">Close + <button (click)="showSaveSQLDialog = !showSaveSQLDialog" class="btns btns-alt btns-small close-model">Close </button> </div> </div> @@ -38,7 +38,7 @@ </div> </div> <div class="card-footer"> - <button (click)="closeValidateModal()" class="btn btn-alt btn-small close-model">Close</button> + <button (click)="closeValidateModal()" class="btns btns-alt btns-small close-model">Close</button> </div> </div> </app-sql-validate-changes-dialog-component> @@ -57,12 +57,52 @@ <div class="field-group"> <label>Report SQL</label> <br/> <textarea [(ngModel)]="sqlText" class="defaultFontSize textarea-sql" id="sqlText" name="sqlText" type="textarea" - value="{{finalGetObj['query']}}"></textarea> + value="{{finalGetObj['query']}}" autocomplete="on"></textarea> + <b> Keyword Assistance:<br> + <a href="javascript:;" (click)="addText('SELECT')">SELECT</a> + <a href="javascript:;" (click)="addText('DISTINCT')">DISTINCT</a> + <a href="javascript:;" (click)="addText('FROM')">FROM</a> + <a href="javascript:;" (click)="addText('WHERE')">WHERE</a> + <a href="javascript:;" (click)="addText('GROUP BY')">GROUP BY</a> + <a href="javascript:;" (click)="addText('ORDER BY')">ORDER BY</a> + <a href="javascript:;" (click)="addText('ASC')">ASC</a> + <a href="javascript:;" (click)="addText('DESC')">DESC</a> + <a href="javascript:;" (click)="addText('AND')">AND</a> + <a href="javascript:;" (click)="addText('OR')">OR</a> + <a href="javascript:;" (click)="addText('NOT')">NOT</a> + <a href="javascript:;" (click)="addText('EXISTS')">EXISTS</a> + <a href="javascript:;" (click)="addText('IS')">IS</a> + <a href="javascript:;" (click)="addText('NULL')">NULL</a> + <a href="javascript:;" (click)="addText('IN')">IN</a> + <a href="javascript:;" (click)="addText('BETWEEN')">BETWEEN</a> <br> + <a href="javascript:;" (click)="addText('COUNT(')">COUNT(</a> + <a href="javascript:;" (click)="addText('SUM(')">SUM(</a> + <a href="javascript:;" (click)="addText('AVG(')">AVG(</a> + <a href="javascript:;" (click)="addText('MAX(')">MAX(</a> + <a href="javascript:;" (click)="addText('MIN(')">MIN(</a> + <a href="javascript:;" (click)="addText('NVL(')">NVL(</a> + <a href="javascript:;" (click)="addText('DECODE(')">DECODE(</a> + <a href="javascript:;" (click)="addText('SYDATE')">SYSDATE</a> + <a href="javascript:;" (click)="addText('TO_CHAR')">TO_CHAR</a> + <a href="javascript:;" (click)="addText('TO_NUMBER(')">TO_NUMBER(</a> + <a href="javascript:;" (click)="addText('TO_DATE(')">TO_DATE(</a> + <a href="javascript:;" (click)="addText('TRUNC(')">TRUNC(</a> + <a href="javascript:;" (click)="addText('ROUND(')">ROUND(</a> + <a href="javascript:;" (click)="addText('ABS(')">ABS(</a> + <a href="javascript:;" (click)="addText('SUBSTR(')">SUBSTR(</a> <br> + <a href="javascript:;" (click)="addText('REPLACE(')">REPLACE(</a> + <a href="javascript:;" (click)="addText('LOWER(')">LOWER(</a> + <a href="javascript:;" (click)="addText('UPPER(')">UPPER(</a> + <a href="javascript:;" (click)="addText('LTRM(')">LTRM(</a> + <a href="javascript:;" (click)="addText('RTRIM(')">RTRIM(</a> + <a href="javascript:;" (click)="addText('LPAD(')">LPAD(</a> + <a href="javascript:;" (click)="addText('RPAD(')">RPAD(</a> + <a href="javascript:;" (click)="addText('(linkToReport, , , )')">linkToReport</a> + </b> </div> - <br/> <div class="field-group"> <pre> - <div class="divider"></div><button (click)="validate()" class="btn btn-alt btn-small">Validate & Save</button> + <div class="divider"></div><button (click)="validate()" class="btns btns-alt btns-small">Validate & Save</button> </pre> </div> <br/> |