# ValueListAdmin

Location: [gRPC API](https://developer.m-files.com/APIs/gRPC-API/index.md) > [Reference](https://developer.m-files.com/APIs/gRPC-API/Reference/index.md) > [Messages](https://developer.m-files.com/APIs/gRPC-API/Reference/Messages/index.md)

HTML version: https://developer.m-files.com/APIs/gRPC-API/Reference/Messages/MFiles.ValueListAdmin/

Object type.

- **Full name:** `MFiles.ValueListAdmin`
- **Proto file:** [`mfiles/structs.proto`](https://developer.m-files.com/APIs/gRPC-API/downloads/proto/mfiles/structs.proto)

<a id="fields"></a>

## Fields

| Field | Type | Number | Description |
|---|---|---|---|
| <a id="f-object_type"></a>`object_type` | [`ValueList`](https://developer.m-files.com/APIs/gRPC-API/Reference/Messages/MFiles.ValueList/index.md) | 1 | Basic data. |
| <a id="f-database_connection_string"></a>`database_connection_string` | `string` | 2 | OLE DB connection string to the external database that contains the objects (and their properties) of this object type. |
| <a id="f-database_select_all_statement"></a>`database_select_all_statement` | `string` | 3 | SQL statement that retrieves the objects from an external database. |
| <a id="f-database_select_one_statement"></a>`database_select_one_statement` | `string` | 4 | SQL statement that retrieves a specific object from an external database. |
| <a id="f-database_insert_statement"></a>`database_insert_statement` | `string` | 5 | SQL statement that inserts a new object to an external database. |
| <a id="f-database_select_latest_id_statement"></a>`database_select_latest_id_statement` | `string` | 6 | SQL statement that retrieves the ID of the just inserted record in the external database. |
| <a id="f-database_update_statement"></a>`database_update_statement` | `string` | 7 | SQL statement that updates an existing object in an external database. |
| <a id="f-database_delete_statement"></a>`database_delete_statement` | `string` | 8 | SQL statement that deletes an object in an external database. |
| <a id="f-database_column_mappings"></a>`database_column_mappings` | repeated [`ObjectTypeColumnMapping`](https://developer.m-files.com/APIs/gRPC-API/Reference/Messages/MFiles.ObjectTypeColumnMapping/index.md) | 9 | Column mappings. |
| <a id="f-automatic_acl_for_objects"></a>`automatic_acl_for_objects` | [`AutomaticPermissions`](https://developer.m-files.com/APIs/gRPC-API/Reference/Messages/MFiles.AutomaticPermissions/index.md) | 10 | The default automatic permissions for items and objects. |
| <a id="f-aliases"></a>`aliases` | `string` | 11 | Semicolon-separated list of semantic aliases. |
| <a id="f-tags"></a>`tags` | repeated [`NamedValueNamespace`](https://developer.m-files.com/APIs/gRPC-API/Reference/Messages/MFiles.NamedValueNamespace/index.md) | 12 | Names value namespaces related to the object type. |
| <a id="f-version_number"></a>`version_number` | `uint32` | 13 | Object type version number, used for OT modification conflicts tracking. |

<a id="used-by-methods"></a>

## Used by methods

- [IRPCObjectTypesAdmin.AddObjectType](https://developer.m-files.com/APIs/gRPC-API/Reference/MFiles.IRPCObjectTypesAdmin/AddObjectType/index.md): Creates a new object type or value list.
- [IRPCObjectTypesAdmin.GetObjectTypeDef](https://developer.m-files.com/APIs/gRPC-API/Reference/MFiles.IRPCObjectTypesAdmin/GetObjectTypeDef/index.md): Gets the full administrative definition of one object type or value list.
- [IRPCObjectTypesAdmin.GetObjectTypeDefs](https://developer.m-files.com/APIs/gRPC-API/Reference/MFiles.IRPCObjectTypesAdmin/GetObjectTypeDefs/index.md): Gets the full administrative definitions of all real object types.
- [IRPCObjectTypesAdmin.GetValueListDefs](https://developer.m-files.com/APIs/gRPC-API/Reference/MFiles.IRPCObjectTypesAdmin/GetValueListDefs/index.md): Gets the full administrative definitions of all object types and value lists.
- [IRPCObjectTypesAdmin.ModifyObjectType](https://developer.m-files.com/APIs/gRPC-API/Reference/MFiles.IRPCObjectTypesAdmin/ModifyObjectType/index.md): Saves a changed definition of an object type or value list.
- [IRPCObjectTypesAdmin.RefreshExternalObjectTypeColumnMappings](https://developer.m-files.com/APIs/gRPC-API/Reference/MFiles.IRPCObjectTypesAdmin/RefreshExternalObjectTypeColumnMappings/index.md): Re-reads the columns of an external object type's SELECT statement, merges them with the existing column mappings, and saves the object type.

<a id="used-in-fields"></a>

## Used in fields

- [`ObjectTypeAndValueListAdminStructureResponse.object_types_and_value_lists`](https://developer.m-files.com/APIs/gRPC-API/Reference/Messages/MFiles.ObjectTypeAndValueListAdminStructureResponse/index.md#f-object_types_and_value_lists): The object type and value list entries.
- [`ObjectTypeDecl.ot_admin`](https://developer.m-files.com/APIs/gRPC-API/Reference/Messages/MFiles.ObjectTypeDecl/index.md#f-ot_admin): Object type admin data.
- [`GetObjectTypeDefsResponse.object_types`](https://developer.m-files.com/APIs/gRPC-API/Reference/MFiles.IRPCObjectTypesAdmin/GetObjectTypeDefs/index.md#response): One [ValueListAdmin](https://developer.m-files.com/APIs/gRPC-API/Reference/Messages/MFiles.ValueListAdmin/index.md) per object type.
- [`GetValueListDefsResponse.object_types`](https://developer.m-files.com/APIs/gRPC-API/Reference/MFiles.IRPCObjectTypesAdmin/GetValueListDefs/index.md#response): One [ValueListAdmin](https://developer.m-files.com/APIs/gRPC-API/Reference/Messages/MFiles.ValueListAdmin/index.md) per object type or value list.
- [`AddObjectTypeRequest.obj_type`](https://developer.m-files.com/APIs/gRPC-API/Reference/MFiles.IRPCObjectTypesAdmin/AddObjectType/index.md#request): The new object type or value list. `object_type.is_real_object_type` chooses between the two. The ID, GUID and owner property definition are ignored and assigned by the server.
- [`AddObjectTypeResponse.obj_type_result`](https://developer.m-files.com/APIs/gRPC-API/Reference/MFiles.IRPCObjectTypesAdmin/AddObjectType/index.md#response): The new definition with its ID, GUID and owner property definition (`object_type.owner_property_def`) set.
- [`GetObjectTypeDefResponse.obj_type_result`](https://developer.m-files.com/APIs/gRPC-API/Reference/MFiles.IRPCObjectTypesAdmin/GetObjectTypeDef/index.md#response): The definition. See [ValueListAdmin](https://developer.m-files.com/APIs/gRPC-API/Reference/Messages/MFiles.ValueListAdmin/index.md).
- [`RefreshExternalObjectTypeColumnMappingsRequest.obj_type`](https://developer.m-files.com/APIs/gRPC-API/Reference/MFiles.IRPCObjectTypesAdmin/RefreshExternalObjectTypeColumnMappings/index.md#request): The object type's current definition; its connection string and SELECT statement are used to read the columns.
- [`RefreshExternalObjectTypeColumnMappingsResponse.result`](https://developer.m-files.com/APIs/gRPC-API/Reference/MFiles.IRPCObjectTypesAdmin/RefreshExternalObjectTypeColumnMappings/index.md#response): The definition as saved, with refreshed `database_column_mappings`.
- [`ModifyObjectTypeRequest.obj_type`](https://developer.m-files.com/APIs/gRPC-API/Reference/MFiles.IRPCObjectTypesAdmin/ModifyObjectType/index.md#request): The complete new definition; `object_type.id` identifies the object type. Start from [GetObjectTypeDef](https://developer.m-files.com/APIs/gRPC-API/Reference/MFiles.IRPCObjectTypesAdmin/GetObjectTypeDef/index.md).
- [`ModifyObjectTypeResponse.result`](https://developer.m-files.com/APIs/gRPC-API/Reference/MFiles.IRPCObjectTypesAdmin/ModifyObjectType/index.md#response): The definition as stored.