My Oracle Support Banner

When Using an Underscore (_) Within Filter Criteria, No Results Are Returned and the Criteria Changes to (\_) (Doc ID 2278752.1)

Last updated on AUGUST 18, 2017

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version and later
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version and later
Primavera P6 Professional Project Management - Version and later
Information in this document applies to any platform.


When the filter criteria is set as follows:

user_text1 contains _

There are no results and the filter changes to \_

For the filter to return results and not be changed.


  1. Log into P6 Web
  2. Open a Project and navigate to Activities (Classic View)
  3. Add UDF user_text1 as a column
  4. Populate the value as test_2017
  5. Add filter for user_text1 Contains _
  6. Run filter, no results.
  7. Modify filter and it now looks like user_text1 Contains \_


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.