I am running version 6.4.3.
I have a multi-line custom text field that contains entries separated by commas. I want to be able to run a query that returns Issues sorted by the number of entries in that custom field. Counting the number of commas in the field would do the trick, I think.
Any ideas?
I'd use a scripted field to count up the commas. You will need some code to do this no matter what, there's nothing built-in that can do it.
Thanks.
Another solution is to export to Excel, and use an Excel formula to count the commas. The drawback here is that I can only export 1000 rows at a time. I have a little more than 2800 Issues that I need to look, so this isn't *too* painful.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.