Keyed Page Access

Keyed Page Access

Points to Note :

1. Keyed Page access is applicable to only list structure Data page. 
2. It canbe referred only with Property of Page and Pagelist datatype

Pre-Requirements :

1. Data Page with List Structiure
   
2. Property With Page Data Type
   
3. Property with Pagelist Data Type
   
4. Results of Data Page

Creation of Pre-Requirements :

Here creating the Datatype is skipped (Which automatically creates the Class ,Class mapping and Datapages)

1. Data Page with List Structure

2. Property With Page Data Type

3. Property With PageList DataType

4. Results From DataPage

Pre-Implementation :

Now Lets Configure the Keyed Page Access in the Data Page .

1)Enable Access Pages with user defined keys
2)Added two of the Properties from Report Definition as Pagelist Keys

3) Refer this Data page as Source to Both the Page and Pagelist Property

Implementation :

Scenario 1: Disable Allow multiple pages per key

Now Re-save both the property where we have referred the datapage with keys

Learning : Disabling it , Datapage will return only one Records and it can't be stored in a Page list , So Page Property is Required

Scenario 2: Enable Allow multiple pages per key
Now Re-save both the property where we have refered the datapage with Keys

Learning : Enabling it , Datapage can return more than one Records and it cant be stored
in a Page Property , So Pagelist Property is Required

Scenario 3: Enable Allow Multiple Pages Per key and Defined two keys and  Pass two Keys.

To Test this scenario , I have created a Sample Data Transform

Learning : Datapage contains all the Results But Property Contains only Filtered Results . So Keyed Page access can bring subset of the Datapage .

Scenario 4: Enable Allow Multiple Pages Per key and Defined two key and Pass one Key

Learning : Datapage contains all the Results But Property Contains No Results. So Keyed Page access to work ,All the keys defined needs to be passed to fetch the Results.

Now your Next question will be : Parameterised Datapage also does the same , Why to go for Keyed Page Access ?


Yes , But for every different parameter passed to the Datapage , interaction happens with the database .In case of Keyed Page Access , the datapage is interacted only once and filtering happens on the data page results . So we can avoid multiple hits

We can try the same scenarios with Page Property with sample Data transform , I am going leave that for you to explore.