Login / Register  search  syndication  about

          SalesLogix Questions & Answers

Your place to get answers to your SalesLogix related questions.

 Home  |   Subscribe via RSS  |   Subscribe via E-mail  |   

Adding an "Or" Statement in SalesLogix

Question: I'm attempting to create filters that will show certain types of contacts under the Contacts tab of an Account in SalesLogix.

I created a tab that only listed Contact type = Patient:

criteria.Add(ef.Eq("Account.

Id", account.Id.ToString()));
criteria.Add(ef.Eq("Type","Patient"));

I created a second tab, in an attempt to show all contacts that do not have the type Patient, if the Contact type is listed as Null it will not be shown:

criteria.Add(ef.Eq("Account.Id", account.Id.ToString()));
criteria.Add(ef.Ne("Type","Patient"));

I added: criteria.Add(ef.Disjunction().Add(ef.IsNull("Type")));

This only returns a blank list.  How do I add an "or" statement?
 
Answer:  If you call iCriteria.Add(lExpression) successively it will combine all expressions with the AND junction, this is by default.

To combine a number of expressions with "or", use the IJunction interface:

Sage.Platform.Repository.
IJunction junction;

if (weWantToAndThisExpression)
{
junction = ef.Conjunction(); // AND
}
else
{
junction = ef.Disjunction(); // OR
}

ICriteria.Add(junction
.Add(ef.Eq("Account", account))
.Add(ef.Eq("IsPrimary", true)))
.List();

You can try something like this:

criteria.Add(ef.Eq("Account.Id", account.Id.ToString()));
 
What's This?
  
Bookmark and Share

About SalesLogix Support

   Your SalesLogix Business Partner for SalesLogix Support.


Related Content
   Saleslogix (now Infor CRM) Web Client- Changing Label Appearances on Quick Forms
 I wrote previously about setting a label's appearance on a quick form using server side code.&n
Posted on Oct 02, 2014 by Kris Halsrud to Kris Halsrud's Blog
 
   Error Attempting to Save an Entity: "E_FAIL(0x80004005)" in the Infor CRM (Saleslogix) Web Client
We recently had a client that was running into an issue when attempting to create one particular entity i
Posted on Sep 30, 2014 by Kris Halsrud to Kris Halsrud's Blog
 
   Video: Demystifying Infor CRM (Saleslogix) Updates
Watch it now! If you missed yesterdays demo, "Demystifying Infor CRM (Saleslogix) Updates" ,
Posted on Sep 26, 2014 by Brianna Ojard to The Inbox
 
   Thoughts on the Future and Involvement in the Saleslogix/Infor CRM Community
Over the last year and a half I've been working on another product named Contatta. It's a great p
Posted on Sep 25, 2014 by Ryan Farley to Ryan Farley's Blog
 
   Fixing the Orphaning of Salesfusion Data when Converting Leads to Contacts in Infor CRM (Saleslogix)
We have had a couple of client recently come to other with the same problem-When you convert a Lead to a
Posted on Sep 19, 2014 by Kris Halsrud to Kris Halsrud's Blog
 
Comments

No Comments
All contents Copyright © 2014 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