DevForce Community Forum : Duplicate Records http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : Duplicate Records Mon, 13 Apr 2026 03:49:06 -700 Thu, 28 Jun 2012 12:23:17 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=3509 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Duplicate Records : Hi Von,You could create the... http://www.ideablade.com/forum/forum_posts.asp?TID=3509&PID=13930#13930 Author: sbelini
Subject: 3509
Posted: 28-Jun-2012 at 12:23pm

Hi Von,
 
You could create the query dynamically (http://drc.ideablade.com/xwiki/bin/view/Documentation/dynamic-query-create) in your custom verifier.
 
Regards,
   Silvio.
]]> Thu, 28 Jun 2012 12:23:17 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3509&PID=13930#13930 Duplicate Records : Hi,Thanks for the info..Is there... http://www.ideablade.com/forum/forum_posts.asp?TID=3509&PID=13925#13925 Author: Vonzkie
Subject: 3509
Posted: 28-Jun-2012 at 2:19am

Hi,

Thanks for the info..
Is there a generic way of doing this? It seems that in every entity type that I want to perform such validations, I will create something like this? Is there some centralize solution?

Regards,
Von
]]> Thu, 28 Jun 2012 02:19:35 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3509&PID=13925#13925 Duplicate Records : Von,You will need to query... http://www.ideablade.com/forum/forum_posts.asp?TID=3509&PID=13922#13922 Author: sbelini
Subject: 3509
Posted: 27-Jun-2012 at 8:44am

Von,
 
You will need to query the database to ensure the value is unique. Try the followinging:
 
protected verride VerifierResult VerifyValue(object itemToVerify, object valueToVerify, TriggerContext triggerContext, VerifierContext verifierContext) {
  var mgr = new EntityManager();
  var value = (string)valueToVerify;
  var isUnique = !mgr.GetQuery<myEntityType>().Any(e => e.myProperty == value);
  return new VerifierResult(!isUnique );
}
 
Note that the above is for a synch environment.
Also, you might want to take a look in the DRC for more details in creating a custom verifier.
 
Regards,
   Silvio.


Edited by sbelini - 27-Jun-2012 at 8:46am]]> Wed, 27 Jun 2012 08:44:04 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3509&PID=13922#13922 Duplicate Records : Hi,Do you have a standard way... http://www.ideablade.com/forum/forum_posts.asp?TID=3509&PID=13918#13918 Author: Vonzkie
Subject: 3509
Posted: 27-Jun-2012 at 1:37am

Hi,

Do you have a standard way of validating duplicate records based on some unique fields?

Thanks,
Von
]]> Wed, 27 Jun 2012 01:37:29 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3509&PID=13918#13918