Souad Hadjiat

### Proposed changes * Retrieve only needed fields * TODO : need to test ### Related issues * #6031 ### Checklist - [ ] I consider the submitted work as...

[backend] Filter observables creation with refs from indicators (#5293)

1

### Proposed changes * filter observables created from indicators * Adding unit tests * TODO: need to test and validate this solution (to be sure we want to stop creating...

### Proposed changes * * ### Related issues * * ### Checklist - [ ] I consider the submitted work as finished - [ ] I tested the code for...

[backend] Handle external refs files upload by import document (#7080)

4

### Proposed changes * Include external reference files for document import * When uploading a file in external reference, get the entities (stix domain objects) linked to the external ref...

[backend] Trigger enrichment connectors with filters (#5371)

1

### Proposed changes * define connector_trigger_filters * filter enrichment connectors ### Related issues * #5371 ### Checklist - [ ] I consider the submitted work as finished - [ ]...

### Proposed changes * use aggregation to count files by mime type ### Related issues * #7530 performance issue not reproduced locally => need to test queries directly on DB...

Attack pattern knowledge matrix query perf issue

3

## Description When viewing the attack patterns of an entity (in knowledge view), the query used to display this view can send a lot of requests to the database, leading...

[backend] Improve redis sessions list perf (#7943)

1

### Proposed changes * prevent locking the event loop when parsing users sessions ### Related issues * #7943 ### Checklist - [x] I consider the submitted work as finished -...

[backend] Improve Attack Pattern knowledge matrix view performance (#6662)

1

### Proposed changes * optimize attackPatterns query (use aggregations for isSubAttackPattern), use batch loading for parentAttackPatterns and subAttackPatterns * add pagination and filters for sub connections (coursesOfAction, parentAttackPatterns, subAttackPatterns), because...

## Description ``` {"category":"APP","errors":[{"attributes":{"errors":[{"caused_by":{"caused_by":{"reason":"Numeric value (1722530083665) out of range of int (-2147483648 - 2147483647)\n at [Source: (byte[])\"\"[truncated 1210 bytes]; line: 1, column: 617]","type":"illegal_argument_exception"},"reason":"[1:604] failed to parse field [context_data.input.sort] of type...