# 4. Data Management # 4.1 Queries Queries are a powerful tool the Officer can use to filter SRs through various stages in the plat-form. The Officer can: · **Filter** the number of SRs displayed based on the Officer’s selected parameters. · **Export** the result of a query to JSON or CSV formats. ### 4.1.1. Create a query The Officer can access the Query Builder through the 'Data Management’ menu at the top of the page, then click on the 'Queries' option (Data Management > Queries). [![image.png](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/scaled-1680-/9XNimage.png)](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/9XNimage.png) In this section, the Officer will be able to create queries, share them with other users or manage queries shared by other users with the Officer. ‘**In BO**’ column refers to the case if the query is included in a batch operation or not. The Officer can see the BOs that are using the query by hovering over the ‘edit properties’ option in the 3-dot menu (N/A for Safety Recommendations) ‘**To Lobby**’ column, with a filter for ‘yes’ or ‘no’. The query can be exported between UAT and PROD environments or between Authorities depending on whether the query to be exported has custom attributes or not. If it has custom attributes, it cannot be exported. The Officer will have a library tree on the left panel, including all the libraries available to the Officer. Those are the folders that can have categories and subcategories. Find more information about Libraries in the section Query libraries. To view the Queries inside a library, category or subcategory, the Officer has to click on the corresponding folder. The right side of the window will display the list of queries available for that selected folder: [![image.png](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/scaled-1680-/pPeimage.png)](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/pPeimage.png) The Officer can click the 'New Query' button to create a new one in the selected Library or folder. A new window will be displayed with the Query Builder: [![image.png](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/scaled-1680-/W5Qimage.png)](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/W5Qimage.png) The Query Builder allows the Officer to build queries to search SRs with attributes or metadata fields that meet the given conditions. The queries are executed against the safety recommendations indexed in ElasticSearch. The Officer has to fill in a unique Query Name for each of the Officer’s queries and select a Library where to store the query. See Libraries section for more information. Before executing, exporting or saving a query from the Query Builder, it is required to select over which reports the query will be executed on the ‘Count Number of Items’ section: [![image.png](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/scaled-1680-/L4rimage.png)](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/L4rimage.png) They will be activated as soon as the mandatory fields of the query are filled. **SRIS queries (based on SRIS Taxonomy)** · Safety Recommendations: including ‘Archived’ ones (Draft versions are not included). · ECR: All safety recommendations shared to the ECR by mine and other Authorities (major versions only) ### 4.1.2. Query conditions – Attributes and metadata Once in the Query Builder, the Officer has to select the query parameters to set each rule by clicking on ‘Select Attribute’ under the ‘Conditions’ section. [![image.png](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/scaled-1680-/8jwimage.png)](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/8jwimage.png) The system will display a modal window where the Officer can choose between: · **Attributes**: Any of the attributes available for the Officer’s Authority Taxonomy: [![image.png](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/scaled-1680-/4aZimage.png)](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/4aZimage.png) · **Metadata**: additional information found at the database level that can be relevant for the Officer to query by: [![image.png](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/scaled-1680-/Czhimage.png)](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/Czhimage.png) ü e2id – E2 identifier of SRs ü Audit fields – they refer to the information of the specific version of the re-port: o au\_creation\_date: the date when the report has been created o au\_creation\_user: user who has created the report o au\_modification\_date: the last date the report was updated o au\_modification\_user: the last user that updated the report ü blocked – it is set to TRUE when the report is blocked to prevent the users from editing it ü last\_shared\_ecr – it determines the last time the SR was shared with the ECR ü responsible\_entities\_id – id of the responsible Entity (Authority in E2) ü status – the report status, as described in the section Management of the SRs ü Version – version number ### 4.1.3. Query structure The queries are made using at least one rule. A rule is a condition the search made by the query has to meet. Queries can also include various rules and groups of rules. A query can include one or more existing queries (subqueries). Queries cannot be edited while included as a subquery of another query. A rule contains a condition to be met concerning an attribute or metadata field. Layouts and operators vary depending on the attribute and metadata field type, i.e.: If the Officer selects ‘Closure Date’ as an attribute, the system will display ‘Value’ as the unique possible selectable layout and the Select Operator filter: [![image.png](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/scaled-1680-/moJimage.png)](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/moJimage.png) This will generate a ‘Date’ field to be filled by the Officer. **Attributes** · **Alphanumeric and Text** attributes or metadata fields can be searched in documents by a complete word using the layout ‘Value (Word)’ or by a string of characters using the layout ‘Text’. i.e.: ü Value (Word) as in ‘Aircraft’ (complete word) ü Text begins with ‘Airc’ (a string of characters)
Data Type Layout Operators
Alphanumeric, Text Value (Word) equal does not equal in not in is null is not null
Text in not in begins with does not begin with ends with does not end with is null is not null
· **Code** attributes can be searched in documents using layouts: ü Value: selecting one or more values of the value list ü Level: when the value list has more than one level, selecting all the values of a branch (level) in the value list, starting from the selected value(s) ü Alias: when the value list has alias(es), selecting one of them
Data Type Layout Operators
Code Value equal does not equal in not in is null is not null
Level \* if the Value List has more than one level equal does not equal in not in is null is not null
Alias \* if the Value List has alias(es) in not in begins with does not begin with ends with does not end with
· **Code and Additional Text, Code or Alternative Text** attributes can be searched in documents using layouts: ü Value: selecting one or more values of the value list ü Level: when the value list has more than one level, selecting all the values of a branch in the value list ü Alias: when the value list has alias(es), select one of them. ü Text: typing a string of characters
Data Type Layout Operators
Code and Additional Text, Code or Alternative Text Value equal does not equal in not in is null is not null
Level \* if the Value List has more than one level equal does not equal in not in is null is not null
Alias \* if the Value List has alias(es) in not in begins with does not begin with ends with does not end with
Text Used to search in the Text part of the Attribute in not in begins with does not begin with ends with does not end with is null is not null
· **Date and DateTime** attributes can be searched in documents using layouts: ü Value: when searching by date or range of dates ü Date of the Month (1-31): when searching by the day of the month ü Date of Week (1-7): when searching by the day of the week ü Month (1-12): when searching by the month ü Year: when searching by year
Data Type Layout Operators
Date, DateTime Value equal does not equal less than less or equal greater than greater or equal between not between
Day of the Month (1-31) equal does not equal less than less or equal greater than greater or equal between not between
Day of Week (1-7) equal does not equal less than less or equal greater than greater or equal between not between
Month equal does not equal less than less or equal greater than greater or equal between not between
Year equal does not equal less than less or equal greater than greater or equal between not between
· **Time** attributes can be searched in documents using layouts: ü Value: when searching by hours and minutes
Data Type Layout Operators
Time Value equal does not equal less than less or equal greater than greater or equal between not between is null is not null
· **Latitude** and **Longitude** attributes can be searched in documents using layouts: ü Value: when searching by degrees, minutes and seconds or range of them
Data Type Layout Operators
Latitude, Longitude Value equal does not equal less than less or equal greater than greater or equal between not between is null is not null
· **Decimal** attributes can be searched in documents using layouts: ü Value: when searching by a decimal number
Data Type Layout Operators
Decimals Value equal does not equal less than less or equal greater than greater or equal between not between is null is not null
· **Number** attributes can be searched in documents using layouts: ü Value: when searching by an integer number
Data Type Layout Operators
Number Value equal does not equal less than less or equal greater than greater or equal between not between is null is not null
· **ECCAIRS Resource Locator** attributes can be searched in documents using layouts: ü File Name: When searching by the Name of an attached field ü Description: When searching by the description given in the attached field
Data Type Layout Operators
ECCAIRS Resource Locator File Name equal does not equal in not in is null is not null
Description equal does not equal in not in is null is not null
· **ECCAIRS Embedded** **data** attributes can be searched in documents using layouts: ü ECCAIRS number: when searching the former document's ECCAIRS number
Data Type Layout Operators
ECCAIRS Embedded Data ECCAIRS number in not in begins with does not begin with ends with does not end with is null is not null
· **ECCAIRS Data link** attributes can be searched in documents using layouts: ü ECCAIRS number: when searching the former document's ECCAIRS number
Data Type Layout Operators
ECCAIRS Data Link ECCAIRS number in not in begins with does not begin with ends with does not end with is null is not null
Groups can include one or more rules and one or more groups combined with and/or clauses. The Officer can click the ‘Add Rule’ button to add more rules. For groups, on the ‘Group’ tab. If the Officer wants different sets of rules to be evaluated together, the Officer has to click on the 'Add group' button. The Officer can also add groups inside other groups. Groups and rules can be rearranged, dragging and dropping them where needed. For each group, at the top centre of the group, there are the OCCURRENCE/ENTITY alternative tabs; if conditions of the given attributes shall be met in any instance of the Entity or if the conditions shall be met in the same instance of the Entity. Thus, when specifying restrictions in a query, the restrictions can be evaluated across all the entities of a record at once OR can be evaluated by each Entity of a record one by one. By default, the restrictions of a query will be evaluated across all the entities of a record at once, with the OCCURRENCE option selected by default. With the selector OCCURRENCE/ENTITY, the Officer can change that, and the restrictions will be evaluated Entity by Entity. There is a limitation in creating groups based on the restriction selected here. If a group is restricted to ENTITY, no more groups can be added inside that ENTITY group. Example of search by occurrence and by Entity: 1. **OCCURRENCE**: If we want to obtain the Safety Recommendations where the Manufacturer model (39) is equal to ‘BOEING > 787’ and the Operation Type (189) is equal to ‘Commercial Air Transport > Cargo’ independently if the conditions are met in different aircraft of a safety recommendation: [![image.png](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/scaled-1680-/Zsjimage.png)](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/Zsjimage.png) 2. **ENTITY**: If we want to obtain the Safety Recommendations where the Manufacturer model (39) is equal to ‘BOEING > 787’ and the Operation Type (189) is equal to ‘Commercial Air Transport > Cargo’ when the conditions are met in the same aircraft. [![image.png](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/scaled-1680-/vksimage.png)](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/vksimage.png) The Officer can set rules with and/or clauses and combine them as needed with groups by clicking on the ‘Group tab’ and selecting and/or clauses, i.e.: [![image.png](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/scaled-1680-/DGaimage.png)](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/DGaimage.png) **Subqueries** The Officer can add a subquery to the query through the ‘Query’ tab. The aim is to add an already existing query available for the Officer to the current query. When the Officer clicks on the ‘Query’ tab, the system will display the subquery section: [![image.png](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/scaled-1680-/nfximage.png)](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/nfximage.png) The Officer can click on ‘Select Query’, and the system will display a window to select the subquery: [![image.png](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/scaled-1680-/1mximage.png)](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/1mximage.png) The Officer must select a query from the available libraries and click ‘Add’. The system will add the subquery to the conditions of the current query. A query included as a subquery of another query cannot be edited. ### 4.1.4. Query action buttons Once the query is completed, the Officer can click on: · **Cancel button**: the system will return to the Queries page. · **Execute button**: the system will display the list of results according to the conditions set by the query. · **Save button**: The system will save the query in the list of queries of the selected Library and display the table of queries with the new query on the queries page. · **Execute button**: the system will display the table of the specific reports based on the query's conditions. To re-execute the queries, the system provides the data menu that works as explained in the Data Menu – Re-execution of Queries section. · **Export button**: this button only works when the Officer selects a type of report (SR or ECR) with results for the current query. The Officer has to click on ‘Export’, and the system will display a modal window where the Officer can select the format (JSON or CSV): [![image.png](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/scaled-1680-/TXrimage.png)](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/TXrimage.png) · **Export in JSON**: The window displays a Views tab. When the Officer clicks on it, the system displays a ‘Views’ modal window. The Officer must select one of the available views and click ‘Export’. [![image.png](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/scaled-1680-/hl0image.png)](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/hl0image.png) Once the process is finished, an email will be sent to the Officer with a zip file with the query results in the selected format. · **Export in CSV**: The Officer clicks on the ‘CSV’ tab, and the system displays a modal window where the Officer has to select between ‘Views’ and ‘Attributes’: [![image.png](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/scaled-1680-/Dupimage.png)](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/Dupimage.png) · If the Officer clicks ‘Views’, the system will display a ‘Views’ modal window. The Of-ficer must select one of the available views and click ‘Export’. Once the process is finished, an email will be sent to the Officer with a zip file with the query results in CSV format. · If the Officer selects ‘Attributes’, the system will display an Attributes List drop-down menu and a new Attributes List button: [![image.png](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/scaled-1680-/BCsimage.png)](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/BCsimage.png) The drop-down menu will provide the Attribute Lists created through ‘My Account’. They are lists of attributes that the Officer is interested in and which they create through ‘My Account’. See Export by Attribute sectionfor details. If the attributes needed do not match any available Attribute Lists, the Officer can click on ‘New Attribute List’, and the system will display a modal window to create it: [![image.png](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/scaled-1680-/J4Vimage.png)](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/J4Vimage.png) The Officer has to fill in the mandatory ‘Name’ field and deactivate the ‘Metadata fields’ if needed. Below, the system displays the Taxonomy tree with all the SRIS entities and attributes. The Officer can filter or navigate the tree to select the corresponding attributes. Once selected, they appear on the right-side panel. Attributes under the same Entity can be reordered by dragging and dropping them. Then, the Officer has to click on the Save button: [![image.png](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/scaled-1680-/xdQimage.png)](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/xdQimage.png) The Officer will select the created Attribute List on the drop-down menu and will click on the ‘Export’ button: [![image.png](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/scaled-1680-/EJfimage.png)](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/EJfimage.png) Once the process is completed, the Officer will receive an email with the CSV file, including the results of the executed query. ### 4.1.5. Management of queries – table of queries The Queries menu displays the table of queries of the corresponding Library, category or sub-category selected in the library tree: [![image.png](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/scaled-1680-/OlXimage.png)](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/OlXimage.png) #### 4.1.5.1. Editing a query The Officer has to double-click on the specific query of the queries list or click on the ‘Edit’ option of the query’s 3-dot menu, and the system will display the editing page of the query: [![image.png](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/scaled-1680-/hPOimage.png)](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/hPOimage.png) The Officer has to introduce the needed update and click on ‘Save’, ‘Export’ or ‘Execute’, as required. See the Query action buttons section for further details. This page also provides: · Elastic Query Viewer button: it accesses the ElasticSearch Query Viewer window as follows: [![image.png](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/scaled-1680-/7Qvimage.png)](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/7Qvimage.png) · Query viewer button: it opens the query viewer window as follows [![image.png](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/scaled-1680-/REIimage.png)](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/REIimage.png) #### 4.1.5.2. Duplicating a query The Officer can make a copy of an existing query and modify it. The Officer has to click on the copy icon of the 3-dot menu of the specific query of the list of queries, and the system will display the Copy query window: [![image.png](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/scaled-1680-/ClEimage.png)](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/ClEimage.png) It is like the editing page above but with the mandatory Library field empty. The Officer has to fill out the library field with a library different from the original one, and then the Execute and Export button will be activated. The Save button is not available unless a Library is selected. The Officer has to introduce the needed update and click on ‘Save’, ‘Export’ or ‘Execute’, as required. See the [Query action buttons](#_Query_action_buttons) section for further details. #### 4.1.5.3. Sharing a query Officers of the same Authority can exchange queries with each other, which will result in a notification to the receiving officers. The Officer has to click on the Sharing option of the 3-dot menu of the specific query of the list of queries, and the system will display the Share query window: [![image.png](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/scaled-1680-/JXfimage.png)](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/JXfimage.png) The Officer has to select ‘Share to User’, and then the system will display the ‘Users’ tab below. [![image.png](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/scaled-1680-/rwbimage.png)](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/rwbimage.png) The Officer has to click on ‘Users’, and the system will display the Available Users section: [![image.png](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/scaled-1680-/Bmpimage.png)](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/Bmpimage.png) The Officer has to check the specific Users, click the ‘ADD’ button, then click the ‘Save’ button. The system will save the updates of the query in the database and return to the list of queries that will have added a Shared icon to the specific query: [![image.png](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/scaled-1680-/DmTimage.png)](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/DmTimage.png) The Officer then can click on the ‘Edit share’ option that will be added to the 3-dot menu of that query and add more users or remove some of them. #### 4.1.5.4. Deleting a query The Officer has to click on the ‘Delete’ option of the specific query 3-dot menu of the list of queries, and the system will delete it and update the table of queries accordingly. A query can-not be deleted if used in Batch Operations or Query-based Notifications. See the Query-based notifications section for further details. # 4.2. Libraries All information presented in this section concerning the creation and management of libraries also applies to Word-templates. The system provides the libraries available to the Officer on the left panel of the Queries menu: [![image.png](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/scaled-1680-/JC0image.png)](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/JC0image.png) #### 4.2.1. My Personal Libraries The queries stored in personal libraries are only available to the owner of the libraries. The owner can decide to share a particular query from the Personal Libraries or share the complete Library with other Authority users. Only users with permission to execute queries will be eligible. #### 4.2.2. Local Common Library The queries stored in the Local Common Library are available for all Authority users with per-missions to queries. Officers cannot create, edit or delete queries in the Local Common Library. They can execute the queries or copy them to their Personal Libraries. #### 4.2.3. Shared with me libraries When the library owner or query has shared it with the Officer, it will appear under these users' ‘Shared with me libraries’. They can execute the queries or copy them to their Personal Libraries. #### 4.2.4. Creation of a library Once in the ‘Data management’ ‘Queries’ menu, the Officer has to click on ‘New Library’, and the system will display a modal window to create the Library: [![image.png](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/scaled-1680-/sTLimage.png)](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/sTLimage.png) The Officer has to fill in the mandatory Name field, provide a description (if needed), and specify the Sharing mode, which can be ‘Personal’ or ‘Share to User’. If ‘Share to User’ is selected, the system will display a section to choose the user/s: [![image.png](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/scaled-1680-/UVlimage.png)](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/UVlimage.png) Therein, the Officer has to select the specific users through the check box and click the ‘ADD’ button, which will be activated. The selected users will be available on the ‘Selected Users’ tab. The Officer has to click on ‘Save’ for both Personal or Shared to User, and the Library will be saved accordingly and will appear in the left pane under ‘My Personal Libraries’: [![image.png](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/scaled-1680-/xznimage.png)](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/xznimage.png) If the created Library is ‘Shared to user’, it will show the ‘Shared’ icon [![image.png](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/scaled-1680-/EGDimage.png)](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/EGDimage.png) #### 4.2.4. Management of My Personal Libraries Next to each Library under My Personal Libraries of the Officer, the system provides the deleting, adding category and editing buttons. [![image.png](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/scaled-1680-/54cimage.png)](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/54cimage.png) ##### 4.2.4.1. Deleting a Library The Officer has to click on the Delete icon (rubbish) next to the specific Library, and the system will delete the Library from the My Personal Libraries tree as long as it has no more queries. Otherwise, the system will display a warning message and will not delete the Library. The library tree will be updated accordingly. ##### 4.2.4.2. Adding a category or folder to a Library The Officer has to click on the ‘+’ button next to the specific Library, and the system will display a folder below the Library: [![image.png](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/scaled-1680-/4Tgimage.png)](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/4Tgimage.png) The Officer has to type a Name and click on ‘Intro’. The folder or category will be added to the tree and will be available to store queries of the Officer: [![image.png](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/scaled-1680-/W9Uimage.png)](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/W9Uimage.png) Next to the folder or category, the management buttons will appear as follows: [![image.png](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/scaled-1680-/3W1image.png)](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/3W1image.png) The category can only be deleted if it does not include queries. The ‘+’ button is to add subcategories. It works the same way as adding categories to the Library. The edit button only updates the Name, not the location of the category. ##### 4.2.4.3. Editing a Library The Officer has to click on the editing (pencil) icon next to the specific Library, and the system will display the editing window: [![image.png](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/scaled-1680-/s3eimage.png)](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/s3eimage.png) This page is the same as the library creation window of the previous section. The Officer must update the corresponding fields and click ‘Save’. The changes will be saved in the database and Library tree. [![image.png](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/scaled-1680-/KIGimage.png)](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/KIGimage.png) # 4.3. Word Templates Word Templates in ECCAIRS2 are used to export reports in Word format. The Word template has to include the complete path of the attributes according to the Authority’s released taxonomy so that the system can fill each template field with the Attribute's corresponding value in the SR. Each table in the Word Template corresponds to an entity in the taxonomy. i.e.: [![image.png](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/scaled-1680-/zsFimage.png)](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/zsFimage.png) The Word Template will have tags included in token « » with the following characteristics: · Attribute: A · Attribute custom: AC · Entity: E · Separation token: . · ID: TaxonomyCode Example: «E1.A1» ->ENTITY.1.ATTRIBUTE.1 «E1.E45.AC1» ->ENTITY.1.ENTITY.45.ATTRIBUTES\_CUSTOM.1 Depending on the attribute data type, it should be indicated what part of the Attribute will be included in the Word Template:
Attribute Data Type Field Example
Date, Time, Text, Alphanumeric, Number content (default) «E1.A1»
Code content (default) «E1.A1»
Code and Additional Text content (default) additionalText «E1.A1» «E1.A1.additionalText»
Code or Alternative Text content (default) alternativeText «E1.A1» «E1.A1.alternativeText»
Decimal content (default) unit «E1.A1» «E1.A1.unit»
ECCAIRS Resource Locator filename (default) description «E1.A1» «E1.A1.description»
ECCAIRS Embedded Data eccairsNumber (default) «E1.A1»
ECCAIRS Data Link eccairsNumber (default) «E1.A1»
Latitude & Longitude «E1.A1.degree» «E1.A1.minutes» «E1.A1.seconds» «E1.A1.direction»
Once the Word template is configured, the Officer can save it into E2 libraries. This is the sec-ond Data management menu: [![image.png](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/scaled-1680-/uL5image.png)](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/uL5image.png) It shares the library tree with the Queries menu and the option to create and manage libraries and categories. All of this is described in the Management of My Personal Libraries section. ### 4.3.1. Create a Word Template To create a Word Template (from now on WT), the Officer has to click on ‘New WT’ at the top of the page, and the system will display a modal window: [![image.png](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/scaled-1680-/PUIimage.png)](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/PUIimage.png) The Officer has to fill in the Name that has to be different from the existing ones, upload the needed Word Template file to the Template section through the ‘Select file’ button or drag and drop it to the section and select a Library, a category and a subcategory. Then, the Officer has to click on the ‘Save’ button. The system will save the WT in the database, return to the WTs page, and add the specific WT to the table of WTs. [![image.png](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/scaled-1680-/9Lkimage.png)](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/9Lkimage.png) The saved WT will be available in the Export options for the SRs in Word format. See the [Export](#_Export) section of SRs for further details. ### 4.3.2. Management of Word Templates #### 4.3.2.1. Edit a WT The Officer has to double-click on the Name of the specific WT of the list of WTs or click on the ‘Edit’ option of the 3-dot menu of the WT on the list, and the system will display the Edit window: [![image.png](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/scaled-1680-/SiRimage.png)](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/SiRimage.png) The Name field cannot be updated; only the other fields of the WT, including the Library, can be updated. The Officer has to update the corresponding fields and click ‘Save’. The system will save the updates in the database and return to the WT menu with the updated list of WTs. #### 4.3.2.2. Copy a WT The Officer has to click on the ‘Copy’ option of the 3-dot menu of the WT on the list, and the system will display the Copy WT window: [![image.png](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/scaled-1680-/Si9image.png)](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/Si9image.png) The management of this window is the same as the editing option above, with the only difference being that the Name field can be updated. The Officer can select a library different from where the WT was stored previously. #### 4.3.2.3. Share a WT The Officer has to click on the ‘Share’ option of the 3-dot menu of the WT on the list, and the system will display the Share WT window: [![image.png](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/scaled-1680-/weVimage.png)](https://help.ci-aviationreporting.eu/uploads/images/gallery/2025-11/weVimage.png) This option works as described in the ‘Share a query’ section Management of queries – table of queries with the only difference being the information shared. #### 4.3.2.4. Download a WT The Officer has to click on the ‘Share’ option of the 3-dot menu of the WT on the list of WTs, and the system will download the WT. #### 4.3.2.5. Delete a WT The Officer has to click on the ‘Delete’ option of the 3-dot menu of the WT on the list of WTs, and the system will delete it from the database and update the list of WTs accordingly.