Can you display a custom field in a different format (e.g. character as number)

Question

I created a custom field called Project Priority, which is a single line text field, but is more often than not a numeric value (for flexibility). Is there a JQL query that can be written to translate the field entered and display it as a numeric value?

Thanks,

Sheel Shah

AgentSmith · Answer

Just adding this previous posting since its relevant to this subject:

https://answers.atlassian.com/questions/102209

Shayne _Atlassian_ · Answer

Can you please give an example of what you're looking to do? It sounds like you want to cast a string ("1") into an integer (1), which I believe might be possible, but would require add-ons that may not be available for JIRA Cloud.

If you're just looking to run a JQL search on numeric values in a text field, you should be able to encase the numerical value in quotes to return a result. As an example: Project = DEMO AND customField ~ "32"