from my learning's... please find below - How to use keyed data page...
to reduce database calls and avoid looping for performance gains
Sample use case
Need to read a list of available products from a store but at every screen want to find a particular product instance in one go neither iterating through page list results nor querying the database
A data page should be of List type structure
Edit mode - should be of Read-Only
Scope - based on the use case (say: Node)
Enable option 'Access pages with user defined keys' and configure a key
note: enabling option 'Allow multiple pages per key' will return a filtered/resultant keyed Page list otherwise it will return a single page filtered result.
create a report definition to fetch the results/data from SOR
***create a property of property type page list
enable refer to a data page to access data
configure data page along with parameters & keys
on a temporary page in an activity/data transform set the key values and initialize the property
all the results will be observed at node level page
required page will be copied/noticed under temporary page
***if property is not in scope to access the data...
create a tempPage
set the key values
invoke data page
Notes: there is no specific syntax to refer keyed properties as similar to data page parameters but will need to map/set all the key values on the top level page (temporary page) to filter the data from master list.
Please share your thoughts/observations, Thank you!
So it seems keyed filtering only configurable with a property rule.
Are there any plans to make keyed filtering also available from UI control, especially with dropdown control?
I think it is a common use-case to filtering a table of records using multiple columns, which are represented by a set of corresponding dropdown controls on the screen.
Repeating grid do have filtering feature, but it always display the entire set of records first, which is not expected by a user who wants to see only a set of filtering keys and the result of filtered records.
This link leads to an internal document and the access is restricted. The document in the link was posted back in 2015 and is probably not the latest information. We recommend that you create a new post for your question.
Notes: there is no specific syntax to refer keyed properties as similar to data page parameters but will need to map/set all the key values on the top level page (temporary page) to filter the data from master list. - Do you mean we can pass key while accessing data page in Activity/Data Transform? If so, how it will filter the results if we set the key value in top level page (temporary page) and how to access the results. Infact I tried do access the data page with keyed value in data transform, but did not worked for me. Could you please help me out in clarifying.
Hi ,"keyed page access" is only working with refer to data Page option in a property , if we use "copy data from data page" it returns entire records , how do we achieve the same with this option(Copy data from data page)