Login / Register  search  syndication  about

          Kris Halsrud's Blog

Kris Halsrud on development and Integration with CRM and Development

Using IRepository and ICriteria when you have 3 Or conditions

 

I recently ran into a case where I had to query an Entity in SalesLogix to find records where a user was in any one of three fields.  ICriteria has an Or operand but that is for comparing only two fields.  So how do you do three?  With Disjunction.  Here is an example:

Sage.Platform.RepositoryHelper<Sage.Entity.Interfaces.IAccount> repository =
Sage.Platform.EntityFactory.GetRepositoryHelper<Sage.Entity.Interfaces.IAccount>();
Sage.Platform.Repository.ICriteria criteria = repository.CreateCriteria();
criteria.Add(repository.EF.Disjunction()
    .Add(repository.EF.Eq("CreateUser", CurrentEntity.Id.ToString()))
    .Add(repository.EF.Eq("ModifyUser", CurrentEntity.Id.ToString()))
    .Add(repository.EF.Eq("AccountManagerId", CurrentEntity.Id.ToString())));
System.Collections.Generic.IList<Sage.Entity.Interfaces.IAccount> accounts = criteria.List<Sage.Entity.Interfaces.IAccount>();

What's This?
  
Bookmark and Share

About Kris Halsrud

   Kris Halsrud is a Senior Analyst / Developer for Customer FX Corporation.


Related Content
   I receive an error when I try to run the SalesLogix sysdbafix_script.
I receive an error when I try to run the SalesLogix sysdbafix_script. I have: * Windows Serve
Posted on Jun 05, 2013 by SalesLogix Support to SalesLogix Questions & Answers
 
   Web Core Update 03 Now Available for v8
This is an important update that includes several new features as well as addressing multiple defects.&nb
Posted on Jun 05, 2013 by Scott Weber to SalesLogix Product Blog
 
   Can I add Services as Products in SalesLogix?
Can anyone recommend a way to add Services as Products? We are a services based business and our quot
Posted on Jun 04, 2013 by SalesLogix Support to SalesLogix Questions & Answers
 
   Is there an issue with the SalesLogix Web Administrator version 8.0 in regards to adding users to Team Membership?
Question: In my database, it appears two users belonging to the same teams, have access to a different am
Posted on May 22, 2013 by SalesLogix Support to SalesLogix Questions & Answers
 
   FREE Open Source Add-ons for SalesLogix version 8 web
SalesLogix is developing a number of FREE add-on solutions for SalesLogix version 8 web. Some of the
Posted on May 22, 2013 by Scott Weber to SalesLogix Product Blog
 
Comments

No Comments

Leave a Comment

(required)  
(optional)
(required)  
Add
All contents Copyright © 2013 Customer FX Corporation
Customer FX Corporation
2324 University Avenue West, Suite 115
Saint Paul, Minnesota 55114
Tel: 800.728.5783

  Follow @CustomerFX on twitter
Follow the best news, tips, and articles
  Subscribe to Customer FX on youtube
Watch SalesLogix tutorial videos from Customer FX
Login / Register