Using Jira cloud, I setup a custom field of type assets. I've setup an integration to a MySQL database to populate it with data. Leveraging the External Data add-on, everything is working as expected.
However my only limitation is that I cannot query this field using JQL e.g.
issuetype = asset AND "Device(s)[Assets]" IN (12345, 12456)
I cannot simply order my results using this custom field either which suggests I'm querying incorrectly or it is not supported.
Can anyone provide more information on the custom Assets field?