Hello everyone
I added an custom text field and I did reindex. JIRA's version 7.1.2 (server). Then I try search issues when custom field's value ~"334" and I get 4 issues.
Project A Issue C Broject B Issue F Broject B Issue G Broject B Issue H
But when I did request to database
select j.project, j.issuenum, j.summary, cf.stringvalue from customfieldvalue cf, jiraissue j where cf.customfield=14402 and cf.issue(+)=j.id and cf.stringvalue='334'
I get 8 issues.
Project A Issue C Project A Issue D Project A Issue E Broject B Issue F Broject B Issue G Broject B Issue H Broject B Issue J Broject B Issue K
Why I can't get 8 issues via jql?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.