How to change multi-level cascade field values

Alik
Contributor
February 27, 2020

Hi all,

I need to create new multi cascade custom field in my Jira instance (Jira server 7.12), but I need the help, because in cascade field documentation I can't find necessary information regarding my question.

I need one check list (containing 5 client names) and accordingly date pickers per each client name, to choose date (dates can be different for each client).

If possible I want to select more that one client name with accordingly date/time.

If I am not mistaken cascade field are using SQL table data to determine check list. I don't know how to create or configure it

 

For example

Select OptionName from "table name" where FieldName = 'field name'

Thanks in advance,

Regards,
Alik

 

2 answers

1 accepted

1 vote
Answer accepted
Earl McCutcheon
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
March 4, 2020

Hello @Alik ,

A "Cascading Select List"  custom field is applicable to select a static preset value from an option list configured for the field, and does not have the capability of adding in a dynamically set date picker value to the field options. 

An alternative option for this would be to look into a add-on that would allow two separate fields to be set based on the values in the originating field as discussed in this post:

Regards,
Earl
Alik
Contributor
March 5, 2020

Hi @Earl McCutcheon ,

Thanks for you answer.

Regards,

Alik

Like Earl McCutcheon likes this
0 votes
Javier Carpenter
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
November 19, 2024

"Hi Alik,

To achieve your goal in Jira Server, you would need to use custom development or a marketplace app as Jira's native cascading fields don't support linking each option to a separate date picker directly. Here's how you could approach it:

  1. Custom Development:

    • Use a custom plugin or scripting tool like ScriptRunner to extend Jira functionality.
    • You can create a custom field type where selecting multiple clients dynamically generates corresponding date pickers.
    • This will likely involve using JavaScript for the frontend and database queries for backend data.
  2. Marketplace Apps:

    • Consider apps like Dynamic Forms or CustomField Suite from the Atlassian Marketplace. These tools allow you to configure dynamic fields, making it easier to implement your checklist and date pickers without custom coding.
  3. SQL Configuration:

    • If you’re confident with direct SQL, ensure you have a backup before modifying database values. You can use the query you mentioned to populate options but configure it to ensure compatibility with Jira's structure and schema.

Suggest an answer

Log in or Sign up to answer