[Bug] using quick-filter "shared with my org" takes arround 90 seconds

[crackytsi]

Request Type

Bug

Work Environment

Question	Answer
OS version (server)	Debian
OS version (client)	10
Virtualized Env.	False
Dedicated RAM	64 GB
vCPU	8
TheHive version / git hash	4.1.4
Package Type	DEB
Database	Cassandra
Index type	Lucene
Attachments storage	Local

Problem Description

Using Quick-filter "shared with my org" takes very log to load and all 8 CPUs are high CPU usage.
Some details:
/api/v1/query?name=cases.count

{"query":[{"_name":"listCase"},{"_name":"filter","_not":{"_like":{"_field":"owningOrganisation","_value":"myOrg2"}}},{"_name":"limitedCount"}]}

/api/v1/query?name=cases

{"query":[{"_name":"listCase"},{"_name":"filter","_not":{"_like":{"_field":"owningOrganisation","_value":"myOrg2"}}},{"_name":"sort","_fields":[{"flag":"desc"},{"startDate":"desc"}]},{"_name":"page","from":0,"to":15,"extraData":["observableStats","taskStats","procedureCount","isOwner","shareCount","permissions","actionRequired"]}]}

[To-om]

The field "owningOrganisation" is not indexed. This is why the query is slow. This can be fixed in the next release.