Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Alma

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Alma
    3. Knowledge Articles
    4. Using "OR" and "AND" operators together in advanced Alma searches

    Using "OR" and "AND" operators together in advanced Alma searches

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Description
    2. Resolution
    • Product: Alma

    Description
    Below is an explanation of the Boolean mathematics used in Alma's advanced searching, specifically when it comes to using the OR operator in conjunction with the AND operator.
     
    Resolution
    In Boolean mathematics:
    “AND” is Multiplication (*)
    “OR” is Plus (+)
    Each condition (row) in the advanced search returns ‘0’ or ‘1’ depending on non-match / match.
    Boolean mathematics rules:
    1 = true
    0 = false
    1 AND 1 = 1 * 1 = 1
    1 AND 0 = 1 * 0 = 0
    0 AND 0 = 0 * 0 = 0
    1 OR 1 = 1 + 1 = 1
    1 OR 0 = 1 + 0 = 1
    0 OR 0 = 0 + 0 = 0
    So, currently all consecutive ANDs are grouped together similar to the multiplication rule which is calculated before addition (plus sign) – example:
    If we would do the following in the advanced search:
    A AND B AND C OR D OR E OR F AND G AND H
    This is equivalent to:
    A* B * C + D + E + F * G * H
    And this will be calculated as:
    (A* B * C) + (D) + (E) + (F * G * H)
    This is how Alma advanced search logic works currently.
     
    If for example you wanted:
    A * B * ( C + D + E + F + … )
    This can be simplified to:
    ( A * B * C ) + ( A * B * D ) + ( A * B * E ) + ( A * B * F ) + ………….
    As follows:
    or operator.png
     

    • Article last edited: 01-June-2018
    ​
    ​
    View article in the Exlibris Knowledge Center
    1. Back to top
      • How much disk space is required for the AutoExtract process during Ex Libris System to Alma migration?
      • How to activate an Electronic Collection from the Community Zone?
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Content Type
      Documentation
      Language
      English
      Product
      Alma
    2. Tags
      This page has no tags.
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved