The top level class from which all classes are derived.
Table Specific Information
All columns support server-side processing for the following operators =, >= , <=, !=, LIKE, AND, and OR. Other filters are executed client side within the adapter. For example, the following query is processed by Generic LDAP:
SELECT * FROM Top WHERE CN != 'NewUser' AND BaseDN = 'CN=Users,DC=MyDC' LIMIT 5
To add a Top record, all fields can be specified except Id, DN, and BaseDN. Required fields that should be provided are RDN and ObjectClass. For example:
INSERT INTO Top (RDN, ObjectClass) VALUES ('CN=NewUser', 'top;person;organizationalPerson;user;inetOrgPerson')
All columns except Id, DN, and BaseDN can be updated by providing the Id in the WHERE clause. For example:
UPDATE Top SET Description = 'test' WHERE Id = '1|CN=NewUser,CN=Users,DC=MyDC'
Top records can be deleted by providing the Id of the Top record in a DELETE statement. For example:
DELETE FROM Top WHERE Id = '1|CN=NewUser,CN=Users,DC=MyDC'
Combined index and DN. Multiple indices are only possible when a column is set to SplitDataByRow.
The full distinguished name.
The relative distinguished name.
The base distinguished name.
The list of classes from which this class is derived.
This attribute contains the family or last name for a user.
The name that represents an object. Used to perform searches.
Contains a set of flags that define the type and scope of a group object.
The distinguished name of the groups to which this object belongs.
The attribute DC for the Domain object class.
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
Defines the LDAP filter explicitly, overriding any other values set in the WHERE clause.