Re: help, help, help

Tue, 22 Aug 2006 08:52:49 -0700

**
First filter needs to take the store_id value and perform a Set Fields action to see if it exists on the form. Use a temp field during the set fields action to store any value from the form. If the store id is not found then set the temp value to NULL.

Second filter looks at the temp field and if is not NULL, meaning the store id was found, then pop the error message.




On 8/22/06, sara abate <[EMAIL PROTECTED]> wrote:
**
It is SQLdatabase, Windows and Remedy 5.1.2
 
I like the idea but I am confused(little high level to me)  about the filter with set field action.  I created a filter that excutes on submit with the following qualification:
Run if ( 'TR.store ID' = 'DB.store ID') then created a messege action that displays "the value exists...." but that is not blocking it at all.  Can you give me more details please?

Frank Caruso < [EMAIL PROTECTED]> wrote:
** 1. You could also do this with work flow to that you can provide a cleaner error message to your end users. Create a filter that does a set fields against the current form looking for the value entered. Set a temp field from the current form if the record is found, NULL if its not. A second filter can check the temp field and if it is not NULL then the value exists and pop up a message to your user.

2. Depends on the type of database. I know with Oracle you can create a SEQUENCE which will give you a new unique value.

On 8/22/06, Scott Ames <[EMAIL PROTECTED]> wrote:
** Wow you are quick on the draw. I was composing a similar message when yours came in. lol.


"Nall, Roger" < [EMAIL PROTECTED]> wrote:
**
Sara,
 
To enforce unique values in a field I would suggest a unique index. As to a 'Request ID' type field you may need some sort of a stored procedure for that.
 
HTH,
 
Roger A. Nall
OSSNMS Sr. Remedy Administrator/Developer
T-Mobile USA
Desk: 973-644-3963
Cell: 973-652-6723
FAX: 973-267-6628
sf49fanv     AIM IM
RogerNall   Yahoo IM
 
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of sara abate
Sent: Tuesday, August 22, 2006 10:46 AM
To: arslist@ARSLIST.ORG
Subject: help, help, help
 
** I am a new remedy developer and I need help on two of the following things,
  
  1.  I want a field to have unique value.  How can I restrict the
field from having duplicate values?  In other words, Is there any way I can block if the current value entered is already in the database?
   
  2.  I want to create an auto generated field.  Anytime a ticket is
submitted, the field should be populated automaticlly in increments.  In
other word, I want a 'Request ID' kind of field on the form.
  
  Anybody can help me with this please email me at [EMAIL PROTECTED]. 
I will appreciate it.
  Thanks!
  
  Sara
 
Do you Yahoo!?
Next-gen email? Have it all with the all-new Yahoo! Mail. __20060125_______________________This posting was submitted with HTML in it___
__20060125_______________________This posting was submitted with HTML in it___

__20060125_______________________This posting was submitted with HTML in it___



--
Frank Caruso
Specific Integration, Inc.
Senior Remedy Engineer
www.specificintegration.com
703-376-1249 __20060125_______________________This posting was submitted with HTML in it___



--
Frank Caruso
Specific Integration, Inc.
Senior Remedy Engineer
www.specificintegration.com
703-376-1249 __20060125_______________________This posting was submitted with HTML in it___

Reply via email to