How to show subtasks in Agile Board backlog

[Layo Adeyemi]

Hi JIRA community,
I am trying to set some TASKS as SUBTASKS for created stories. In my JIRA-Test env, SUBTASKS seem to indent (makes it easier to read), and more importantly are visible on the backlog. However in my JIRA-Prod env, SUBTASKS are embedded within stories, and are not viewable from the backlog. Do you know how we can change this? 

JIRA TEST
jiraimage1.jpg

JIRA PROD
jiraimage2.jpgjiraimage3.jpg
Thanks,
Layo

[Nic Brough -Adaptavist-]

Is that field a ranking type field?

[Johannes Seyfried]

No, its a rarely used customfield restricted to one project.

[Nic Brough -Adaptavist-]

Ok, what type of field is it? This error looks like you've got more than one value for a single-select field. You might have to delete one.

[Johannes Seyfried]

you're right, it's a single-select field. I'll have a look into this.

[Vasiliy Zverev]

It means that two values for customfield with id 10402 have the same id. 

If you use server version you can try to get doubled customfield values with this SQL:

Select
	customfieldvalue.ID
	, customfieldvalue.CUSTOMFIELD
from
	customfieldvalue
group by
	customfieldvalue.ID
	, customfieldvalue.CUSTOMFIELD
having
	COUNT(customfieldvalue.ID) > 1

I got similar troubles when inserted values into custom field via SQL.

[Nic Brough -Adaptavist-]

Exactly. Never change a JIRA database with SQL (unless you *fully* understand what you're doing. Which most people don't)

[Johannes Seyfried]

This query returns no results.