Count the number of url links in a field

[Scott Robins]

Hi Folks

I have a field called external links, and in this field i may have multiple website links.

I would like to be able to find out how i can count the number of these links. I have 1000's of tickets so manually is not an option.

Kind Regards

Scott

[Scott Robins]

Hi Noah

Sorry, thats not really what i am looking for, i am not looking for the count of the rows that have a web link in them, for example row 1 might have 50 links in the field, row two might have 20 links, etc etc so if i was to do a count on these rows the answer would be 70.

Kind Regards

Scott

[noamdah]

I can get you closer the the resolution, here is a query that will return the number of issues that have the field "external links" (Find the field id and replace with <id>)

select count(*) from customfieldvalue where CUSTOMFIELD = <id>;

Also try to take the results of this query to Excel to find a counting solution there:

select * from customfieldvalue where CUSTOMFIELD = <id>;