Re: unable to read data from Table field more than one time
Peter, I've just red again your email. Could you give more details on what you described please? Specially on step 2 and 4. Many thanks Serouche P Romain ARSlist wrote: Are you using an EXTERNAL qualification for the table field? I assume you are: 1. parsing the CC field to get the first value (X) 2. putting the value in the table field external qualification 3. calling the guide which walks the table getting the values for appending to the mailing-list 4. parsing the CC field to get the next value (first time = Y) 5. jumping back to 2 if a value is found in 4 I remember a year or so ago having trouble getting server-side table fields to refresh in a scenario similar to the above but was told this had been fixed. If you are not doing the above how are you walking the table? Cheers Peter -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Remedy Maniac Sent: 14 November 2007 14:58 To: arslist@ARSLIST.ORG Subject: Re: unable to read data from Table field more than one time no this has nothing to do with a caching problem on the web. The only thing I do is to click on a Submit button in Form A. This button pushes the values of one field (called CC field) to another form let say Form B. On submit to that form B, I check entry per entry, whether it is a valid email address or it is a mailing-list. If valid email address I add that entry to another field (let say emails found) on that form B. If it is a mailing-list entry I check via a Table field in the Form B the logins associated to the mailing-list found and I add them to the field emails found. Upon completion of the whole operation I send back the results to the web page where I clicked on the Submit button. Up to now everything works perfect. The problem is if in the CC list I have several mailing-lists. The filters take only the logins found for the first list. And multiplies per mailing-lists found i.e if I have mailing-ist X and Y and Z. X with X-1 and X-2 logins. Y with Y-1 and Y-2 logins Z with Z-1 and Z-2 logins At the end I find in the final field X-1, X-2 which s fine for first mailing-list found (X) But instead of Y-1 and Y2 and Z-1 and Z-2, I find X-1 and X-2 X-1 and X-2. Three times corresponding to my X, Y and Z mailing-lists found. ... ??? ... so i am getting crazy Please HELP Serouche Rahul AR User wrote: ** Hi Serouche, Can you please confirm whether the same is working fine in the user tool? If the answer is yes then I believe that this is something to do with the Mid-Tier cache which is not refreshing. In the Mid-Tier, change the flush time to less, maybe for testing purpose you can change it to 5Sec, and then check. On Nov 14, 2007 3:27 PM, Remedy Maniac [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Dear listers, I have in Form A a table field which displays Lists and Logins. In addition in that Form A I have a Character field B. On the web I fire via a Submit button a bunch of Filters and an Filter Guide which reads in Loop the content of the Table Field. One of the filters pushes values to Form A into Character field B. Whenever this later is equal to Lists I read Logins That works perfectly. But only for the first value. i.e if on the web form I put for example 1, 2 and 3. In the form filters read 1=Lists and add the corresponding Logins But for 2 it adds again the Logins for 1 and so on and so on. However I can check that Table field displays correctly the values. But somehow I am not able to append to the precedence values the next values. I is starting to get me crazy. Please help. Thank you. Serouche ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org http://www.arslist.org/ Platinum Sponsor: www.rmsportal.com http://www.rmsportal.com/ ARSlist: Where the Answers Are -- Regards Rahul __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: unable to read data from Table field more than one time
ok thanks but I tried and I don't get it. In my filter guide I have 2 filters. First one set a character field to the column-2 found in the table field And second filter checks if the character field is not empty and append the content to a final character field with a set field action. So I believe the synch should be performed in first filter. But I still get 2 times the same values if I have 2 different lists. Any other help ? Thanks Serouche Ray Palla wrote: Filters inside a loop on a table field need the asynchronous runtime to read each row in the table, otherwise you only receive one pass and I believe it reads the last record in the table field. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Remedy Maniac Sent: Wednesday, November 14, 2007 9:40 AM To: arslist@ARSLIST.ORG Subject: Re: unable to read data from Table field more than one time no. I don't see why they should run asynchronously ?? There is no need. Or ? Could you give more details why they should run so? I red the docs nothing convinced me. Thanks Serouche Ray Palla wrote: Are you sure your filters are running asynchronously using the `! Naming convention? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of P Romain ARSlist Sent: Wednesday, November 14, 2007 9:18 AM To: arslist@ARSLIST.ORG Subject: Re: unable to read data from Table field more than one time Are you using an EXTERNAL qualification for the table field? I assume you are: 1. parsing the CC field to get the first value (X) 2. putting the value in the table field external qualification 3. calling the guide which walks the table getting the values for appending to the mailing-list 4. parsing the CC field to get the next value (first time = Y) 5. jumping back to 2 if a value is found in 4 I remember a year or so ago having trouble getting server-side table fields to refresh in a scenario similar to the above but was told this had been fixed. If you are not doing the above how are you walking the table? Cheers Peter -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Remedy Maniac Sent: 14 November 2007 14:58 To: arslist@ARSLIST.ORG Subject: Re: unable to read data from Table field more than one time no this has nothing to do with a caching problem on the web. The only thing I do is to click on a Submit button in Form A. This button pushes the values of one field (called CC field) to another form let say Form B. On submit to that form B, I check entry per entry, whether it is a valid email address or it is a mailing-list. If valid email address I add that entry to another field (let say emails found) on that form B. If it is a mailing-list entry I check via a Table field in the Form B the logins associated to the mailing-list found and I add them to the field emails found. Upon completion of the whole operation I send back the results to the web page where I clicked on the Submit button. Up to now everything works perfect. The problem is if in the CC list I have several mailing-lists. The filters take only the logins found for the first list. And multiplies per mailing-lists found i.e if I have mailing-ist X and Y and Z. X with X-1 and X-2 logins. Y with Y-1 and Y-2 logins Z with Z-1 and Z-2 logins At the end I find in the final field X-1, X-2 which s fine for first mailing-list found (X) But instead of Y-1 and Y2 and Z-1 and Z-2, I find X-1 and X-2 X-1 and X-2. Three times corresponding to my X, Y and Z mailing-lists found. ... ??? ... so i am getting crazy Please HELP Serouche Rahul AR User wrote: ** Hi Serouche, Can you please confirm whether the same is working fine in the user tool? If the answer is yes then I believe that this is something to do with the Mid-Tier cache which is not refreshing. In the Mid-Tier, change the flush time to less, maybe for testing purpose you can change it to 5Sec, and then check. On Nov 14, 2007 3:27 PM, Remedy Maniac [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Dear listers, I have in Form A a table field which displays Lists and Logins. In addition in that Form A I have a Character field B. On the web I fire via a Submit button a bunch of Filters and an Filter Guide which reads in Loop the content of the Table Field. One of the filters pushes values to Form A into Character field B. Whenever this later is equal to Lists I read Logins That works perfectly. But only for the first value. i.e if on the web form I put for example 1, 2 and 3. In the form filters read 1=Lists and add the corresponding Logins But for 2 it adds again the Logins for 1 and so on and so on. However I can check that Table field displays correctly the values. But somehow I am
Re: unable to read data from Table field more than one time
Hi Serouche, Try setting temp fields to the values in the table you are looping and pushing the temp fields (ie don't push the column values directly). Also, check that the phasing of the push is correct - you might neet to adjust it to run in phase 1. Cheers Peter Dear listers, I have in Form A a table field which displays Lists and Logins. In addition in that Form A I have a Character field B. On the web I fire via a Submit button a bunch of Filters and an Filter Guide which reads in Loop the content of the Table Field. One of the filters pushes values to Form A into Character field B. Whenever this later is equal to Lists I read Logins That works perfectly. But only for the first value. i.e if on the web form I put for example 1, 2 and 3. In the form filters read 1=Lists and add the corresponding Logins But for 2 it adds again the Logins for 1 and so on and so on. However I can check that Table field displays correctly the values. But somehow I am not able to append to the precedence values the next values. I is starting to get me crazy. Please help. Thank you. Serouche ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: unable to read data from Table field more than one time
Thanks Peter, actually I do not Push anything. What I do is on change of one field (let's say Assignee field), I check if this can be found in Lists of my Table. If yes I set field B, to Logins found in Table. Then I set field C to $PROCESS$ echo $B$ $C$ B and C are character fields. One strange behavior: let say Assignee = alpha and for this I find Logins = alpha-1 and alpha-2 So my field B will be = to alpha-1 and alpha-2 Then if there is Assignee = beta and if there is beta-1 and beta-2, the field B will be = to alpha-1, alpha-2, alpha-1, alpha-2 Here the strange behavior: in the Table I can see Beta and Beta-1 and Beta-2. i.e. the Table displays the correct values but somehow the Set fields takes all the time the same value. It's like to would be some caching somewhere. I am unable to flush that previous values. Of course for the Table I have Refresh on entry change checked. But this is for AL. And all my workflow is via filters. I also have for Initial Row Selection = Select first, fire workflow and for refresh row selection = Retain selection, fire workflow But I'll try with Push action. Maybe that will help. Serouche Peter Romain wrote: Hi Serouche, Try setting temp fields to the values in the table you are looping and pushing the temp fields (ie don't push the column values directly). Also, check that the phasing of the push is correct - you might neet to adjust it to run in phase 1. Cheers Peter Dear listers, I have in Form A a table field which displays Lists and Logins. In addition in that Form A I have a Character field B. On the web I fire via a Submit button a bunch of Filters and an Filter Guide which reads in Loop the content of the Table Field. One of the filters pushes values to Form A into Character field B. Whenever this later is equal to Lists I read Logins That works perfectly. But only for the first value. i.e if on the web form I put for example 1, 2 and 3. In the form filters read 1=Lists and add the corresponding Logins But for 2 it adds again the Logins for 1 and so on and so on. However I can check that Table field displays correctly the values. But somehow I am not able to append to the precedence values the next values. I is starting to get me crazy. Please help. Thank you. Serouche ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: unable to read data from Table field more than one time
push fields to a display only fields didn't help. Another idea? Any help will be appreciated. Thanks Serouche Peter Romain wrote: Hi Serouche, Try setting temp fields to the values in the table you are looping and pushing the temp fields (ie don't push the column values directly). Also, check that the phasing of the push is correct - you might neet to adjust it to run in phase 1. Cheers Peter Dear listers, I have in Form A a table field which displays Lists and Logins. In addition in that Form A I have a Character field B. On the web I fire via a Submit button a bunch of Filters and an Filter Guide which reads in Loop the content of the Table Field. One of the filters pushes values to Form A into Character field B. Whenever this later is equal to Lists I read Logins That works perfectly. But only for the first value. i.e if on the web form I put for example 1, 2 and 3. In the form filters read 1=Lists and add the corresponding Logins But for 2 it adds again the Logins for 1 and so on and so on. However I can check that Table field displays correctly the values. But somehow I am not able to append to the precedence values the next values. I is starting to get me crazy. Please help. Thank you. Serouche ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: unable to read data from Table field more than one time
Hi Serouche, Can you please confirm whether the same is working fine in the user tool? If the answer is yes then I believe that this is something to do with the Mid-Tier cache which is not refreshing. In the Mid-Tier, change the flush time to less, maybe for testing purpose you can change it to 5Sec, and then check. On Nov 14, 2007 3:27 PM, Remedy Maniac [EMAIL PROTECTED] wrote: Dear listers, I have in Form A a table field which displays Lists and Logins. In addition in that Form A I have a Character field B. On the web I fire via a Submit button a bunch of Filters and an Filter Guide which reads in Loop the content of the Table Field. One of the filters pushes values to Form A into Character field B. Whenever this later is equal to Lists I read Logins That works perfectly. But only for the first value. i.e if on the web form I put for example 1, 2 and 3. In the form filters read 1=Lists and add the corresponding Logins But for 2 it adds again the Logins for 1 and so on and so on. However I can check that Table field displays correctly the values. But somehow I am not able to append to the precedence values the next values. I is starting to get me crazy. Please help. Thank you. Serouche ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are -- Regards Rahul ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: unable to read data from Table field more than one time
no this has nothing to do with a caching problem on the web. The only thing I do is to click on a Submit button in Form A. This button pushes the values of one field (called CC field) to another form let say Form B. On submit to that form B, I check entry per entry, whether it is a valid email address or it is a mailing-list. If valid email address I add that entry to another field (let say emails found) on that form B. If it is a mailing-list entry I check via a Table field in the Form B the logins associated to the mailing-list found and I add them to the field emails found. Upon completion of the whole operation I send back the results to the web page where I clicked on the Submit button. Up to now everything works perfect. The problem is if in the CC list I have several mailing-lists. The filters take only the logins found for the first list. And multiplies per mailing-lists found i.e if I have mailing-ist X and Y and Z. X with X-1 and X-2 logins. Y with Y-1 and Y-2 logins Z with Z-1 and Z-2 logins At the end I find in the final field X-1, X-2 which s fine for first mailing-list found (X) But instead of Y-1 and Y2 and Z-1 and Z-2, I find X-1 and X-2 X-1 and X-2. Three times corresponding to my X, Y and Z mailing-lists found. ... ??? ... so i am getting crazy Please HELP Serouche Rahul AR User wrote: ** Hi Serouche, Can you please confirm whether the same is working fine in the user tool? If the answer is yes then I believe that this is something to do with the Mid-Tier cache which is not refreshing. In the Mid-Tier, change the flush time to less, maybe for testing purpose you can change it to 5Sec, and then check. On Nov 14, 2007 3:27 PM, Remedy Maniac [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Dear listers, I have in Form A a table field which displays Lists and Logins. In addition in that Form A I have a Character field B. On the web I fire via a Submit button a bunch of Filters and an Filter Guide which reads in Loop the content of the Table Field. One of the filters pushes values to Form A into Character field B. Whenever this later is equal to Lists I read Logins That works perfectly. But only for the first value. i.e if on the web form I put for example 1, 2 and 3. In the form filters read 1=Lists and add the corresponding Logins But for 2 it adds again the Logins for 1 and so on and so on. However I can check that Table field displays correctly the values. But somehow I am not able to append to the precedence values the next values. I is starting to get me crazy. Please help. Thank you. Serouche ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org http://www.arslist.org/ Platinum Sponsor: www.rmsportal.com http://www.rmsportal.com/ ARSlist: Where the Answers Are -- Regards Rahul __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: unable to read data from Table field more than one time
Are you using an EXTERNAL qualification for the table field? I assume you are: 1. parsing the CC field to get the first value (X) 2. putting the value in the table field external qualification 3. calling the guide which walks the table getting the values for appending to the mailing-list 4. parsing the CC field to get the next value (first time = Y) 5. jumping back to 2 if a value is found in 4 I remember a year or so ago having trouble getting server-side table fields to refresh in a scenario similar to the above but was told this had been fixed. If you are not doing the above how are you walking the table? Cheers Peter -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Remedy Maniac Sent: 14 November 2007 14:58 To: arslist@ARSLIST.ORG Subject: Re: unable to read data from Table field more than one time no this has nothing to do with a caching problem on the web. The only thing I do is to click on a Submit button in Form A. This button pushes the values of one field (called CC field) to another form let say Form B. On submit to that form B, I check entry per entry, whether it is a valid email address or it is a mailing-list. If valid email address I add that entry to another field (let say emails found) on that form B. If it is a mailing-list entry I check via a Table field in the Form B the logins associated to the mailing-list found and I add them to the field emails found. Upon completion of the whole operation I send back the results to the web page where I clicked on the Submit button. Up to now everything works perfect. The problem is if in the CC list I have several mailing-lists. The filters take only the logins found for the first list. And multiplies per mailing-lists found i.e if I have mailing-ist X and Y and Z. X with X-1 and X-2 logins. Y with Y-1 and Y-2 logins Z with Z-1 and Z-2 logins At the end I find in the final field X-1, X-2 which s fine for first mailing-list found (X) But instead of Y-1 and Y2 and Z-1 and Z-2, I find X-1 and X-2 X-1 and X-2. Three times corresponding to my X, Y and Z mailing-lists found. ... ??? ... so i am getting crazy Please HELP Serouche Rahul AR User wrote: ** Hi Serouche, Can you please confirm whether the same is working fine in the user tool? If the answer is yes then I believe that this is something to do with the Mid-Tier cache which is not refreshing. In the Mid-Tier, change the flush time to less, maybe for testing purpose you can change it to 5Sec, and then check. On Nov 14, 2007 3:27 PM, Remedy Maniac [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Dear listers, I have in Form A a table field which displays Lists and Logins. In addition in that Form A I have a Character field B. On the web I fire via a Submit button a bunch of Filters and an Filter Guide which reads in Loop the content of the Table Field. One of the filters pushes values to Form A into Character field B. Whenever this later is equal to Lists I read Logins That works perfectly. But only for the first value. i.e if on the web form I put for example 1, 2 and 3. In the form filters read 1=Lists and add the corresponding Logins But for 2 it adds again the Logins for 1 and so on and so on. However I can check that Table field displays correctly the values. But somehow I am not able to append to the precedence values the next values. I is starting to get me crazy. Please help. Thank you. Serouche ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org http://www.arslist.org/ Platinum Sponsor: www.rmsportal.com http://www.rmsportal.com/ ARSlist: Where the Answers Are -- Regards Rahul __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: unable to read data from Table field more than one time
the Table field has a qualification like $field on my form$ = 'values in the other form' I parse the CC field into another field A. Everytime field A = $field on my form$ 'values in the other form' are changed in the Table. That works fine. But to copy these later to another field doesn't work. Not Set field works nore Push fields. I tried with Display only fields and also with Optional fields. I even tried to push the values to a third form. Still doesn't work. It's like a value kept in sort of cache. Weired :-/ P Romain ARSlist wrote: Are you using an EXTERNAL qualification for the table field? I assume you are: 1. parsing the CC field to get the first value (X) 2. putting the value in the table field external qualification 3. calling the guide which walks the table getting the values for appending to the mailing-list 4. parsing the CC field to get the next value (first time = Y) 5. jumping back to 2 if a value is found in 4 I remember a year or so ago having trouble getting server-side table fields to refresh in a scenario similar to the above but was told this had been fixed. If you are not doing the above how are you walking the table? Cheers Peter -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Remedy Maniac Sent: 14 November 2007 14:58 To: arslist@ARSLIST.ORG Subject: Re: unable to read data from Table field more than one time no this has nothing to do with a caching problem on the web. The only thing I do is to click on a Submit button in Form A. This button pushes the values of one field (called CC field) to another form let say Form B. On submit to that form B, I check entry per entry, whether it is a valid email address or it is a mailing-list. If valid email address I add that entry to another field (let say emails found) on that form B. If it is a mailing-list entry I check via a Table field in the Form B the logins associated to the mailing-list found and I add them to the field emails found. Upon completion of the whole operation I send back the results to the web page where I clicked on the Submit button. Up to now everything works perfect. The problem is if in the CC list I have several mailing-lists. The filters take only the logins found for the first list. And multiplies per mailing-lists found i.e if I have mailing-ist X and Y and Z. X with X-1 and X-2 logins. Y with Y-1 and Y-2 logins Z with Z-1 and Z-2 logins At the end I find in the final field X-1, X-2 which s fine for first mailing-list found (X) But instead of Y-1 and Y2 and Z-1 and Z-2, I find X-1 and X-2 X-1 and X-2. Three times corresponding to my X, Y and Z mailing-lists found. ... ??? ... so i am getting crazy Please HELP Serouche Rahul AR User wrote: ** Hi Serouche, Can you please confirm whether the same is working fine in the user tool? If the answer is yes then I believe that this is something to do with the Mid-Tier cache which is not refreshing. In the Mid-Tier, change the flush time to less, maybe for testing purpose you can change it to 5Sec, and then check. On Nov 14, 2007 3:27 PM, Remedy Maniac [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Dear listers, I have in Form A a table field which displays Lists and Logins. In addition in that Form A I have a Character field B. On the web I fire via a Submit button a bunch of Filters and an Filter Guide which reads in Loop the content of the Table Field. One of the filters pushes values to Form A into Character field B. Whenever this later is equal to Lists I read Logins That works perfectly. But only for the first value. i.e if on the web form I put for example 1, 2 and 3. In the form filters read 1=Lists and add the corresponding Logins But for 2 it adds again the Logins for 1 and so on and so on. However I can check that Table field displays correctly the values. But somehow I am not able to append to the precedence values the next values. I is starting to get me crazy. Please help. Thank you. Serouche ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org http://www.arslist.org/ Platinum Sponsor: www.rmsportal.com http://www.rmsportal.com/ ARSlist: Where the Answers Are -- Regards Rahul __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers
Re: unable to read data from Table field more than one time
Are you sure your filters are running asynchronously using the `! Naming convention? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of P Romain ARSlist Sent: Wednesday, November 14, 2007 9:18 AM To: arslist@ARSLIST.ORG Subject: Re: unable to read data from Table field more than one time Are you using an EXTERNAL qualification for the table field? I assume you are: 1. parsing the CC field to get the first value (X) 2. putting the value in the table field external qualification 3. calling the guide which walks the table getting the values for appending to the mailing-list 4. parsing the CC field to get the next value (first time = Y) 5. jumping back to 2 if a value is found in 4 I remember a year or so ago having trouble getting server-side table fields to refresh in a scenario similar to the above but was told this had been fixed. If you are not doing the above how are you walking the table? Cheers Peter -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Remedy Maniac Sent: 14 November 2007 14:58 To: arslist@ARSLIST.ORG Subject: Re: unable to read data from Table field more than one time no this has nothing to do with a caching problem on the web. The only thing I do is to click on a Submit button in Form A. This button pushes the values of one field (called CC field) to another form let say Form B. On submit to that form B, I check entry per entry, whether it is a valid email address or it is a mailing-list. If valid email address I add that entry to another field (let say emails found) on that form B. If it is a mailing-list entry I check via a Table field in the Form B the logins associated to the mailing-list found and I add them to the field emails found. Upon completion of the whole operation I send back the results to the web page where I clicked on the Submit button. Up to now everything works perfect. The problem is if in the CC list I have several mailing-lists. The filters take only the logins found for the first list. And multiplies per mailing-lists found i.e if I have mailing-ist X and Y and Z. X with X-1 and X-2 logins. Y with Y-1 and Y-2 logins Z with Z-1 and Z-2 logins At the end I find in the final field X-1, X-2 which s fine for first mailing-list found (X) But instead of Y-1 and Y2 and Z-1 and Z-2, I find X-1 and X-2 X-1 and X-2. Three times corresponding to my X, Y and Z mailing-lists found. ... ??? ... so i am getting crazy Please HELP Serouche Rahul AR User wrote: ** Hi Serouche, Can you please confirm whether the same is working fine in the user tool? If the answer is yes then I believe that this is something to do with the Mid-Tier cache which is not refreshing. In the Mid-Tier, change the flush time to less, maybe for testing purpose you can change it to 5Sec, and then check. On Nov 14, 2007 3:27 PM, Remedy Maniac [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Dear listers, I have in Form A a table field which displays Lists and Logins. In addition in that Form A I have a Character field B. On the web I fire via a Submit button a bunch of Filters and an Filter Guide which reads in Loop the content of the Table Field. One of the filters pushes values to Form A into Character field B. Whenever this later is equal to Lists I read Logins That works perfectly. But only for the first value. i.e if on the web form I put for example 1, 2 and 3. In the form filters read 1=Lists and add the corresponding Logins But for 2 it adds again the Logins for 1 and so on and so on. However I can check that Table field displays correctly the values. But somehow I am not able to append to the precedence values the next values. I is starting to get me crazy. Please help. Thank you. Serouche ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org http://www.arslist.org/ Platinum Sponsor: www.rmsportal.com http://www.rmsportal.com/ ARSlist: Where the Answers Are -- Regards Rahul __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: unable to read data from Table field more than one time
no. I don't see why they should run asynchronously ?? There is no need. Or ? Could you give more details why they should run so? I red the docs nothing convinced me. Thanks Serouche Ray Palla wrote: Are you sure your filters are running asynchronously using the `! Naming convention? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of P Romain ARSlist Sent: Wednesday, November 14, 2007 9:18 AM To: arslist@ARSLIST.ORG Subject: Re: unable to read data from Table field more than one time Are you using an EXTERNAL qualification for the table field? I assume you are: 1. parsing the CC field to get the first value (X) 2. putting the value in the table field external qualification 3. calling the guide which walks the table getting the values for appending to the mailing-list 4. parsing the CC field to get the next value (first time = Y) 5. jumping back to 2 if a value is found in 4 I remember a year or so ago having trouble getting server-side table fields to refresh in a scenario similar to the above but was told this had been fixed. If you are not doing the above how are you walking the table? Cheers Peter -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Remedy Maniac Sent: 14 November 2007 14:58 To: arslist@ARSLIST.ORG Subject: Re: unable to read data from Table field more than one time no this has nothing to do with a caching problem on the web. The only thing I do is to click on a Submit button in Form A. This button pushes the values of one field (called CC field) to another form let say Form B. On submit to that form B, I check entry per entry, whether it is a valid email address or it is a mailing-list. If valid email address I add that entry to another field (let say emails found) on that form B. If it is a mailing-list entry I check via a Table field in the Form B the logins associated to the mailing-list found and I add them to the field emails found. Upon completion of the whole operation I send back the results to the web page where I clicked on the Submit button. Up to now everything works perfect. The problem is if in the CC list I have several mailing-lists. The filters take only the logins found for the first list. And multiplies per mailing-lists found i.e if I have mailing-ist X and Y and Z. X with X-1 and X-2 logins. Y with Y-1 and Y-2 logins Z with Z-1 and Z-2 logins At the end I find in the final field X-1, X-2 which s fine for first mailing-list found (X) But instead of Y-1 and Y2 and Z-1 and Z-2, I find X-1 and X-2 X-1 and X-2. Three times corresponding to my X, Y and Z mailing-lists found. ... ??? ... so i am getting crazy Please HELP Serouche Rahul AR User wrote: ** Hi Serouche, Can you please confirm whether the same is working fine in the user tool? If the answer is yes then I believe that this is something to do with the Mid-Tier cache which is not refreshing. In the Mid-Tier, change the flush time to less, maybe for testing purpose you can change it to 5Sec, and then check. On Nov 14, 2007 3:27 PM, Remedy Maniac [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Dear listers, I have in Form A a table field which displays Lists and Logins. In addition in that Form A I have a Character field B. On the web I fire via a Submit button a bunch of Filters and an Filter Guide which reads in Loop the content of the Table Field. One of the filters pushes values to Form A into Character field B. Whenever this later is equal to Lists I read Logins That works perfectly. But only for the first value. i.e if on the web form I put for example 1, 2 and 3. In the form filters read 1=Lists and add the corresponding Logins But for 2 it adds again the Logins for 1 and so on and so on. However I can check that Table field displays correctly the values. But somehow I am not able to append to the precedence values the next values. I is starting to get me crazy. Please help. Thank you. Serouche ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org http://www.arslist.org/ Platinum Sponsor: www.rmsportal.com http://www.rmsportal.com/ ARSlist: Where the Answers Are -- Regards Rahul __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers
Re: unable to read data from Table field more than one time
Filters inside a loop on a table field need the asynchronous runtime to read each row in the table, otherwise you only receive one pass and I believe it reads the last record in the table field. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Remedy Maniac Sent: Wednesday, November 14, 2007 9:40 AM To: arslist@ARSLIST.ORG Subject: Re: unable to read data from Table field more than one time no. I don't see why they should run asynchronously ?? There is no need. Or ? Could you give more details why they should run so? I red the docs nothing convinced me. Thanks Serouche Ray Palla wrote: Are you sure your filters are running asynchronously using the `! Naming convention? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of P Romain ARSlist Sent: Wednesday, November 14, 2007 9:18 AM To: arslist@ARSLIST.ORG Subject: Re: unable to read data from Table field more than one time Are you using an EXTERNAL qualification for the table field? I assume you are: 1. parsing the CC field to get the first value (X) 2. putting the value in the table field external qualification 3. calling the guide which walks the table getting the values for appending to the mailing-list 4. parsing the CC field to get the next value (first time = Y) 5. jumping back to 2 if a value is found in 4 I remember a year or so ago having trouble getting server-side table fields to refresh in a scenario similar to the above but was told this had been fixed. If you are not doing the above how are you walking the table? Cheers Peter -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Remedy Maniac Sent: 14 November 2007 14:58 To: arslist@ARSLIST.ORG Subject: Re: unable to read data from Table field more than one time no this has nothing to do with a caching problem on the web. The only thing I do is to click on a Submit button in Form A. This button pushes the values of one field (called CC field) to another form let say Form B. On submit to that form B, I check entry per entry, whether it is a valid email address or it is a mailing-list. If valid email address I add that entry to another field (let say emails found) on that form B. If it is a mailing-list entry I check via a Table field in the Form B the logins associated to the mailing-list found and I add them to the field emails found. Upon completion of the whole operation I send back the results to the web page where I clicked on the Submit button. Up to now everything works perfect. The problem is if in the CC list I have several mailing-lists. The filters take only the logins found for the first list. And multiplies per mailing-lists found i.e if I have mailing-ist X and Y and Z. X with X-1 and X-2 logins. Y with Y-1 and Y-2 logins Z with Z-1 and Z-2 logins At the end I find in the final field X-1, X-2 which s fine for first mailing-list found (X) But instead of Y-1 and Y2 and Z-1 and Z-2, I find X-1 and X-2 X-1 and X-2. Three times corresponding to my X, Y and Z mailing-lists found. ... ??? ... so i am getting crazy Please HELP Serouche Rahul AR User wrote: ** Hi Serouche, Can you please confirm whether the same is working fine in the user tool? If the answer is yes then I believe that this is something to do with the Mid-Tier cache which is not refreshing. In the Mid-Tier, change the flush time to less, maybe for testing purpose you can change it to 5Sec, and then check. On Nov 14, 2007 3:27 PM, Remedy Maniac [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Dear listers, I have in Form A a table field which displays Lists and Logins. In addition in that Form A I have a Character field B. On the web I fire via a Submit button a bunch of Filters and an Filter Guide which reads in Loop the content of the Table Field. One of the filters pushes values to Form A into Character field B. Whenever this later is equal to Lists I read Logins That works perfectly. But only for the first value. i.e if on the web form I put for example 1, 2 and 3. In the form filters read 1=Lists and add the corresponding Logins But for 2 it adds again the Logins for 1 and so on and so on. However I can check that Table field displays correctly the values. But somehow I am not able to append to the precedence values the next values. I is starting to get me crazy. Please help. Thank you. Serouche __ __ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org http://www.arslist.org/ Platinum Sponsor: www.rmsportal.com http://www.rmsportal.com/ ARSlist: Where the Answers