SandyAdmin Honored Contributor.
Honored Contributor.
227 views

Favorites view for Previous Approvals having mapping and performance logs issue

Hi Experts,

We are having this Favorites to display the users "previous approvals" just like the OOB "My pending Approvals".

In making the query below: I'm having the slow response in the application and upon checking the logs. I noticed a Mapping and performance Warning. Can anyone of you please advise as the what the proper query for displaying the previous approved or denined records? The records get displayed yet the slow response is noticeably present everytime we click on the favorites and on loading the application. Thank you in advance.  

Query 1: not (approval.status="pending") and approvals.record=false and approved.by isin {$lo.user.name}

Query 2:not (approval.status="pending") and approvals.record=false and approved.groups isin {$lo.user.name}

sm.log: 2104( 4568) 03/14/2016 14:52:15 RTE A Mapping-3-Approval,approved.by, SQL Query incomplete because field (approved.by) in file (Approval) can not be used in an SQL query ; application(display), panel(fdisp.1)
2104( 4568) 03/14/2016 14:52:37 RTE A Performance-2-Approval, Partial File Scan for query involving fields {approval.status, approvals.record, approved.by} ; application(display), panel(fdisp.1)
2104( 4568) 03/14/2016 14:52:51 RTE A Performance-6-Approval, Hit Ratio not achieved on file Approval and query (not (approval.status="pending") and approvals.record=false and approved.by isin {"user1.analyst"}): Of 7384 records checked, 7139 did not match the query ; application(display), panel(fdisp.1)
2104( 4568) 03/14/2016 14:53:21 RTE A Performance-6-Approval, Hit Ratio not achieved on file Approval and query (not (approval.status="pending") and approvals.record=false and approved.by isin {"user1.analyst"}): Of 4351 records checked so far, 4349 did not match the query ; application(display), panel(fdisp.1)

0 Likes
1 Reply
Established Member.. MickeyMi
Established Member..

Re: Favorites view for Previous Approvals having mapping and performance logs issue

You can try to use 'Advanced Filter' to verify if there exist a performance issue for a query.

Also 'Advanced Filter' can help you to write a query. 

Actually you can use "=" not "isin".

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.