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:


Id”, account.Id.ToString()));


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()));

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:


IJunction junction;

if (weWantToAndThisExpression)
junction = ef.Conjunction(); // AND

junction = ef.Disjunction(); // OR

.Add(ef.Eq(“Account”, account))
.Add(ef.Eq(“IsPrimary”, true)))

You can try something like this:

criteria.Add(ef.Eq(“Account.Id”, account.Id.ToString()));


Submit a Comment

Your email address will not be published. Required fields are marked *

Subscribe To Our Newsletter

Join our mailing list to receive the latest Infor CRM (Saleslogix) news and product updates!

You have Successfully Subscribed!