When in a story we have a 'Project' field and I need to exclude Closed Projects

Roberta B
Mega Guru

When in a Story form, we have a 'Project' field that is a Lookup List and currently it pulls all Projects, no matter what state the Project is in. 

We need to exclude any Projects that are in a 'Closed Complete', 'Closed Incomplete' and 'Closed Skipped' states.

 

Here is the Story Form:

RobertaB_0-1669139067653.png

 

Here is the Field Label:

RobertaB_2-1669139775894.png

 

Here is the current Dictionary Entry:

RobertaB_3-1669139869859.png

 

Here is the table info for the 'Project' field:

RobertaB_1-1669139091454.png

 

I'm not a developer or experienced scripter, but can manage basic administration/configuration tasks, so any assistance with detailed info would be appreciated.

 

1 ACCEPTED SOLUTION
7 REPLIES 7

Thank you for your response @Saurav11 .    

 

I followed the easier solution provided by Mike_R below, but appreciate you responding!

Thank you @Mike_R !    

This Reference qual worked:

javascript:ScrumSecurityManager.getStoryDotProject(current)+'^active=true';