How to change multi-level cascade field values

[Alik]

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

[Earl McCutcheon · Accepted solution]

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:

• https://community.atlassian.com/t5/Jira-Software-questions/Displaying-a-Date-Picker-Field-dynamically-based-on-change-in/qaq-p/928753

Regards,
Earl

[Alik]

Hi @Earl McCutcheon ,

Thanks for you answer.

Regards,

Alik

[Javier Carpenter]

"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.