Question
IP Australia
AU
Last activity: 16 Oct 2018 12:03 EDT
how to pass parameters to custom populator function to filter data page
Hi,
I have a requirement to fetch data from 'D_pyUserWorkList' data page and filter the results using user input parameters and load to a different data page 'D_UserWorkList_filter'. But this is not working, I suspect parameters are not being passed correctly.
As I am filtering on 'D_pyUserWorkList' data page, I am not whitelisting. but I whitelisted 'D_UserWorkList_filter' data page. and I am using below custom popular function to load data.
var UserworklistcustomFunction = function(parametersMap, clientStore, onSuccess, onFailure) {
var targetDatapageName = "D_UserWorkList_Filter";
var query = "SELECT * from D_pyUserWorkList WHERE pxRefObjectInsName = ?";
var queryParameters = [parametersMap.SearchID];
clientStore.runQuery(query, queryParameters , targetDatapageName, onSuccess, onFailure);
};
pega.u.ClientCache.registerLargeDatapage("D_UserWorkList_Filter", UserworklistcustomFunction, ["D_pyUserWorkList"]);
SearchID is a property on clipboard to which user selected value will be posted.
Any help would be appreciated.
Thanks,
Mohammad Gouse.
**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
Since you have not whitelisted D_pyUserWorklist DP it cannot be a large data page and you're using custom populator of a LDP which is wrong. Either mark your master DP (D_pyUserWorklist) as LDP in whitelist and ontinue to use this function or write non-LDP custom populator. The name of the fucntion should be same as the name of DP and non-LDP fn looks something like this -
Since you have not whitelisted D_pyUserWorklist DP it cannot be a large data page and you're using custom populator of a LDP which is wrong. Either mark your master DP (D_pyUserWorklist) as LDP in whitelist and ontinue to use this function or write non-LDP custom populator. The name of the fucntion should be same as the name of DP and non-LDP fn looks something like this -
- function Declare_LoadEmployees(dpPage, params){
- var cc=pega.u.ClientCache;
- var employeesInSiteServicesPL = dpPage.put("pxResults",[]);
- var employeePLIter = cc.find("Declare_LoadAllEmployees.pxResults").iterator();
- while(employeePLIter.hasNext()){
- var empPg = employeePLIter.next();
- var role = params.pyRole ;
- if(empPg.get("pyRole").getValue() == role){
- employeesInSiteServicesPL.add().adoptJSON(empPg.getJSON());
- }
- }
- }
Pegasystems Inc.
PL
If you suspect parameters are not being passed correctly, why don't you debug your code to verify that? You can even print the parameters to logs and then see their value in a logs viewer.
The main problem I see here is that the source data page (D_pyUserWorkList) is not marked as "large" in the whitelist. Only large data pages can be queried in large data page populator functions.
Accepted Solution
Pegasystems Inc.
IN
Since you have not whitelisted D_pyUserWorklist DP it cannot be a large data page and you're using custom populator of a LDP which is wrong. Either mark your master DP (D_pyUserWorklist) as LDP in whitelist and ontinue to use this function or write non-LDP custom populator. The name of the fucntion should be same as the name of DP and non-LDP fn looks something like this -
Since you have not whitelisted D_pyUserWorklist DP it cannot be a large data page and you're using custom populator of a LDP which is wrong. Either mark your master DP (D_pyUserWorklist) as LDP in whitelist and ontinue to use this function or write non-LDP custom populator. The name of the fucntion should be same as the name of DP and non-LDP fn looks something like this -
- function Declare_LoadEmployees(dpPage, params){
- var cc=pega.u.ClientCache;
- var employeesInSiteServicesPL = dpPage.put("pxResults",[]);
- var employeePLIter = cc.find("Declare_LoadAllEmployees.pxResults").iterator();
- while(employeePLIter.hasNext()){
- var empPg = employeePLIter.next();
- var role = params.pyRole ;
- if(empPg.get("pyRole").getValue() == role){
- employeesInSiteServicesPL.add().adoptJSON(empPg.getJSON());
- }
- }
- }
IP Australia
AU
I tried this option and it worked for my requirement. but, if I have 2 parameters to pass it is getting the data with combination of two parameters. but, if I pass only one parameter having 2 parameters defined in if condition with a && condition, it is not fetching the data as the other parameter is passing "" values and ignoring the record. do you have any thought?
Pegasystems Inc.
IN
Can you post a screenshot or the parameter/function you have defined? It is not clear to me what you're trying to say.