Question

14
Replies
22838
Views
Chunzhi_Hong Member since 2013 136 posts
PEGA
Posted: 5 years ago
Last activity: 2 years 5 months ago
Closed
Solved

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.

User Interface Data Integration
Close popover
Moderation Team has archived post
Accepted Solution
Posted: 5 years ago

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

Posted: 5 years ago

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.

Posted: 5 years ago

>>> Are there any plans to make keyed filtering also available from UI control, especially with dropdown control?

Sorry Chunzhi, No idea...

Posted: 4 years ago

Hi Venkatesh,

Link provided is not accessible to us.Can you attach it to this article.

Thanks

Dinesh

Posted: 2 years ago

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.

Posted: 2 years ago

Hi venkuusg,


 


i was unable to access the document can i know how can i view this document

Posted: 2 years ago

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!

Posted: 3 years ago

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

Posted: 3 years ago

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..

Posted: 3 years ago

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)

Posted: 3 years ago

please provide a step by step process to connect two data pages.


 

Posted: 2 years ago

can anybody tell me what is the syntax to call a keyed data page in activity/DT/Screen ? (without using a property with copy data from data page)
Share this page LinkedIn
Copied!