Problem:

In certain environments, it can happen that the custom field of type Asset Object is used in a Software Project. 

When using JQL to fetch the results related to the Asset Object custom field, the column doesn't display any results when the query gets complicated. 

Environment

Jira cloud

Steps to Reproduce:

• Create a custom field of type Asset Object (this type is only available in the custom filed section if the instance has JSM product)
• Add the field to a Software project to store data. 

Let us say the field created is myAsset, the below JQL won't return any results in the myAsset column if there are quite a high number of issues returned: 

myAsset IS NOT EMPTY

myAsset IN ("name of asset") AND created >= -20d  

Expected Results

The column myAsset should display the values like other columns. 

Actual Results

The column myAsset  displays value if the query returns less issue or is not complex.

Workaround

For now, try to keep the query much simpler which would not return a large number of issues.