If the Query "{FieldName} is not <empty>" Query Condition is set in Archiver, it does not work as expected when using Oracle RDBMS as the Repository DB

(Doc ID 1680891.1)

Last updated on AUGUST 21, 2017

Applies to:

Oracle WebCenter Content - Version to [Release 11g to 12c]
Information in this document applies to any platform.


If set "{Text type field} is not <empty>" Export Query condition in Archiver it does not work well when using Oracle RDBMS as repository DB. 
The export query never gets any content even if content meeting the conditions exists in the content server. 

Note: This issue does not occur when using Is condition (setting "{Field} is <empty>").


launch Content Server which uses Oracle Database for repository.

create a custom "Text" type metadata field, named "CustomTextField01"
(column name = xCustomTextField01)

check-in 3 contents with following value in CustomTextField01
- ContentNULL ... CustomTextField01 = <null> (leave the field empty)
- ContentDONE ... CustomTextField01 = "done"
- ContentYET ... CustomTextField01 = "yet"

launch Archiver

choose [Edit]->[Add] and add an archive

In the archive added in step 4, open "Export Data" tab

click [Edit] to launch "Edit Export Query" window

In Query Definition form in "Edit Export Query" window, click
[Add] with following values:
- Field: CustomTextField01
- Operator: Is Not
- Value: <null> (leave the field empty)
Now you see following queries in each section, click [OK]
- "CustomTextField01 is not <empty>" in "Query Expression" section
- "(xCustomTextField01 <> '' AND xCustomTextField01 IS NOT NULL)"
in "Custom Query Expression" section

click [Preview]
--> No content items hit. We expect "ContentDONE" and
"ContentYET" are listed here since these items have non-null
value in CustomTextField01

Export the archive
--> No content items exported. We expect "ContentDONE" and
"ContentYET" are exported.



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