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
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
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>;
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.