cancel
Showing results for 
Search instead for 
Did you mean: 

Restrict max records for POWL (FO Overview) for first time usage

AshishV
Explorer
0 Kudos

Dear Experts,

We want to restrict the max number of records for POWL for "Freight Order Overview" query. When a new user runs the POWL FO Overview query then it loads all the Freight Orders which are more than 25K and it takes more than 20 mins.

Do we have a way to restrict the number of records for a POWL Query?

I tried using TX: POWL_QUERY & changing QUERY PARAMETER and transport to further systems but it did not work.

Can you please help me out?

Regards,

Ashish

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

We had this same issue and found there are two potential cases for us...

1) The query itself is useful to the user as-is, but the user wants to control when the refresh takes place.  In this case, we modified the Refresh Type to something like Manual Only in powl_query and transported.  For the "all" queries, this was almost never the case.

2) The query is not useful.  In this case, we remove authorization to the query in powl_queryr and the user never sees it.  Usually a separate query is created that is more useful, such as all FORs created in the last 7 days or all FORs with a particular lifecycle status.

Another item to consider is using powl_d04 to delete cached selection criteria for admin queries prior to using powl_query.

Answers (0)