Archive Manager Remote Operation Feature
The Remote Operation feature is used to make the reports prepared with Archive Manager performant. For reports with a high record count, instead of loading all of the data in the first stage, the data will be loaded as the page scrolls down.
After the feature is activated, the number of pages and the number of records of the reporting screen are not shown.
Parameters to Include in Database Query
In the query of the archive, the parameters of the Remote Operation feature need to be added.
PWHERE – PSORT – PSKIP – PTAKE parameters should be added and filled with default values as in the screenshot and compile.
Sample Query :
SELECT*
FROM [EBA]. [dbo]. [FLOWREQUESTS] WHERE ```<```?=PWHERE```>```
ORDER BY ```<```?=PSORT```>```
OFFSET ```<```?=PSKIP```>``` ROWS -- skip 10 rows
FETCH NEXT ```<```?=PTAKE```>``` ROWS ONLY -- take 10 rows
Activating the Archive Manager Feature
Archive definitions should be made in SystemManager >
Process Archive.
• At this stage, the fields corresponding to the parameters set on the query by setting it to enabled in the Remote Operations tab should be selected as shown in the screenshot.
• Multiple selections can be made optionally in the SortColumns section.
• All fields are required.