Connections (foreign keys) from cache

Similar to the "Connections (foreign keys)" list, which is created in a lengthy process each time it is called up, this evaluation is cached and therefore always immediately available. It is updated with every portal update.

List

This group contains characteristics that represent a list of foreign key connections from the cache. It provides a quick overview of the stored relationships between different entities in the system.

Property	Description
Traffic light	The traffic light column gives a colored indication of the status of the stored data. See the associated notes for further information
Note	The note in this column gives you further information on the displayed traffic light color. Follow the instructions to be able to change red and yellow traffic lights in particular.
Start form	The name of the form from which the foreign key is created.
Info area	The name of the area in the start table in which the characteristic for the foreign key is stored.
Static feature	The name of the feature in the start table from which the foreign key originates.
Feature tooltip	The tooltip of the characteristic from which the foreign key originates is displayed here.
Target form	Specification of the form to which this foreign key leads.
Support article link	Display of the link to the support article
Contained in product(s)	Here you can see which eTASK products use this connection.
Included in product suite(s)	Here you can see which eTASK suites use this connection.
Product Owner	This field shows the product owner who is responsible for the respective product or functionality. The product owner plays an important role in prioritizing requirements and managing product development.
Menu path	This menu path shows the hierarchical navigation path to a specific menu item in the system. It helps you to understand the exact position and context of an item within the menu structure, making it easier to navigate and find specific functions.
Foreign key	This field shows the key value that establishes a link to another data record. It enables the linking of information from different areas of the system and is important for the correct assignment and display of related data.
Feature type	Depending on whether the foreign key is formed via an ID or a GUID value, the characteristic type can be an ENumberField or an ETextField.
Namespace	The namespace defines the logical area in which the foreign key is used. It helps to organize and structure the data in the system and enables foreign keys to be clearly assigned to specific functional areas or modules.
System name	The unique technical system name of the target feature in eTASK.
Foreign key DB	This field contains the complete SQL command for creating the foreign key relationship in the target database. It serves as a reference for the exact definition of the link between tables and enables precise tracking of the database structure.
Foreign key Name	This entry shows the name of a foreign key that establishes a relationship between different data records in the system. It is used to uniquely identify and link related information across table boundaries.
Sequence	The order serves as a general sorting of the entries in this list, based on the main menu in eTASK.
Form tooltip	The tooltip of the start form from which the foreign key originates is displayed here.
Form tooltip length	Specifies how many words the tooltip for the form contains. A quality feature.
Feature Tooltip length	Shows the length of the tooltip for the feature (in number of words). A quality characteristic.
discontinued	⚠️ This property will be removed in one of the next releases. Please do not use it anymore. This field indicates whether the foreign key has been marked as obsolete or no longer valid. It helps users to quickly recognize which entries may no longer be relevant or current and may require special attention in future operations or analyses.
Target form canceled	Here you can see whether the target form to which this feature leads has been discontinued, is discontinued and will be removed from eTASK in the future. In this case, do not use the feature.
Target form - application discontinued	Here you can see whether the application of this feature has been discontinued and it will be removed from eTASK in the future. Do not use the feature in in this case.
Mandatory field	This checkbox indicates whether the corresponding field is a mandatory field. Mandatory fields must be completed in order to ensure the completeness and integrity of the data.
visible	Specifies whether this foreign key is visible or not displayed in the form.
activated	This field indicates whether the foreign key cache entry is active and ready for use. An activated entry is taken into account for database queries, which improves system performance and ensures consistent data relationships.
NULL values allowed?	Here you can see whether this connection is mandatory or can be left blank.
Data type DB	This field shows the data type as it is defined in the underlying database. It provides information about the type of information stored and helps to interpret and process the data in the system.
Data type eTASK	This data type defines the type of data used in eTASK for this foreign key. It determines how the information is processed and displayed in the system and is crucial for the correct handling of the data in various processes and applications.

IDs and UIDs for links

This group contains identifiers and unique identifiers for links between data records. It enables the efficient assignment and management of foreign key relationships in the cache system.

Property	Description
Sequence area	This specifies the number of the area within the form in which the characteristic for the foreign key is located.
Feature Sequence	Specifies the position of the characteristic within the info area. Dyn. Characteristics can influence and overwrite this fixed configuration. overwrite it.