Question
Kelly Services Malaysia Sdn. Bhd.
MY
Last activity: 20 Jul 2018 1:38 EDT
View the value of "Filtered by" when running report definition
Please see the attached screen shot. I would like to know how to view the value that is being filtered so I know what is being passed into the report definition - for debugging.
Any idea how this would be done?
Thanks
Accepted Solution
Kelly Services Malaysia Sdn. Bhd.
MY
MounikaThatikonda thanks for your input, it helped me in getting more info on the tracer.
I have already resolved this issue by doing a rather weird workaround. I am now comparing the filtered values using the function alias I created. For some reason if I compare the column's value with the output from function alias it doesn't work. Instead, I had to compare both values which are generated from the function alias. I hope the screen shot will explain it better.
Pegasystems Inc.
IN
Hi,
I am not sure if I have understood the requirement, Are you are trying to find the value of email domain ? Please correct if not.
If that is the case, you can do that by,
1. Click on the caption (Email Domain in your case) and then you get a edit filter popup which shows the value that is configured at design time.
2. If you are looking for sql queries , then you can find it by tracing it.
PFA above explanation with screenshots.
Best Regards,
Mounika
Pegasystems Inc.
IN
In addition to, if you are referring to the filtered values being displayed while running the report : Please do not provide any caption in the filters of the report definition. This way it will be directly visible.
Kelly Services Malaysia Sdn. Bhd.
MY
Thank you both for the replies. The reason I am not seeing the value used in the "Filtered by" is because I am using a function to get the value and not a directly input value. Please see link below which contains the screen shots.
Also, I checked the tracer but I am not able to find any SQL step as shown in the docx. Any advice on further actions?
Thanks again.
Kelly Services Malaysia Sdn. Bhd.
MY
When looking at the tracer it shows the function being called and the parameters being passed in, but I couldn't find the output.
The function alias I created gets an email as input, and outputs the email domain
eg: Proprietary information hidden, the result will be '123.com'
When the function alias is used to display the columns (refer screen shots) it works, but doesn't work when used as a filter condition. So I would like to know what was the value of the filter condition so I could determine the error and next steps.
Thank you
Pegasystems Inc.
IN
You need to enable DB query checkbox in event types to trace - tracer settings in order to view the SQL.
Analyzing tracer and clipboard (clipboard page -> RuleToRun.pyContent.pyFilters.pyFilter(1)) will help provide clarity
Accepted Solution
Kelly Services Malaysia Sdn. Bhd.
MY
MounikaThatikonda thanks for your input, it helped me in getting more info on the tracer.
I have already resolved this issue by doing a rather weird workaround. I am now comparing the filtered values using the function alias I created. For some reason if I compare the column's value with the output from function alias it doesn't work. Instead, I had to compare both values which are generated from the function alias. I hope the screen shot will explain it better.