Can i use JQL to query a custom assets field?

[Kieran Donnelly]

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?