Question
Pegasystems Inc.
JP
Last activity: 4 Oct 2018 11:08 EDT
How to pass filtering key values to data pages
There is detailed explanation about how to pass parameters to data pages in prhelp documents, however there isn't any explanation about how to pass filtering key values to data pages.
It seems drop-down control CAN NOT specify filtering key for its sourcing data page, only parameters are configurable.
Can anyone list up UI elements which support filtering keys of data pages and the syntax of passing filtering key values to data pages from non-UI rules?
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
Accepted Solution
Pegasystems Inc.
IN
Hi Chunzhi, Good Morning!
from my learning's... please find below - How to use keyed data page...
Purpose
- 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
How to...
- 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
Outcome...
- 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...
Hi Chunzhi, Good Morning!
from my learning's... please find below - How to use keyed data page...
Purpose
- 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
How to...
- 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
Outcome...
- 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!
psahukaru
Pegasystems Inc.
JP
Hi Phani, thanks for you reply.
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.
Pegasystems Inc.
IN
>>> Are there any plans to make keyed filtering also available from UI control, especially with dropdown control?
Sorry Chunzhi, No idea...
Rules Cube Inc.
CA
Softserve Inc
US
Can you please share the document, getting below listed error when i try to access.
Access to this place or content is restricted. If you think this is a mistake, please contact your administrator or the person who directed you here.
Pegasystems Inc.
IN
Hi @GNagaV39
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.
Thanks!
Verizon
IN
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.
Thanks!
-Rajasri
Wipro Ltd
IN
HI Phani Sahukaru,
You are saying that :"keyed page access" will reduced the DB hits and even same mentioned in the PDN and help.
But i am unable find how exactly we can check.Are those records available on clipboard or not?
can you please eloborate if possible .thanks in advance..
Wipro Ltd
IN
this link cleared my Question.
https://pdn.pega.com/instantly-access-embedded-pages-list-structure-data-page
hexaware
IN
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)
