Serouche, First, the PERFORM-ACTION-TABLE-CLEAR doesn't refresh a table, it clears the table and does not refresh again (unless some follow-on workflow refreshes the table.) Second, this action is not available AT ALL in filter workflow. It is ONLY available in an Active Link. Third, you cannot use active link workflow to "interrupt" server-side workflow, which is what you are trying to do by "sliding in" the Active Link to clear the table while the filter guide is running. This simply will not work.
I do not have a good enough understanding of your workflow to know exactly what to do, but it sounds as though your workflow that adds the value of column2 to Field 2 is executing twice. (If I understood correctly, you are actually appending to field 2, not overwriting field 2). If this is the case, then you need to qualify your filter that appends the value to "test" to see if the value has already been appended. You could do this in any number of ways. I could probably provide better information if I more thoroughly understood your workflow sequence. Scott Parrish IT Prophets, LLC (770) 653-5203 http://www.itprophets.com -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Remedy Maniac Sent: Friday, November 09, 2007 03:00 AM To: [email protected] Subject: Re: PERFORM-ACTION-TABLE-CLEAR seems not to work ok fine I get this. So I tried to build an AL which will clear the table while my Filter Guide is runing. But I am not able to find a way to slide the AL into the guide. Seems that the execute on conditions do not help. Any idea on this matter? Serouche Hugo Visser wrote: > If you are running this from within filter guides, I think you can't > make the server refresh a table you are processing. It's refreshed > once when you first access it, and the server appears to cache the > result in the transaction you are running. So even if you change the > qualification in workflow, you'd still get the "old" resultset from > the first load in that transaction. > > The PERFORM-ACTION-TABLE-CLEAR run process only works on the client > when using active links. > > Hugo > > On Nov 8, 2007 5:32 PM, Joe D'Souza <[EMAIL PROTECTED]> wrote: > >> ** >> >> Is the Active Link firing? Have you got the right permissions on the Active >> Link for the user that is attempting this? Take an Active Link log and lets >> have a look to see what is really happening.. >> >> Cheers >> >> Joe D'Souza >> >> >> -----Original Message----- >> From: Action Request System discussion list(ARSList) >> [mailto:[EMAIL PROTECTED] Behalf Of Remedy Maniac >> >> Sent: Thursday, November 08, 2007 11:17 AM >> To: [email protected] >> Subject: Re: PERFORM-ACTION-TABLE-CLEAR seems not to work >> >> >> thanks Joe for the tips but that doesn"t help :-( >> >> >> Joe D'Souza wrote: >> >>> ** >>> Running from a Filter will clear the table on the Server side for >>> server side table field workflow processing.. You got to run it from >>> an Active Link for it to work. You wont see the results (clear table) >>> on the client side. >>> >>> Cheers >>> >>> /*Joe D'Souza*/ >>> >>> -----Original Message----- >>> From: Action Request System discussion list(ARSList) >>> [mailto:[EMAIL PROTECTED] Behalf Of Remedy Maniac >>> Sent: Thursday, November 08, 2007 10:38 AM >>> To: [email protected] >>> Subject: Re: PERFORM-ACTION-TABLE-CLEAR seems not to work >>> >>> >>> nop. >>> It doesn't work. >>> I am trying to run this through Filter guides with a loop on the table. >>> maybe I am putting the run process at the wrong place. >>> >>> >>> Pargeter, Christie wrote: >>> >>>> It should be PERFORM-ACTION-TABLE-CLEAR 536870923 (the field id with >>>> >>> no $$ or '' around it) >>> >>>> -----Original Message----- >>>> From: Action Request System discussion list(ARSList) >>>> >>> [mailto:[EMAIL PROTECTED] On Behalf Of Remedy Maniac >>> >>>> Sent: Thursday, November 08, 2007 7:10 AM >>>> To: [email protected] >>>> Subject: PERFORM-ACTION-TABLE-CLEAR seems not to work >>>> >>>> dear listers, >>>> >>>> basically I have a form X with Field1 and Field2 and 1 Table field >>>> >>> from form Y with column1 and column2 => in Table property I have set >>> as Qualification Field1 = column1 and Field1 is read dynamically based >>> on the workflow. >>> >>>> I read the value of Field1 and when it is = to column1, I add the >>>> >>> value of column2 to Field2. >>> >>>> So far so good. >>>> >>>> In my form Y I have for column1 A and B >>>> Column2 has C for A and D and E for B >>>> Depending in which order I read Field1 (A first or B first) I always >>>> >>> get two times values from colum2 => i.e. if I read A first I get >>> Field2 = D,E,D,E If I read B first then I get for Field2 = C,C >>> >>>> So I assumed I should run "PERFORM-ACTION-TABLE-CLEAR <Table Field>" >>>> after reading first value so the table field qualification gets >>>> >>> refreshed and takes next value. But it simply doesn't work. >>> >>>> I tried $Table Field$, "$Table Field$", '$Table Field$' and also >>>> >>> Table Field without the $$ None has helped. >>> >>>> Any idea/ help ? >>>> >>>> Thank you. >>>> >>>> Remedy Maniac. >>>> >>>> PS: I am runing ARS 6.01 on Sybase 12.5.3 >>>> >> __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"
