Hi Bala,
Many years ago I had to set DSO up to distribute to one or more servers. The list was variable but was defined by the group a case was assigned to. I added a field to the help desk form to hold the servers that the DSO transfer needed to be sent to. This field was completed by the selection of an assigned group and checking which server was their primary server. If the server concerned wasn’t already specified in the field it was added. Then filters firing the specific DSO action for each server would check this field. If the server existed in the list the filter would fire. The field was pushed to all servers to facilitate the return of updates. This was all done as independent copies. This only left the issue of locking down the records. So when the workflow retrieved the primary server for the currently assigned group, it was also placed in its own field and was used to activate active link workflow to stop updating of the record on the wrong server. Today you could do something similar with Assigned Group as well. A method like this can all be done without requiring a table. Your table query defining the servers you need to do a DSO transfer to, could be used to complete the field instead. And as it is driving workflow it doesn’t need to be full server names. It just needs to be a code that tells you it is server A as opposed to server B. Brian Bishop Goldstag Consultants Ltd tel: +44 (0)7973 746832 <http://www.linkedin.com/in/brianpbishop> Linkedin From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Bala Patel Sent: 15 May 2009 18:57 To: arslist@ARSLIST.ORG Subject: Re: Filter Table Looping - Phase Issue ** All, I had a question about Filter table looping and phases. I am creating a table field on a form that will be used to DSO tickets to each selected server that has been added into the tables form. When I save the ticket, the table field should be looped through. A distributed transfer should be performed for each server that is in the loop. The issue I am having is that I have to add the `! to the end of the filter which makes everything happen during Phase I. The Distributed Transfer fails since it is happening in phase I. The DSO transfer should happen during a later phase and not phase I. If I take the `! off the filter, then the filter loops and uses only the first record value for each record in the table field. Does anyone know of another method to do this or a way around this? ARS 7.1 Custom applications SQL 2005 Windows 2003 Server Thanks very much. Bala _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.329 / Virus Database: 270.12.31/2116 - Release Date: 05/15/09 06:16:00 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
<<image001.gif>>