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 08, 2017

Applies to:

Oracle Virtual Directory - Version 11.1.1.9.0 and later
Information in this document applies to any platform.

Goal

Substring filtering on virtual attributes that are constructed using more than one dynamic attributes return NO results.

Example of Virtual attribute configuration:

"schGrAcEnrollment", 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:
param name="MatchFilter" value="(&(|(enrollmentTerm=*)(attendanceType=*))(departmentID=*))"
param name="AddAttribute" value="schGrAcEnrollment={urn:mace:gunet.gr:schgrac:enrollment:gr:uoi.gr:%enrollmentTerm%:%attendanceType%:%departmentID%}"

 

Example search of the problem:

$ORACLE_HOME/bin/ldapsearch -h OVDhost1.us.oracle.com -p 6501 -D cn=orcladmin -b "uniqueIdentifier=0249/10254,ou=People,dc=us,dc=oracle,dc=com" -s sub -q '(schGrAcEnrollment=*249)' dn
0 matches

 

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

Example:

 $ORACLE_HOME/bin/ldapsearch -h OVDhost1.us.oracle.com -p 6501 -D cn=orcladmin -b "uniqueIdentifier=0249/10254,ou=People,dc=us,dc=oracle,dc=com" -s sub -q '(objectclass=*)' dn schGrAcEnrollment
uniqueIdentifier=0249/10254,ou=People,dc=us,dc=oracle,dc=com
schGrAcEnrollment=urn:mace:gunet.gr:schgrac:enrollment:gr:uoi.gr:12::249
 

Solution

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