my fault: I said "entries" but actually this is not correct.
I already have in the workflow one AL-table-loop and one
filter-table-loop on two different tables for my form A.
And I read logins from another form B. These are read in the table fields.
At the end of my 2 table-loop I have a field which displays logins on my
form A.
Sometimes I have 2 times the same login. This is because one login could
be checked two times. So it is a normal result at the end.
But still I would like to remove duplicates at the very end of my
workflow ... before I send emails out ... :D
Sorry for the confusion.
Remedy.maniac
Heider, Stephen wrote:
serouche,
If you know SQL you could write a stored procedure that would identify
the duplicates and then update a separate field on the form (ie. Set an
Optional Checkbox field to 0). Followed by a filter that would delete
each of the records which have a value in this checkbox field.
If you need users to be able to run this at anytime trigger it from an
Active Link.
HTH
Stephen
Remedy Skilled Professional
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Misi Mladoniczky
Sent: Monday, January 21, 2008 6:28 AM
To: [email protected]
Subject: Re: how to remove duplicate entries
Hi,
You could create a table-field that sorts its content on the field(s)
you
want to remove duplicates from. Also include the request-id in one
column.
Table Field with Columns:
- TblColValue
- TblColReqID
Create a display-only-temp-fields:
- TempPrevValue
Then you create Active Links for a table-loop-guide:
AL 1:
Run If: $TblColValue$ = $TempPrevValue$
Action Run Process: @@:Application-Delete-Entry "Form" "$TblColReqID$"
AL 2:
Run If:
Action Set Fields: TempPrevValue = $TblColValue$
Create the Guide and add the above Active Links:
Create an Active Link that calls the guide with Table Loop activated.
Best Regards - Misi, RRR AB, http://www.rrr.se
Products from RRR Scandinavia:
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy
logs.
* RRR|Translator - Manage and automate your language translations.
Find these products, and many free tools and utilities, at
http://rrr.se.
dear all,
I would like to clean-up duplicate entries in a character field.
I must use AL on the web.
How can I do this?
Through filters I would do something like "RUN PROCESS echo "MYFIELD"
|
sort | uniq" and that will do but through AL on the web I don't see.
Please help.
Thank you.
serouche
/"because there is always a remedy to help you"/
________________________________________________________________________
_______
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
--
This message was scanned by ESVA and is believed to be clean.
________________________________________________________________________
_______
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"
