Thanks Dylan and Carey. I've done things like this with SQL and I've never done any sort of table looping so I thought maybe I'd try the approach I was familiar with. Sounds like table looping is a better approach anyway because of the ability to select the records you want from the results set. I'll try it out. Again, I appreciate the help
Michael A. McManus, SSgt, USAF Remedy Developer HQ 754 ELSG/DOMH DSN: 596-6478 / Comm: 334-416-6478 -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black Sent: Wednesday, September 26, 2007 2:52 PM To: [email protected] Subject: Re: Creation of mlutiple records Michael, I rarely say never... but... I would never choose (ok there is my wiggle room :)) to create ARS form data via a direct SQL action when I could have used a table field looping process to do the job. P.S. If you do not want to give the users another UI... then just hide that table field and blindly build the rows for the user. It might leave the UI in a "busy" state for longer than the user might like if the set of rows is large enough, but it takes time to do anything once. Which means it should then take approximately N x "time to do it once" time to do it N times. :) However, could it be done... sure.. there are just more steps in it than I care to do. (not to mention that this kind of process is totally unsupported by BMC.) -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap.... Pick two. On 9/26/07, McManus Michael A SSgt HQ 754 ELSG/DOMH <[EMAIL PROTECTED]> wrote: > Thanks Carey, > Would something like this work? I was thinking of maybe using Direct > SQL to do a Select and then an Insert. One of the questions he asked was > could we allow the users to select like a division as well as a state or a > state and a center. I figured if I set a flag on each field to make sure > there was a value there, and then run Direct SQL to select the corresponding > records and do the insert, I could give them what I'm pretty sure is exactly > they want. The only thing I'm not sure of is making sure I get the Change > Request ID as well as the results set from the Bill Area form. Is this > overly complicated or would something like this work too? > > Thanks, > > Michael A. McManus, SSgt, USAF > Remedy Developer > HQ 754 ELSG/DOMH > DSN: 596-6478 / Comm: 334-416-6478 > > -----Original Message----- > From: Action Request System discussion list(ARSList) [mailto:[EMAIL > PROTECTED] On Behalf Of Carey Matthew Black > Sent: Wednesday, September 26, 2007 9:29 AM > To: [email protected] > Subject: Re: Creation of mlutiple records > > Michael, > > Just my two cents.... > > I would give the users a but that says... "add multiple billing areas > from this state" and have it open another dialog. That dialog would > have a table field and the user would be able to "Select all" or > select a sub set of the records in the table field. Then a button that > says "Create records for selected Billing Areas" that loops over the > selected records in the table and closes the dialog. > > That allows the user to see that there are really 1500 Billing Areas > in that State before you go off and create 1500 records. But it still > allows them to do just that when it is really needed too. It also > gives you a shot at telling the user things like... "You selected more > than 50... are you really sure? (Note this will take a while so be > patient after you say 'Yes'.)" > > > But in general table looping is the way I would go with such an activity. > > HTH. > > -- > Carey Matthew Black > Remedy Skilled Professional (RSP) > ARS = Action Request System(Remedy) > > Love, then teach > Solution = People + Process + Tools > Fast, Accurate, Cheap.... Pick two. > > > On 9/26/07, McManus Michael A SSgt HQ 754 ELSG/DOMH > <[EMAIL PROTECTED]> wrote: > > ** > > Listers, > > > > I have a requirement to allow users to add multiple billing > > areas to a change request. Currently, they click a button called Add > > Billing Area, which opens a dialog called Change Bill Area. The user > > selects a billing area id from a character field with a menu attached which > > fires a push fields that creates a record in the Change Bill Area form. > > I've added the ability for the user to select via billing area name, state, > > center and division in addition to ID but what I'd like to do, is allow > > users to select a state (or division, etc.) from that drop down, and then > > create a request for every billing area in that state. I'm sure I'll need > > to loop through that results set somehow, but I'm unfamiliar with that type > > of workflow in Remedy. Any help is greatly appreciated. > > > > > > > > ARS 6.3, SQL 2K, and Server 2000 > > > > > > > > Thanks much, > > > > > > > > Michael A. McManus, SSgt, USAF > > > > Remedy Developer > > > > HQ 754 ELSG/DOMH > > > > DSN: 596-6478 / Comm: 334-416-6478 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
