Re: Duplicate Records

[Robert Molenda]

Title: Duplicate Records

** Yes this works, but ensure you take into consideration that this will query the table with a match to that field, consider the QBE settings, and the total record count for the table.   When we do this, we don’t use a table query, we use direct sql which is better performance for high row count tables.   Select count(*) from <view> where <field> = ‘value’   Then compare the set-fields-returned-value != 0 then error   Thanks-n-advance; HDT Platform Incident / Problem Manager & Architect Robert Molenda IT OS PA Tel: +1 408 501 6310 Fax: +1 408 501 2410 Mobile: +1 408 472 8097 [EMAIL PROTECTED] Quality begins with your actions.   From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: Friday, October 13, 2006 6:30 AM To: arslist@ARSLIST.ORG Subject: Re: Duplicate Records   Sure ... You can do a simple Set Fields action to set a Display Only temp field as an indicator.  A second filter then checks the indicator to see if the value exists.   Example   Scenario:   Regular Remedy form called FormA with only default fields (plus a 15 char display only field called zTmpDupID).  You want to make sure users don't enter a short description twice.   Submit version     Filter 1 On Submit         Action 1:              Set fields Read value from FormA             Set Fields If:  'Short Description' = $Short Description$             No Requests Match Set to $NULL$             Any Requests Match Use First Matching         Set zTmpDupID = $Request ID$   Modify version     Filter 1 On Modify         Action 1:              Set fields Read value from FormA             Set Fields If:  'Short Description' = $Short Description$ and 'Request ID' != $Request ID$             No Requests Match Set to $NULL$             Any Requests Match Use First Matching         Set zTmpDupID = $Request ID$     Filter 2     If zTmpDupID != $NULL$ Show Error to prevent save     Hope this info helps Fred   From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sullivan, Neil G CTR USAF AFRL/SNOX Sent: Friday, October 13, 2006 8:08 AM To: arslist@ARSLIST.ORG Subject: Duplicate Records ** Listers, Is there any way possible to use workflow to check for duplicate records in a form without using a unique index?  I can't use an index because some of the values in the field will be null. Any help is appreciated. Neil "Sully" Sullivan Remedy Developer/Administrator AFRL/SNOX Wright Patterson AFB, OH 45433 937-904-9788     __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___