Regarding Multiple Selection in a Table
Hi All, We have a custom workflow where based on selection of entries from a table the external query in another table changes and populates the records accordingly. Condition Used: ($ROWSELECTED$ = 2) OR ($ROWSELECTED$ = 1) in a Active Link Guide Single selection is working fine but multiple selection is not working as expected. Please help with possible solutions. Thank you, Sriram ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Regarding Multiple Selection in a Table
Sriram, I think you are on the wrong track. $ROWSELECTED$ is the value set on the client when a user clicks on a particular row. It doesn't make sense using it in a table field query condition. What exactly are you trying to return in Table 2 when a selection or selections are made on Table 1?? Give that a thought and then you need to build that qualification for Table 2 according to that. Joe _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of sriram pm Sent: Thursday, March 20, 2014 4:35 AM To: arslist@ARSLIST.ORG Subject: Regarding Multiple Selection in a Table ** Hi All, We have a custom workflow where based on selection of entries from a table the external query in another table changes and populates the records accordingly. Condition Used: ($ROWSELECTED$ = 2) OR ($ROWSELECTED$ = 1) in a Active Link Guide Single selection is working fine but multiple selection is not working as expected. Please help with possible solutions. Thank you, Sriram ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Regarding Multiple Selection in a Table
Hi Joe, The First Table has different Groups. Based on the selection I need to modify the external query and display the entries in the second table. For single entry selection it works fine but for Multiple entry selection I need to append the external query and refresh the second table. Thank you, Sriram. On Thu, Mar 20, 2014 at 2:11 PM, Joe D'Souza jdso...@shyle.net wrote: ** Sriram, I think you are on the wrong track. $ROWSELECTED$ is the value set on the client when a user clicks on a particular row. It doesn't make sense using it in a table field query condition. What exactly are you trying to return in Table 2 when a selection or selections are made on Table 1?? Give that a thought and then you need to build that qualification for Table 2 according to that. Joe -- *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *sriram pm *Sent:* Thursday, March 20, 2014 4:35 AM *To:* arslist@ARSLIST.ORG *Subject:* Regarding Multiple Selection in a Table ** Hi All, We have a custom workflow where based on selection of entries from a table the external query in another table changes and populates the records accordingly. Condition Used: ($ROWSELECTED$ = 2) OR ($ROWSELECTED$ = 1) in a Active Link Guide Single selection is working fine but multiple selection is not working as expected. Please help with possible solutions. Thank you, Sriram _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Regarding Multiple Selection in a Table
I understood what you are trying to say. But what does the qualification need to be in the second table? What is the common data between the selected rows of the first table, that need to be present in the second table? That common data needs to feature in that query. For eg If table 1 contains rows with data A C D B E Table 2 contains data A A B C A B C C And you have selected row 1 and row 4 of table 1 with values A and B, do you need to display rows 1,2 3 and 6 from table 2? In that case your qualification would need to be 'Field' = A OR 'Field' = B. That would need to be your external qualification. And Not $ROWSELECTED$ = 1 OR $ROWSELECTED$ = 4 - this would be wrong. Joe _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of sriram pm Sent: Thursday, March 20, 2014 4:49 AM To: arslist@ARSLIST.ORG Subject: Re: Regarding Multiple Selection in a Table ** Hi Joe, The First Table has different Groups. Based on the selection I need to modify the external query and display the entries in the second table. For single entry selection it works fine but for Multiple entry selection I need to append the external query and refresh the second table. Thank you, Sriram. On Thu, Mar 20, 2014 at 2:11 PM, Joe D'Souza jdso...@shyle.net wrote: ** Sriram, I think you are on the wrong track. $ROWSELECTED$ is the value set on the client when a user clicks on a particular row. It doesn't make sense using it in a table field query condition. What exactly are you trying to return in Table 2 when a selection or selections are made on Table 1?? Give that a thought and then you need to build that qualification for Table 2 according to that. Joe _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of sriram pm Sent: Thursday, March 20, 2014 4:35 AM To: arslist@ARSLIST.ORG Subject: Regarding Multiple Selection in a Table ** Hi All, We have a custom workflow where based on selection of entries from a table the external query in another table changes and populates the records accordingly. Condition Used: ($ROWSELECTED$ = 2) OR ($ROWSELECTED$ = 1) in a Active Link Guide Single selection is working fine but multiple selection is not working as expected. Please help with possible solutions. Thank you, Sriram _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Regarding Multiple Selection in a Table
Sriram, You will have to create an AL loop of the selected rows in order to build your qualification for the second table. Jay From: sriram pm ramjavas...@gmail.com To: arslist@ARSLIST.ORG Sent: Thursday, March 20, 2014 2:48 AM Subject: Re: Regarding Multiple Selection in a Table ** Hi Joe, The First Table has different Groups. Based on the selection I need to modify the external query and display the entries in the second table. For single entry selection it works fine but for Multiple entry selection I need to append the external query and refresh the second table. Thank you, Sriram. On Thu, Mar 20, 2014 at 2:11 PM, Joe D'Souza jdso...@shyle.net wrote: ** Sriram, I think you are on the wrong track. $ROWSELECTED$ is the value set on the client when a user clicks on a particular row. It doesn’t make sense using it in a table field query condition. What exactly are you trying to return in Table 2 when a selection or selections are made on Table 1?? Give that a thought and then you need to build that qualification for Table 2 according to that. Joe From:Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of sriram pm Sent: Thursday, March 20, 2014 4:35 AM To: arslist@ARSLIST.ORG Subject: Regarding Multiple Selection in a Table ** Hi All, We have a custom workflow where based on selection of entries from a table the external query in another table changes and populates the records accordingly. Condition Used: ($ROWSELECTED$ = 2) OR ($ROWSELECTED$ = 1) in a Active Link Guide Single selection is working fine but multiple selection is not working as expected. Please help with possible solutions. Thank you, Sriram _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years