Home › Discussions › Questions & Answers › Syntax for Defining Ranges and Exclusions in LOV Filters

Syntax for Defining Ranges and Exclusions in LOV Filters

Avatar photoCustomer January 14, 2020 at 9:05 am

When entering multiple values or filtering segment values, what character is used to define a range?

Viewing 6 reply threads
  • Author
    Replies
    • Support January 15, 2020 at 5:31 pm  

      A Range of values is defined using a hyphen (-), such as ‘4/11/2025-4/20/2025’ for dates or ‘1110-1150’ for segments.

    • Avatar photoCustomer January 17, 2020 at 8:23 pm  

      And what syntax is used to define an exclusion?

    • Support January 18, 2020 at 12:02 pm  

      An Exclusion is defined by prefixing the value or range with a tilde (~), for example, ‘~4/14/2025’ or ‘~1110-1120’.

    • Avatar photoCustomer January 19, 2020 at 10:34 am  

      If I manually type multiple non-range values into the Excel cell, how must they be separated?

    • Support January 19, 2020 at 8:04 pm  

      Multiple values entered directly into the cell should be separated by semicolons (;).

    • Avatar photoCustomer January 21, 2020 at 10:30 pm  

      Can I mix inclusions and exclusions in a single cell?

    • Support January 23, 2020 at 10:01 pm  

      Yes, you can mix formats, for example: ‘1110-1150;1210;~1111;~1120-1130’.

  • Author
    Replies
Viewing 6 reply threads
  • You must be logged in to reply to this post.

Login with:
Popular Posts
How to track master data changes using Oracle EBS Audit function and Blitz Report™ 123737

Oracle Enterprise Command Center Framework Release 12.2 installation and integration with Oracle EBS 12.2.8 19778

Oracle Discoverer replacement – importing worksheets into Blitz Report™ 14607

How to check if a patch is applied in Oracle EBS 12.2 14378

Oracle Discoverer 11.1.1.7 installation and integration with Oracle EBS R12.1.3 14066

Oracle E-Business Suite 12.2.8 upgrade to version 12.2.9 11961

Oracle E-Business Suite 12.2.7 upgrade to version 12.2.8 9896

Migration to Java Web Start in Oracle EBS 12.2 instance 9886

Securing sensitive data with Oracle VPD 7790

EBS 12.1.3 BI Publisher Excel templates generate XLS instead of XLSX and limit row number to 65,536 6444

Blog Archive
2026
2025
2024
2023
2022
2021
2020
2019
2018
2017
Recent Events
2026
2025
2024
2023
2022
2021
2020
2019
2018