Refine the List Report with Additional Annotations

Open the annotations.cds file located in the app folder of your service.

There´s a second annotations.cds file below folder app/incidents. This file was created during the generation of the application and is not meant to be modified within this tutorial.

The annotation SelectionFields defines the filter fields offered in the filter bar.

Search for the SelectionFields annotation and add an additional field category_code to the existing list of fields, as shown in the coding example below. When editing the file, code completion helps to select the field.

SelectionFields : [
    incidentStatus_code,
    priority_code,
    //insert your selection fields enhancement here
    category_code
],

After saving the file, the server will be restarted and when refreshing the application, the new field is added to the filter bar.

Applications can bring up value help for fields that allow users to choose from existing values. Once the property has a value list annotation, it is displayed as an input field with a value help icon.
The value help dialog supports full-text search and a filter bar that can help users to find the right value.

1. Click on the value help icon in the Category selection field to take a look at the current value help.

   

   The default value help will look like this:

   

2. To enrich the current value help with a description property, proceed as follows:

   Open the common.cds file located in the srv folder of your service.

   

   Add the ValueList code (lines 11-26) to the category property of the Incidents entity in the common.cds file.

   annotate service.Incidents with {
       incidentStatus @Common : {
           Text            : incidentStatus.name,
           TextArrangement : #TextOnly,
           ValueListWithFixedValues
       };
       category       @Common : {
           Text            : category.name,
           TextArrangement : #TextOnly,
           //insert your value list here
           ValueList       : {
               $Type          : 'Common.ValueListType',
               Label          : 'Category',
               CollectionPath : 'Category',
               Parameters     : [
               {
                   $Type             : 'Common.ValueListParameterInOut',
                   LocalDataProperty : category_code,
                   ValueListProperty : 'code'
               },
               {
                   $Type             : 'Common.ValueListParameterDisplayOnly',
                   ValueListProperty : 'descr'
               }
               ]
           }
       };
       priority       @Common : {
           Text            : priority.name,
           TextArrangement : #TextOnly,
           ValueListWithFixedValues
       };
   };
   

   CollectionPath

   The CollectionPath property defines the entity set to request data for the value help. In this example the data is loaded from the entity set Category.

   $Type

   The $Type property determines the behavior of a single parameter used within the value help. The value ValueListParameterInOut is used for parameters which take over values prefilled by the application for filtering the data (-In). On the other hand the selected value will also be passed back to the application (-Out). The value ValueListParameterDisplayOnly is used for parameters without interaction between the application and the value help. The parameter is just used for displaying the data for selection.

   Depending on the value of the $Type, additional properties for the parameter need to be defined:

   • LocalDataProperty The property of the source entity set the value help will be defined for.

   • ValueListProperty The property of the target entity set the value help will request data from (see CollectionPath). These are the properties presented within the filter bar and table of the value help dialog.

3. After saving the file, refreshing the application and opening the value help for the Category, you´ll see the improved value help showing the description.

   

To add an additional column to the list report table, you will use the annotation LineItem. Again, ensure that the annotations.cds file of the service is opened (see step 1).

Now search for the annotation LineItem of the Incidents entity and add the new column representing the field title as shown in the coding below.

LineItem : [
    {
        $Type : 'UI.DataField',
        Value : identifier,
    },
    {
        $Type                     : 'UI.DataField',
        Value                     : priority_code,
        Criticality               : priority.criticality,
        CriticalityRepresentation : #WithoutIcon,

    },
    {
        $Type : 'UI.DataField',
        Value : incidentStatus_code
    },
    {
        $Type : 'UI.DataField',
        Value : category_code
    },
    //insert your line item enhancement here
    {
        $Type : 'UI.DataField',
        Value : title
    }
],

After saving and refreshing the application, you will see the column added to the table.