Is there a JQL query that will search for text of a certain length?

Donna Macauley

For example we are finding that saving an Excel export as a CSV sometimes truncates the description text. I would like to search for issues that have a description with text of a certain length to verify it imported correctly.
So the query would be --> give me a list of issues that have a description of 500 characters or more.

Santak

Hi,

 You can do a DB query like this if connect to your database

select count(*) from jiraissue where length(`DESCRIPTION`) > 500

Thanks

Santak