Login / Register  search  syndication  about

          Infor CRM 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
   Infor CRM (Formerly Saleslogix) Iterating through all tabs on a Page
 Using the TabWorskpace you can iterate through all the tabs on a page and do something with them, l
Posted on Jun 19, 2015 by Kris Halsrud to Kris Halsrud's Blog
 
   Infor CRM (formerly SalesLogix) Administrator Locked Out
I thought I had seen all the issues affecting the datalink but this was a new one. We could not login t
Posted on Jun 18, 2015 by Mark Duthoy to SalesLogix Support
 
   Infor CRM (Formerly Saleslogix) Hiding Tabs at Runtime Without Using Modules
 As Ryan wrote a long time ago, you can create a module and add it to a page in the Infor CRM web cl
Posted on Jun 10, 2015 by Kris Halsrud to Kris Halsrud's Blog
 
   How I assign ownership to a group of Leads in Infor CRM?
There is a tool within Infor CRM to align Accounts to different Account Owners. It is called Territory Re
Posted on Jun 05, 2015 by Dale Richter to Infor CRM Questions & Answers
 
   Infor CRM (Formerly Saleslogix) Adding a Client Side Confirmation on a Dependency Lookup in the Web Client
 We recently had a client who wanted to have a user confirmation prompt before a user was allowed to
Posted on May 28, 2015 by Kris Halsrud to Kris Halsrud's Blog
 
Comments

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