Two Projects, One sprint board - view the cards in sprint for both prjs but not backlog

[Sarah]

Hi all,

We are adding quite a few large features to our product.  We have created a couple of new projects (prj 2 & 3) to keep large pieces of work and related stories seperate from our main project (prj 1). 

I have shared the sprint board for Prj 1 between the projects by amending the filter in the sprint board settings to include the new projects, it works well. 

However I can now see all the cards in Prj 2 & 3 in Prj 1's backlog.

Is there a way I can keep Prj 1's backlog for only Prj 1 cards and allow Prj 2 & 3 issues to share the sprint board?

I think the solution is to create an entire new project and sprint board, thoughts please as to a better way.

[Jonas Andersson]

Best way is using mysql (if thats what you backend your JIRA with).

To see a list of customfields:

select ID, cfname from customfield;

To search for a custom field you know the name of:

select ID, cfname from customfield where cfname like '%location%';

To see the options of a specific customfield:

select * from customfieldoption where CUSTOMFIELD='id goes here';

So as an example:

mysql> select ID, cfname from customfield where cfname like '%locat%';

+-------+--------------------+

| ID    | cfname             |

+-------+--------------------+

| 10305 | Location           |

+-------+--------------------+

1 rows in set (0.00 sec)

mysql> select * from customfieldoption where CUSTOMFIELD='10305';

+-------+-------------+-------------------+----------------+----------+-------------+------------+----------+

| ID    | CUSTOMFIELD | CUSTOMFIELDCONFIG | PARENTOPTIONID | SEQUENCE | customvalue | optiontype | disabled |

+-------+-------------+-------------------+----------------+----------+-------------+------------+----------+

| 10100 |       10305 |             10501 |           NULL |        1 | Amsterdam   | NULL       | N        |

| 10101 |       10305 |             10501 |           NULL |        4 | Hong Kong   | NULL       | N        |

| 10102 |       10305 |             10501 |           NULL |        3 | Stockholm   | NULL       | N        |

| 10103 |       10305 |             10501 |           NULL |        2 | Wasa       | NULL       | Y        |

| 10104 |       10305 |             10501 |           NULL |        5 | Las Vegas        | NULL       | N        |

| 10200 |       10305 |             10501 |           NULL |        0 | Global      | NULL       | N        |

+-------+-------------+-------------------+----------------+----------+-------------+------------+----------+

[Jaime S]

If want to know which custom fields these are and if you have access to JIRA, you can:

1. Go to the custom fields page
2. Select one custom field
3. Click the 'cog icon' and hover your pointer over one of the options
4. Check the URL that appears on the bottom, it will say the custom field's ID
5. If the ID matcher one of those, that is the customer field
6. Otherwise, test a different custom field

If you have access to the database, you can check it there too.

Kind regards,
Jaime Kirch da Silveira
Atlassian Cloud Support

[Nic Brough -Adaptavist-]

They are custom fields that you have added to your system.  (Note some add-ons like Agile can create them too)

See https://confluence.atlassian.com/jira/adding-a-custom-field-185729521.html