I'm trying to modify a ticket via command line.
Here is my call on the command line: "C:\Program Files\AR System\RUNMACRO.EXE" -d "C:\Documents and Settings\All Users\Application Data\AR System\HOME\ARCmds" -e "TEST" -x "<Server>" -U "<User>" -P "<Password>" -p "Request"="CUST0000000 4854" = -p "Title"="Mr." I'm not even sure if the above is correct, but I'm trying to pass a parameter called 'Request' as part of the qualification on the macro, and then a parameter for 'Title' as the value that is being updated. So, it will look up 'Request' and modify 'Title.' So, I did some experimenting. A SUBMIT macro for this particular schema looks like the following: TEST Set-schema: <Schema><Server> Submit: <Schema><Server>|536871039=Mr.536870985=asdf536870938=1536870936=1536870 935=1536870934=1536870929=336-3211536870925=Bob536870918=Smith536870916= [EMAIL PROTECTED] end And a QUERY macro looks like the following: TEST Set-schema: <Schema><Server> Query: 1=CUST00000004854[1] Form-open: Form-entry-list: 0 Form-final: modify@ end So, I merged the two and came up with the below: TEST Set-schema: <Schema><Server> Query: 1=$Request$<Server>|536871039=$Title$ Form-final: modify@ End The hopes are that the above macro will pull up ticket number $Request$ (as passed in via the command line call above), and update 536871069 to 'Mr.' as passed via the command line call above). Unfortunately, this isn't working. Do you all have any tips on creating a macro that, when run via command line, does a query, then updates the resulting record(s)? I tried to just go into the user tool and record a query/modify action, but remedy won't commit to the DB, so it won't record the update in the macro either. It will, however, let you create a submit macro and create the proper commands in the macro file, just not submit to database. Any help is greatly appreciated! Thanks, Gary Opela, Jr Sr. Remedy Developer Leader Communications, Inc. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
