Could your unique ID be the numerical portion of the Request ID? Dwayne Martin James Madison University
---- Original message ---- >Date: Tue, 22 Aug 2006 11:52:25 -0400 >From: Frank Caruso <[EMAIL PROTECTED]> >Subject: Re: help, help, help >To: [email protected] > > ** > 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:[EMAIL PROTECTED] > On Behalf Of sara abate > Sent: Tuesday, August 22, 2006 10:46 AM > To: [email protected] > 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___ > > ------------------------------------------------ > > How low will we go? Check out Yahoo! Messenger's > low PC-to-Phone call rates. > __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___ Dwayne Martin Computing Support James Madison University _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
