Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Voyager

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Voyager
    3. Knowledge Articles
    4. Using Conditionals in Voyager Prepackaged Access Reports

    Using Conditionals in Voyager Prepackaged Access Reports

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Question
    2. Answer
      1. IIf() Function
    • Product: Voyager
    • Relevant for Installation Type: Multi-Tenant Direct, Dedicated-Direct, Local, TotalCare

     

    Question

    Provide some tips for using Conditionals in Voyager Prepackaged Access Reports. 

    Answer

    Sometimes you might want your results to vary, based on some criterion. This is called a "Conditional".

    In a programming language, a Conditional might look something like this:

    if (sun is up) then
        “day”;
    else
        “night”;

     

    IIf() Function

    The IIf() Function ("Immediate IF") allows for conditionals in Voyager Prepackaged Access Reports.

    Format:  IIf (expr, truepart, falsepart)

    If the expression, “expr” turns out to be true, the value of IIf is “truepart”. If the expression is not true, the value of IIf is “falsepart”.

    Example: PH: IIf([PATRON_PHONE].[PHONE_NUMBER] Is Null,"NO PHONE",[PATRON_PHONE].[PHONE_NUMBER])

    In the above call example, we want the phone number associated with each patron's permanent address.  A phone number is not required, however, so we use an outer join, then we use an IIf() function to put "NO PHONE" in the results if there is no phone number.

    clipboard_e7e943afb4032d61f89c88c6902072b01.png

     

    clipboard_e2ca6fa2bbd8350be6c24c4b5fdb1f36a.png

     

    Constructing custom SQL queries by request and troubleshooting unexpected results from customer-created SQL queries falls outside the scope of Support. The above has been posted for informational purposes.  Voyager-L and Developer Network are useful resources for finding helpful custom SQL or obtaining assistance from peers in troubleshooting custom queries.

     


    • Article last edited: 03-Mar-2021
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Using Access 2007 or 2010 with Reporter causes utility.mda file error
      • Using dates as criteria in Voyager Prepackaged Access Reports
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Content Type
      Knowledge Article
      Language
      English
      Product
      Voyager
    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