on 06-24-2016 12:35 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
13 | |
4 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.