Filter Not Working in P6 When Activity ID Contains Square Brackets ("[" and "]") Using a SQL Server Database

(Doc ID 2228289.1)

Last updated on JULY 13, 2017

Applies to:

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

Symptoms

ACTUAL BEHAVIOR
-------------
Filter not working when trying to apply Filter on Activity ID with brackets using a SQL Server database.

EXPECTED BEHAVIOR
-----------------------
The ability to apply Filter on Activity ID that has brackets.

STEPS
-----------------------
STEPS TO REPRODUCE:
1. Log into P6 Web and open a Project.
2. Go to the Activities View.
3. Create a Filter where 'Activity ID does not contain [Activityid]'.
4. Apply Filter.

Note: issue is only happening in SQL database.

Changes

 

Cause

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 hundreds of Community platforms