**
Hey everyone,

Assume that there are 50 records to me modified. Only 1 field needs to be modified in all the records. I want to append 'xyz' to the existing data in the field I want to modify.

Is there any way to do this via the ARUSER tool -> 'modify all' option?

I want to retain existing value in the field but want to append 'xyz' to the field in all records.

For ex: assume record # 1 has "John" in the field and record # 2 has "Mary" in the same field. I want to be able to modify both the records so that they contain 'xyzJohn' and 'xyzMary' in them.

Is this possible?

The form in question is the 'user' form and the field in question is the 'Login Name' field.

Thanks,
Steve
20060125This posting was submitted with HTML in it

**
Hi Steve

You can do this but needs to write a filter and create a display only field (say F2 ) on that form. So when you say modify all, Put your value in F2 , let your filter fire and append the your fileld with the value in field F2.

Suppost you want to append Summary Field with a string "Append My Summary", Create a filter on modify with Set field as

Summary : ($Summary$ + " ") + $F2$

Note: I have used a sigle space to separate my append string with single space. Do not use A/L. Active Link can not modify record in Bulk.

Regards

Abdul Ghani MF
Pune, India

----- Original Message -----
From: Steve
Newsgroups: public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
Sent: Friday, March 10, 2006 3:45 PM
Subject: "Modify All" in ARUSER

**
Hey everyone,

Assume that there are 50 records to me modified. Only 1 field needs to be modified in all the records. I want to append 'xyz' to the existing data in the field I want to modify.

Is there any way to do this via the ARUSER tool -> 'modify all' option?

I want to retain existing value in the field but want to append 'xyz' to the field in all records.

For ex: assume record # 1 has "John" in the field and record # 2 has "Mary" in the same field. I want to be able to modify both the records so that they contain 'xyzJohn' and 'xyzMary' in them.

Is this possible?

The form in question is the 'user' form and the field in question is the 'Login Name' field.

Thanks,
Steve
20060125This posting was submitted with HTML in it

20060125This posting was submitted with HTML in it

** It would be nice but no.

You can use Keywords like that: $DATE$, $USER$, $VUI$, $SERVER$, etc..
You can also blank out a field using $NULL$.


On 3/10/06, Steve wrote:

**
Hey everyone,

Assume that there are 50 records to me modified. Only 1 field needs to be modified in all the records. I want to append 'xyz' to the existing data in the field I want to modify.

Is there any way to do this via the ARUSER tool -> 'modify all' option?

I want to retain existing value in the field but want to append 'xyz' to the field in all records.

For ex: assume record # 1 has "John" in the field and record # 2 has "Mary" in the same field. I want to be able to modify both the records so that they contain 'xyzJohn' and 'xyzMary' in them.

Is this possible?

The form in question is the 'user' form and the field in question is the 'Login Name' field.

Thanks,

Steve
20060125This posting was submitted with HTML in it




--
Frank Caruso
Specific Integration, Inc.
Senior Remedy Engineer
www.specificintegration.com
703-879-6465 20060125This posting was submitted with HTML in it

I've always thought it was a little odd that filters, but not active links, are
executed in a modify all action; however, the SET ALL operation is not
available for filters.

So filters fire on modify all, but for all they know it's just another
run-of-the-mill SET operation.

--Tim


--- Amdul Ghani MF wrote:

> Hi Steve
>
> You can do this but needs to write a filter and create a display only field
> (say F2 ) on that form. So when you say modify all, Put your value in F2 ,
> let your filter fire and append the your fileld with the value in field F2.
>
> Suppost you want to append Summary Field with a string "Append My Summary",
> Create a filter on modify with Set field as
>
> Summary : ($Summary$ + " ") + $F2$
>
> Note: I have used a sigle space to separate my append string with single
> space. Do not use A/L. Active Link can not modify record in Bulk.
>
> Regards
>
> Abdul Ghani MF
> Pune, India
> ----- Original Message -----
> From: Steve
> Newsgroups: public.remedy.arsystem.general
> To: arslist@ARSLIST.ORG
> Sent: Friday, March 10, 2006 3:45 PM
> Subject: "Modify All" in ARUSER
>
>
> **
> Hey everyone,
>
> Assume that there are 50 records to me modified. Only 1 field needs to be
> modified in all the records. I want to append 'xyz' to the existing data in
> the field I want to modify.
>
> Is there any way to do this via the ARUSER tool -> 'modify all' option?
>
> I want to retain existing value in the field but want to append 'xyz' to
> the field in all records.
>
> For ex: assume record # 1 has "John" in the field and record # 2 has "Mary"
> in the same field. I want to be able to modify both the records so that they
> contain 'xyzJohn' and 'xyzMary' in them.
>
> Is this possible?
>
> The form in question is the 'user' form and the field in question is the
> 'Login Name' field.
>
> Thanks,
> Steve
> 20060125This posting was submitted with HTML in
> it
>
>

> UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org

If you are comfortable with SQL you could update the table directly.
Something like:

UPDATE Userx
SET LoginName = LoginName + 'xyz'
WHERE SomeField = 'Some Condition'


Stephen


-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Tim Widowfield
Sent: Friday, March 10, 2006 8:39 AM
To: arslist@ARSLIST.ORG
Subject: Re: "Modify All" in ARUSER

I've always thought it was a little odd that filters, but not active
links, are executed in a modify all action; however, the SET ALL
operation is not available for filters.

So filters fire on modify all, but for all they know it's just another
run-of-the-mill SET operation.

--Tim


--- Amdul Ghani MF wrote:

> Hi Steve
>
> You can do this but needs to write a filter and create a display only
> field (say F2 ) on that form. So when you say modify all, Put your
> value in F2 , let your filter fire and append the your fileld with the
value in field F2.
>
> Suppost you want to append Summary Field with a string "Append My
> Summary", Create a filter on modify with Set field as
>
> Summary : ($Summary$ + " ") + $F2$
>
> Note: I have used a sigle space to separate my append string with
> single space. Do not use A/L. Active Link can not modify record in
Bulk.
>
> Regards
>
> Abdul Ghani MF
> Pune, India
> ----- Original Message -----
> From: Steve
> Newsgroups: public.remedy.arsystem.general
> To: arslist@ARSLIST.ORG
> Sent: Friday, March 10, 2006 3:45 PM
> Subject: "Modify All" in ARUSER
>
>
> **
> Hey everyone,
>
> Assume that there are 50 records to me modified. Only 1 field needs
> to be modified in all the records. I want to append 'xyz' to the
> existing data in the field I want to modify.
>
> Is there any way to do this via the ARUSER tool -> 'modify all'
option?
>
> I want to retain existing value in the field but want to append
> 'xyz' to the field in all records.
>
> For ex: assume record # 1 has "John" in the field and record # 2 has
"Mary"
> in the same field. I want to be able to modify both the records so
> that they contain 'xyzJohn' and 'xyzMary' in them.
>
> Is this possible?
>
> The form in question is the 'user' form and the field in question is

> the 'Login Name' field.
>
> Thanks,
> Steve
> 20060125This posting was submitted with
> HTML in it
>
>


> UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org



UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org

The short answer is No not without building additional workflow or
performing the modifiy directly in the data from another tool.

1. you could write a oneshot escalation to modify the data base on qual
match. you could use a flag.

2. you could use a direct sql statement to modify the data

3. you can create a flag on the form and a filter to append the data
you could then modify all on the records you wanted to change and set the
flag

4. you can export the data field and the eid filed to a csv and edit the
records in Excel and re-import data doing a modify.

if you do not have access to any of these options you can do it by hand.


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org