Scribd
Upload
9 views4 pages

Logic Document - Localcache

The document outlines a change request for implementing a local cache mechanism in the TURN project, specifically for the Monthly Payable and Admin screens. It details the use of IndexedDB for temporary data storage in JSON format and the addition of a ctrl_CacheFlag column to enable or disable caching functionality. The document also describes the necessary steps for regenerating pages to bind the local cache code effectively.

Uploaded by

Binu Gibson
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
9 views4 pages

Logic Document - Localcache

The document outlines a change request for implementing a local cache mechanism in the TURN project, specifically for the Monthly Payable and Admin screens. It details the use of IndexedDB for temporary data storage in JSON format and the addition of a ctrl_CacheFlag column to enable or disable caching functionality. The document also describes the necessary steps for regenerating pages to bind the local cache code effectively.

Uploaded by

Binu Gibson
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 4

Logic Document- Local Cache

Change Requested by Jinu

Date 01/07/2025

Project TURN

Module: Local Cache

Person at Client site who is requesting NA


the change and will be in charge of
implementing it.

Requested date of completion by


Client

Type of Task New

Similar screen or similar code that NA


programmer can be pointed to:

Document Prepared BY Lima Rani

Document Prepared On 01/07/2025

Logical Document

Local cache refers to temporary storage mechanisms utilized by browsers to enhance performance.
One such storage mechanism is IndexedDB. IndexedDB allows the creation of a database that
contains various object stores.

Each object store is designed to store specific data, such as grid table information. The data in
these object stores is stored in JSON format. This data remains available until the browser history
is cleared or the browser cache is explicitly cleared by the user.

IndexedDB provides a structured way to manage and retrieve local data efficiently, making it a
powerful tool for web applications requiring offline capabilities or faster data access.
Implementation of Local Cache Mechanism

We have implemented the local cache mechanism on two screens: the Monthly Payable
(ETBL) screen and the Admin (ETBL) screen.

To facilitate this, we added a column named ctrl_CacheFlag in the tbl_controls table. For any page
where the local cache mechanism needs to be enabled, the ctrl_CacheFlag should be set to true.

After setting the flag to true, the page must be regenerated. Once regenerated, the newly added
local cache code will automatically bind to the corresponding Autoform.aspx page, enabling the
caching functionality.

If the ctrl_CacheFlag is not set to true, the page will function with the usual code, without the local
cache mechanism.

Additionally, the local cache mechanism code has been added to the Generic Handler within
the ETBL case block.

Code written in Expandable Grid control


SP for written to check the flag is true

Added one column in ctrl_cacheflag

You might also like