Schema

Schema refers to the structure of the data. In LEXolution.DMS, a user can customize their own schema.

Lists

Selection lists can offer distinct values from a database column or a fixed list that can be configured by the user.

Loading List Definitions

var listdata = await dms.Schema.LoadListData();

The result object contains a list of the configured fixed selection lists (Lists) and the mapping of which field is linked to which selection list (FieldListRelations).

There are special lists that are system-relevant. These contain a value in the ListKey property. Currently, this is only the document category. To find this list, you can compare the ListKey field with the value ListKeys.DocumentCategory.

var documentCategoryList = listdata.Lists
     .FirstOrDefault(l => l.ListKey == ListKeys.DocumentCategory);

The ColorName field in the list can contain the .Net name of a color, but it's usually a string in the following format: r=255,g=0,b=0.

Topic Definitions

There are various file/folder types that can be configured by the user to some extent. These are called topics. The user can modify the delivered topics and create their own additional ones. The list of topics set by the user can be queried with the following call.

var topics = await dms.Schema.LoadTopicVisualLayers();

The result is a list of definitions. First, the base types are delivered, namely Document, Dossier, and Folder. Then come the actual topics. The classes in the list have 4 ItemDtos list properties, which are only filled depending on the type of definition. For the base type Document, the DocumentItemsDto property is set and contains the fields that every document has. For the two base types Dossier and Folder, the ContainerItemsDto is set and similarly contains the general file/folder fields.

For the remaining definitions, both ContainerIndexItemsDto and DocumentIndexItemsDto are usually set. The only exception should be the topic Mail, which only contains document fields.