Person
Stores personal information about a user, including general details such as name and contact information.
Table Specific Information
Select
All columns support server-side processing for the operators =, >= , <=, !=, LIKE, AND, and OR. Other filters are executed client side within the 本製品. For example, the following query is processed by LDAP:
SELECT * FROM Person WHERE ObjectClass = 'top' AND CN LIKE '%NewUser%' LIMIT 5
Insert
To add a Person, all fields can be specified except Id, DN, and BaseDN. Required fields that should be provided are RDN and ObjectClass. For example:
INSERT INTO Person (RDN, ObjectClass) VALUES ('CN=Domain Admins', 'Person')
Update
All columns except Id, DN, and BaseDN can be updated by providing the Id in the WHERE clause. For example:
UPDATE Person SET Description = 'desc' WHERE Id = '1|CN=NewUser,CN=Users,DC=MyDC'
Delete
Person rows can be deleted by providing the Id of the Person in a DELETE statement. For example:
DELETE FROM Person WHERE Id = '1|CN=NewUser,CN=Users,DC=MyDC'
Columns
| Name | Type | ReadOnly | References | DataFormat | Description |
| Id [KEY] | String | True |
A combined index and Distinguished Name (DN). Multiple indices are supported if the column is set to 'SplitDataByRow'. | ||
| DN | String | True |
The full Distinguished Name (DN) representing the unique LDAP path of the object. | ||
| RDN | String | False |
The Relative Distinguished Name (RDN), which is the unique part of the DN within its parent container. | ||
| BaseDN | String | True |
The base Distinguished Name (BaseDN) that specifies the starting point for LDAP operations. | ||
| ObjectClass_1 | String | False | SplitDataByCol |
The primary object class from which this entry is derived, defining its core attributes and behavior. | |
| ObjectClass_2 | String | False | SplitDataByCol |
An additional object class from which this entry inherits attributes, defining extended behavior or properties. | |
| ObjectClass_3 | String | False | SplitDataByCol |
An optional object class specifying further attributes or extended functionality for the entry. | |
| ObjectClass_4 | String | False | SplitDataByCol |
An optional object class specifying additional attributes or properties for the entry. | |
| SN | String | False | DelimitedData |
Contains the user's surname or family name, such as 'Smith'. | |
| CN | String | False | DelimitedData |
Represents the common name of the object, often used in LDAP searches. For example, 'John Doe'. | |
| UserPassword | String | False | DelimitedData |
Stores the user's password in UTF-8 format. This is a write-only attribute and cannot be retrieved for security purposes. | |
| TelephoneNumber | String | False | DelimitedData |
The primary telephone number associated with the user or object. | |
| SeeAlso | String | False | SplitDataByRow |
A list of Distinguished Names (DNs) related to this object, establishing references to other LDAP entries. | |
| Description | String | False | DelimitedData |
Contains a textual description of the object. Typically single-valued but can be multi-valued depending on the LDAP schema. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| Filter | String |
Defines an explicit LDAP filter, overriding other filters defined in the WHERE clause of the query. |