Question

How "ExcelQuickReport" interface of the "Application Server Task" work?

  • 28 June 2023
  • 0 replies
  • 15 views

Userlevel 4
Badge +10

Issue:

The "ExcelQuickReport" interface of the application has been used as a server task to send the email when Excel is created and emailed. The following questions were raised regarding this.

  1. Where is the Excel stored until it is emailed? Is it stored on a table in the DB?
  2. If stored in a DB table, which table is it stored in? What is the name of the table?
  3. Is the data stored before Excel is created instead of saving Excel? 
  4. At what point will the saved Excel or data be deleted? Or will the data be saved for a certain period and then deleted? What is the retention period currently?

Environments/Databases: 

IFS APPS10 UPD8

Resolution:

Refer to the following answers to the questions.

  1. No, excel is not stored in the database.
  2. As excel is not stored in the database, there is no such table.
  3. Data for the excel is obtained from the "Quick Report" that you need, which is already saved in the database.
  4. There is no deletion of data. Because necessary data for excel is obtained from a quick report. Those data are exported through excel.

Further explanation of the process:

Through "Application Server Task" what happens is, it defines a middle tier handler operation that can be scheduled by the "Database Scheduled Tasks" functionality. So, simply what happens is this "Application Server Task" schedules a task to happen in each time slot. In this case, the task is exporting data to excel and emailing that.

So, the defined "Application Server Task" runs the relevant "Quick Report" and then it is exported as an excel when running that specified task at the scheduled time. So, there is no storage taking place for excel. The data that already contains in that "Quick Report" which can be obtained through a SQL query by using "Quick Report Parameters" is the source for excel. This entire process is executed at the scheduled time - this is the important thing here.

 


0 replies

Be the first to reply!

Reply