Refresh Table - Maintain Sort
ARS 6.3 p23 (server and user tool) I have noticed an undesirable behavior with refreshing tables when using the Run Process PERFORM-ACTION-TABLE-REFRESH command. I hope there is a work-around. Here is the issue: A user clicks on a table field column in order to sort by that column. The user then clicks a Refresh button. When workflow uses the Change Field - Refresh Table Field command the table field remains sorted by the column the user had selected. When workflow uses the Run Process - PERFORM-ACTION-TABLE-REFRESH command the sort order is reset to the default. Which means the user has to click the column again to sort by that column. Is there any way to stop ARS from resetting the default sort order for the table field? BTW, I use the PERFORM-ACTION-TABLE-REFRESH command so that users can determine how many rows to return. For example, on one of my screens I have a radio button that reads Show up to: o 100 o 250 o 500 o 750 o 1000 with 100 as the default. For most searches 100 is enough, yet users have the option to show more as needed. The full Run Process command is PERFORM-ACTION-TABLE-REFRESH 536870938 1 $zTmpInt1$. TIA Stephen Remedy Skilled Professional ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Refresh Table - Maintain Sort
Tony, My understanding is that PERFORM-ACTION-TABLE-REFRESH is the only command which allows you to specify the number of rows to return [from a field]. With PERFORM-ACTION-ACTIVE-LINK, can you specify the number of rows to return? Stephen Remedy Skilled Professional From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tony Worthington Sent: Thursday, March 06, 2008 9:43 AM To: arslist@ARSLIST.ORG Subject: Re: Refresh Table - Maintain Sort ** Not a solution to the actual problem .. but a workaround might be to push the refresh button in an a/l with perform-action-active-link 1 field id of refresh button -- Tony Worthington Sr. Technical Analyst Kohl's Department Stores [EMAIL PROTECTED] 262-703-5911 Heider, Stephen [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 03/06/2008 08:28 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Refresh Table - Maintain Sort ** ARS 6.3 p23 (server and user tool) I have noticed an undesirable behavior with refreshing tables when using the Run Process PERFORM-ACTION-TABLE-REFRESH command. I hope there is a work-around. Here is the issue: A user clicks on a table field column in order to sort by that column. The user then clicks a Refresh button. When workflow uses the Change Field - Refresh Table Field command the table field remains sorted by the column the user had selected. When workflow uses the Run Process - PERFORM-ACTION-TABLE-REFRESH command the sort order is reset to the default. Which means the user has to click the column again to sort by that column. Is there any way to stop ARS from resetting the default sort order for the table field? BTW, I use the PERFORM-ACTION-TABLE-REFRESH command so that users can determine how many rows to return. For example, on one of my screens I have a radio button that reads Show up to: o 100 o 250 o 500 o 750 o 1000 with 100 as the default. For most searches 100 is enough, yet users have the option to show more as needed. The full Run Process command is PERFORM-ACTION-TABLE-REFRESH 536870938 1 $zTmpInt1$. TIA Stephen Remedy Skilled Professional __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Refresh Table - Maintain Sort
Kalyan, The default sort, as defined in the table properties, is fine. It's when the user sorts it differently by clicking a column that I want to retain after a table refresh. The Change Field works but does not allow you to specify the number of rows to return. The PERFORM-ACTION-TABLE-REFRESH does allow you to specify the number of rows to return but resets the sort order to what is defined in the table properties. The goal is to prevent ARS from resetting the sort during a table refresh with the PERFORM-ACTION-TABLE-REFRESH command. Stephen From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kalyan Krishna Nethy Sent: Thursday, March 06, 2008 11:03 AM To: arslist@ARSLIST.ORG Subject: Re: Refresh Table - Maintain Sort ** Hi Stephen, I think you can mention the the fields to sort with in the table properties. I hope that will work. Regards, Kalyan. On Thu, Mar 6, 2008 at 9:22 PM, Heider, Stephen [EMAIL PROTECTED] wrote: ** Tony, My understanding is that PERFORM-ACTION-TABLE-REFRESH is the only command which allows you to specify the number of rows to return [from a field]. With PERFORM-ACTION-ACTIVE-LINK, can you specify the number of rows to return? Stephen Remedy Skilled Professional From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tony Worthington Sent: Thursday, March 06, 2008 9:43 AM To: arslist@ARSLIST.ORG Subject: Re: Refresh Table - Maintain Sort ** Not a solution to the actual problem .. but a workaround might be to push the refresh button in an a/l with perform-action-active-link 1 field id of refresh button -- Tony Worthington Sr. Technical Analyst Kohl's Department Stores [EMAIL PROTECTED] 262-703-5911 Heider, Stephen [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 03/06/2008 08:28 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Refresh Table - Maintain Sort ** ARS 6.3 p23 (server and user tool) I have noticed an undesirable behavior with refreshing tables when using the Run Process PERFORM-ACTION-TABLE-REFRESH command. I hope there is a work-around. Here is the issue: A user clicks on a table field column in order to sort by that column. The user then clicks a Refresh button. When workflow uses the Change Field - Refresh Table Field command the table field remains sorted by the column the user had selected. When workflow uses the Run Process - PERFORM-ACTION-TABLE-REFRESH command the sort order is reset to the default. Which means the user has to click the column again to sort by that column. Is there any way to stop ARS from resetting the default sort order for the table field? BTW, I use the PERFORM-ACTION-TABLE-REFRESH command so that users can determine how many rows to return. For example, on one of my screens I have a radio button that reads Show up to: o 100 o 250 o 500 o 750 o 1000 with 100 as the default. For most searches 100 is enough, yet users have the option to show more as needed. The full Run Process command is PERFORM-ACTION-TABLE-REFRESH 536870938 1 $zTmpInt1$. TIA Stephen Remedy Skilled Professional __Platinum Sponsor: www.rmsportal.com http://www.rmsportal.com/ ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com http://www.rmsportal.com/ ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com http://www.rmsportal.com/ ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Refresh Table - Maintain Sort
Oh, yea.. huh. :-) -- Tony Worthington Sr. Technical Analyst Kohl's Department Stores [EMAIL PROTECTED] 262-703-5911 Heider, Stephen [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 03/06/2008 09:52 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Refresh Table - Maintain Sort ** Tony, My understanding is that PERFORM-ACTION-TABLE-REFRESH is the only command which allows you to specify the number of rows to return [from a field]. With PERFORM-ACTION-ACTIVE-LINK, can you specify the number of rows to return? Stephen Remedy Skilled Professional From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tony Worthington Sent: Thursday, March 06, 2008 9:43 AM To: arslist@ARSLIST.ORG Subject: Re: Refresh Table - Maintain Sort ** Not a solution to the actual problem .. but a workaround might be to push the refresh button in an a/l with perform-action-active-link 1 field id of refresh button -- Tony Worthington Sr. Technical Analyst Kohl's Department Stores [EMAIL PROTECTED] 262-703-5911 Heider, Stephen [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 03/06/2008 08:28 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Refresh Table - Maintain Sort ** ARS 6.3 p23 (server and user tool) I have noticed an undesirable behavior with refreshing tables when using the Run Process PERFORM-ACTION-TABLE-REFRESH command. I hope there is a work-around. Here is the issue: A user clicks on a table field column in order to sort by that column. The user then clicks a Refresh button. When workflow uses the Change Field ? Refresh Table Field command the table field remains sorted by the column the user had selected. When workflow uses the Run Process - PERFORM-ACTION-TABLE-REFRESH command the sort order is reset to the default. Which means the user has to click the column again to sort by that column. Is there any way to stop ARS from resetting the default sort order for the table field? BTW, I use the PERFORM-ACTION-TABLE-REFRESH command so that users can determine how many rows to return. For example, on one of my screens I have a radio button that reads ?Show up to: o 100 o 250 o 500 o 750 o 1000? with 100 as the default. For most searches 100 is enough, yet users have the option to show more as needed. The full Run Process command is PERFORM-ACTION-TABLE-REFRESH 536870938 1 $zTmpInt1$. TIA Stephen Remedy Skilled Professional __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ CONFIDENTIALITY NOTICE: This is a transmission from Kohl's Department Stores, Inc. and may contain information which is confidential and proprietary. If you are not the addressee, any disclosure, copying or distribution or use of the contents of this message is expressly prohibited. If you have received this transmission in error, please destroy it and notify us immediately at 262-703-7000. CAUTION: Internet and e-mail communications are Kohl's property and Kohl's reserves the right to retrieve and read any message created, sent and received. Kohl's reserves the right to monitor messages by authorized Kohl's Associates at any time without any further consent. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are