Re: Complicated Table Loops
Hi Lisa. Table Looping can get a little wonky - when you try to walk them in a filter guide. I for one cannot think of a way to refresh a table field in a filter. At this point I am at a bit of loss trying to figure out what you are trying to accomplish - I have questions like: 1. Do you want to do all the workflow through filters? 2. Are you firing on a Display only form or a regular form? 3. When looping through the first table are you dynamically changing the qualification on the other two tables? 4. Can you use an active link to trigger the workflow; hence, taking advantage of the new Service Action? Let me know - maybe we can think of a way to get you going. On Oct 31, 6:20 pm, Kemes, Lisa lisa.ke...@te.com wrote: I've done multiple table loops on one form using an active link guide, but when I need to do this in an automated Filter Guide, for some reason it gets tricky. I have 3 tables on my form. I want to loop through the first table and then the 2nd and 3rd table will give me data based on the record in the first table. It's easy when I do an active link guide because I can refresh the tables 2 and 3 when the records in the first table get looped. But it doesn't seem to happen in filters (or filter guides). I have my first table set to fire workflow when selected, but how to I fire a refresh of table 2 and 3 in a filter? Lisa Kames AR System Developer TEIS - USA +1 717 810 2408 tell +1 717 602 9460 mobile lisa.ke...@te.commailto:lisa.ke...@te.com 100 Amp Drive Harrisburg, PA 17112 [http://www.te.com/images/socialmedia/smallTElogo.gif]http://www.te.com/ www.te.comhttp://www.te.com/ [http://www.te.com/images/socialmedia/twitter.png]http://twitter.com/teconnectivity [http://www.te.com/images/socialmedia/facebook.png] http://www.facebook.com/teconnectivity [http://www.te.com/images/socialmedia/flickr.png] http://www.flickr.com/photos/teconnectivity/ [http://www.te.com/images/socialmedia/linkedin.png] http://www.linkedin.com/groups?gid=1591657 [http://www.te.com/images/socialmedia/youtube.png] http://www.youtube.com/teconnectivity ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org attend wwrug12www.wwrug12.comARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Complicated Table Loops
Hi, Maybe you can do this with a service-call for each row, and pass the row-specific data to the service. Then you can do the second loop from inside the service. This can be done on a separate display-only form, or in the same form without loading all data. Just pass the data you need to the service, and return the resulting data fields. I have done exactly this, and the depth has been 4-5 levels... Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. I've done multiple table loops on one form using an active link guide, but when I need to do this in an automated Filter Guide, for some reason it gets tricky. I have 3 tables on my form. I want to loop through the first table and then the 2nd and 3rd table will give me data based on the record in the first table. It's easy when I do an active link guide because I can refresh the tables 2 and 3 when the records in the first table get looped. But it doesn't seem to happen in filters (or filter guides). I have my first table set to fire workflow when selected, but how to I fire a refresh of table 2 and 3 in a filter? Lisa Kames AR System Developer TEIS - USA +1 717 810 2408 tell +1 717 602 9460 mobile lisa.ke...@te.commailto:lisa.ke...@te.com 100 Amp Drive Harrisburg, PA 17112 [http://www.te.com/images/socialmedia/smallTElogo.gif]http://www.te.com/ www.te.comhttp://www.te.com/ [http://www.te.com/images/socialmedia/twitter.png]http://twitter.com/teconnectivity [http://www.te.com/images/socialmedia/facebook.png] http://www.facebook.com/teconnectivity [http://www.te.com/images/socialmedia/flickr.png] http://www.flickr.com/photos/teconnectivity/ [http://www.te.com/images/socialmedia/linkedin.png] http://www.linkedin.com/groups?gid=1591657 [http://www.te.com/images/socialmedia/youtube.png] http://www.youtube.com/teconnectivity ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Complicated Table Loops
From what I understand, after reviewing logs is that the table gets refreshed in a filter as soon as you hit the Table Loop Call Guide. By staging the filter guides will determine the refresh order of the tables. the order of the guides determines the order the tables will get refreshed. This can be tested by setting an external Qual right before firing the table loop guide, and testing the results On Nov 1, 12:08 pm, Misi Mladoniczky m...@rrr.se wrote: Hi, Maybe you can do this with a service-call for each row, and pass the row-specific data to the service. Then you can do the second loop from inside the service. This can be done on a separate display-only form, or in the same form without loading all data. Just pass the data you need to the service, and return the resulting data fields. I have done exactly this, and the depth has been 4-5 levels... Best Regards - Misi, RRR AB,http://www.rrr.se(ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, athttp://rrr.se. I've done multiple table loops on one form using an active link guide, but when I need to do this in an automated Filter Guide, for some reason it gets tricky. I have 3 tables on my form. I want to loop through the first table and then the 2nd and 3rd table will give me data based on the record in the first table. It's easy when I do an active link guide because I can refresh the tables 2 and 3 when the records in the first table get looped. But it doesn't seem to happen in filters (or filter guides). I have my first table set to fire workflow when selected, but how to I fire a refresh of table 2 and 3 in a filter? Lisa Kames AR System Developer TEIS - USA +1 717 810 2408begin_of_the_skype_highlighting +1 717 810 2408 end_of_the_skype_highlightingtell +1 717 602 9460begin_of_the_skype_highlighting +1 717 602 9460 end_of_the_skype_highlightingmobile lisa.ke...@te.commailto:lisa.ke...@te.com 100 Amp Drive Harrisburg, PA 17112 [http://www.te.com/images/socialmedia/smallTElogo.gif]http://www.te.com/ www.te.comhttp://www.te.com/ [http://www.te.com/images/socialmedia/twitter.png]http://twitter.com/teconnectivity [http://www.te.com/images/socialmedia/facebook.png] http://www.facebook.com/teconnectivity [http://www.te.com/images/socialmedia/flickr.png] http://www.flickr.com/photos/teconnectivity/ [http://www.te.com/images/socialmedia/linkedin.png] http://www.linkedin.com/groups?gid=1591657 [http://www.te.com/images/socialmedia/youtube.png] http://www.youtube.com/teconnectivity ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org attend wwrug12www.wwrug12.comARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org attend wwrug12www.wwrug12.comARSList: Where the Answers Are- Hide quoted text - - Show quoted text - ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
