OVD 11g: VirtualAttribute Plugin: No results Returned Searching on Virtual Attribute - Can Only Map Virtual Attribute to a Real Attribute (Doc ID 2053485.1)

Last updated on MARCH 06, 2023

Applies to:

Goal

Substring filtering on Oracle Virtual Directory (OVD) 11g virtual attributes that are constructed using more than one dynamic attributes return NO results.

Example of Virtual attribute plug-in configuration:

"Attribute0", is a URN type of ldap attribute. It is constructed using the virtualAttribute plugin in an adapter. The syntax of the attribute includes one static prefix, followed by the concatenation of three dynamic attributes, separated with a colon character ":".

The parameters used for the construction of the virtualAttributes are the following:

          <plugin>
              <name><plugin_name></name>
              <class>com.octetstring.vde.chain.plugins.virtualattr.VirtualAttributePlugin</class>
              <initParams>
                 <param name="MatchFilter" value="(&amp;(|(Attribute1=*)(Attribute2=*))(Attribute3=*))"/>
                 <param name="AddAttribute" value="Attribute0={urn:<value1>:<value2>:<constant1>:%Attribute1%:%Attribute2%:%Attribute3%}""/>
                 <param name="AddAttribute" value="objectClass=<objectclass1>"/>
              </initParams>
           </plugin>

Example search of the problem:

$ORACLE_HOME/bin/ldapsearch -h <OVD_HOSTNAME> -p <PORT> -D cn=orcladmin -q -b "uniqueIdentifier=<XXXX>,ou=People,dc=<COMPANY>,dc=com" -s sub '(Attribute0=*123)' dn
0 matches

However, entry is found when not using the attribute in the filter and it shows expected results:

Example:

$ORACLE_HOME/bin/ldapsearch -h <OVD_HOSTNAME> -p <PORT> -D cn=orcladmin -q -b "uniqueIdentifier=<XXXX>,ou=People,dc=<COMPANY>,dc=com" -s sub '(objectclass=*)' dn Attribute0
uniqueIdentifier=<XXX>,,ou=People,dc=<COMPANY>,dc=com
Attribute0=<VALUE FOR ATTRIBUTE:123>
 

Solution

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