Filter with !~ or not in does not consider Resolution Unresolved.

Thus, looking for Issues without Resolution, the user had to use the following JQL.

resolution in (Unresolved) OR resolution not in (Duplicate)

This is the available workaround but not a good solution.

The expectation is that the filter with the following:

resolution not in (Duplicate)

should consider all other resolutions, including Unresolved.

User is aware that Unresolved has a NULL value. However, believes this should be considered as an improvement.

Likewise, the operator !~ should consider empty fields.