how to remove duplicate entries

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

CRITICAL:Link not working to directly opening the create ticket page

Hello List, We have provided a link for opening a view of Remedy form direct URL. But some users at Europe/Crolles are not been able to open the link and its giving following error. URL:

Re: CRITICAL:Link not working to directly opening the create ticket page

Manish - we have been seeing this problem. We think it MAY be related to the Load Balancer we use. This Load Balancer is setup to cache certain files requested by users. The problem, Remedy support suggests, may be the Wrong version of the file ClientCore.js is being cached. There are two

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

ARS 7.1 Localisation Notification messages

Hi all! I have installed BMC Remedy ARS 7.1 Russian version(ARS Server, Email Engine, Incident Managment) And have next trouble: All form, menus, etc. displayed in Russian language - ok But all notifications(Incident assignment for example) i receive at English Language. SYS:Notification

Re: ARS 7.1 Localisation Notification messages

Hi Aleksy Have you set the Server to localized? Open the Administration Console in the User Tool, go to System...General..Server Information. Change to the Advanced tab and make sure the Localize Server checkbox is checked. The messages shown should then be determined by the locale of your

Re: how to remove duplicate entries

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

Re: how to remove duplicate entries

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

HPD:IncidentInterface_Create

Hello All, I want to use the HPD:IncidentInterface_Create form to create an incident. The only way I can figure out to do this is to send each user the .arm template and have them copy/paste that into an email each time they wish to create an incident. I have two issues: First, it's extremely ugly

Question Regarding HPD:IncidentInterface_Create in V 7

Hello All, I want to use the HPD:IncidentInterface_Create form to create an incident. The only way I can figure out to do this is to send each user the .arm template and have them copy/paste that into an email each time they wish to create an incident. I have two issues: First, it's extremely ugly

Re: mid-tier logs- ARERR 623

Check your config.properties file and make sure there is a preference server listed? From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Moore, Chris Sent: Friday, January 18, 2008 3:22 PM To: arslist@ARSLIST.ORG Subject:

Re: ARS 7.1 Localisation Notification messages

Hi David! ty for quick answer. I find my Error, i don't set Notification Language at Russian in CTM:People form for users. Now all ok. ty all David Sanders wrote: Hi Aleksy Have you set the Server to localized? Open the Administration Console in the User Tool, go to

Assigned solution ticket 7.1

Hey everyone- I've been reading through the manuals but can't find an answer to this. In 7.1 when you create a solution a ticket is created and assigned to an individual. It shows up in their queue of tickets to work on. What are they supposed to do with it? I can't find any way to

Escalated field in Incident - ITSM 7

We've noticed there is a dropdown field named Escalated on the HPD:Help Desk form in ITSM 7 but it is always disabled. Does anybody know what events cause this field to become enabled? Thanks! Mike Pugh Software Engineer AMERICAN SYSTEMS 13990 Parkeast Circle Chantilly, VA 20151

Re: HPD:IncidentInterface_Create

Wondering -- is the goal to create an incident or is the goal to create an incident via email? Plus -- will there be some back and forth -- or will the original form be filled out perfectly (kidding). If the goal is to easily create an incident without using Windows User Tool - or the MidTier --

Re: Assigned solution ticket 7.1

The Status and View Access fields control the availability of a solution. It's usually the Problem Manager who validates and categorizes the solutions and then make the status Available. They can also determine the View Access to be Public or Internal to control who can use the available

View Form upper/lower case question

Hello everyone, I have some data in an external db that is all upper case. Would there be a way to display that data in a View form as lower case? I'm actually federating data where I have one View form that holds a few table fields that also come from view forms. The first table's data is

Re: Appending headers to outgoing email messages

Sorry, I guess I should have followed the chain farther back. I see now that you are on 5.1.2. I'm using 6.3 (ARS and email engine) for this process. Thad Esser Remedy Developer Argue for your limitations, and sure enough, they're yours.-- Richard Bach L G Robinson [EMAIL PROTECTED] Sent

Re: View Form upper/lower case question

HI Drew, You can create a view (with in oracle) of the table\view using an SQL statement. In SQL you have the UPPER\LOWER functions with that you can manipulate the data. Use the new view (with in oracle) to create the remedy view form, this way you will use the SQL functions to get what you

Re: View Form upper/lower case question

VB, thanks for that. There would be more than one workaround; I asked the Informatica people to perform the LOWER function so the data will load into the oracle table that way. Drew On Mon, 21 Jan 2008, Viswanathan Balakumar wrote: HI Drew, You can create a view (with in oracle) of the

Re: Assigned solution ticket 7.1

Thanks- I was looking in the Incident docs. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Lisa Westerfield Sent: Monday, January 21, 2008 12:37 PM To: arslist@ARSLIST.ORG Subject: Re: Assigned solution ticket 7.1

Display Order in Application Field

Hey all. I'm trying to change the order of items shown in the application field in the home page in 7.1. I went into each application entry point and changed the display numbers but they would not move- is there something else that I need to change? Also, I would like to change the wording

EIE Very Slow

Actually, it may not be all that slow, but it's not pulling in very many records. The logs says that the Data Exchange starts and stops about 7 seconds later, pulling only 8 records. Then it starts again 5 minutes later. The external db/table is not really external at all; it's a table

CMDB 1.1- BMC_Dependency Relation Class Attribute Modification Problem

* AR Server 6.3 patch 023 ITSM 6.0 Package CMDB 1.1 patch 05 OS: Windows 2003 Server DB : MS SQL 2000 Server We have a problem when modify attribute permission in BMC_Dependency Relation Class. We've tried to change DeleteInstanceTrigger attribute change permission to APP-Support Group.

Run Process in AL to execute a Perl script - Help!

Hi all, I'm trying to run a Perl script from an Active link. I'm firing the AL on a CTI match. The Run Process action looks like this: $PROCESS$ @@:/usr/local/lib/perl5/site_perl/5.8.7/Custom/alert.pl No matter what I do, Remedy is giving me the following error: The system cannot find the file