New and Improved 3.13 Beta. Highlights: Shareable filters and dashboards and lots of other goodies. Any feedback can be raised as JIRA issues in the JIRA project.
Issue Details (XML | Word | Printable)

Key: JRA-5657
Type: Bug Bug
Status: Closed Closed
Resolution: Duplicate
Priority: Blocker Blocker
Assignee: Unassigned
Reporter: Kevin Ross
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
JIRA

Cascading select - parent/child mismatched on edit/create screen

Created: 13/Jan/05 04:54 PM   Updated: 30/Jul/06 07:35 PM
Component/s: Custom Fields (new types)
Affects Version/s: 3.0.2
Fix Version/s: None

Time Tracking:
Not Specified

Environment: 3.0.2-#74
Issue Links:
Reference
 

Participants: Kevin Ross and Mark Chaimungkalanont [Atlassian]
Since last comment: 3 years, 22 weeks, 5 days ago
Resolution Date: 14/Mar/05 11:04 PM
Labels:


 Description  « Hide
We have just experienced very strange behavior.

A child option was being added to a custom cascading select, and all child options now appear under a different parent on the edit issue page.

Note that on the ‘Edit Custom Field Options’ page, ironically all of the fields are appropriately aligned with the parent option.

At the same time, a custom user field was marked as required, now all the data is not appearing.

Please help, this is a huge problem.



 All   Comments   Work Log   Change History      Sort Order: Ascending order - Click to sort in descending order
Kevin Ross added a comment - 13/Jan/05 04:54 PM
Data for the configuration of the custom field appears correctly in the database. I have verified the data with the following queries. So it appears that the defect is the create new/edit issue page.

Here are the queries I used to verify the custom field data:

– child
select distinct
(select customValue from customfieldoption where id = cfo.parentoptionid) as parentOption,
cfo.*,
'------',
cv.*,
'------',
cf.*
from
customfieldoption cfo, customfieldvalue cv, customfield cf
where
cv.customfield = 10102 and – application component
– cv.issue = issueId and
cv.customfield = cfo.customfield and
cfo.id = to_number(cv.stringvalue) and
cf.id = cv.customfield and
cv.parentkey is not null
order by cfo.parentoptionid, cfo.customvalue

– parent?

select
cfo.*,
'------',
cv.*,
'------',
cf.*
from
customfieldoption cfo, customfieldvalue cv, customfield cf
where
cv.customfield = 10102 and
– cv.issue = issueId and
cv.customfield = cfo.customfield and
cfo.id = to_number(cv.stringvalue) and
cf.id = cv.customfield and
cv.parentkey is null
order by cfo.customvalue


Kevin Ross added a comment - 13/Jan/05 04:57 PM
Attached is the html from a problem edit page. The first item in question is the cascading field customfield_10102. Child options for parent <option value="10110">3.8</option>

should include 10114, 10115, 10117, etc, but only include 'none' and 'please select'

It is clear in the attachment that the fields are in the html


Kevin Ross added a comment - 13/Jan/05 04:59 PM
Current behavior is with Firefox 1.0 preview: Mozilla/5.0 (Windows; U; Windows NT 5.1; rv:1.7.3) Gecko/20041001 Firefox/0.10.1

Verified same behavior with IE 6.0.28.00.1106.xpsp2.030618-0119


Kevin Ross added a comment - 13/Jan/05 05:05 PM
Utilizing the standalone distribution.

Mark Chaimungkalanont [Atlassian] added a comment - 16/Jan/05 06:27 PM
Kevin,

Sorry about the delay. The problem lies with making the cascading select mandatory in 3.0.2 (see JRA-5010). The immediate workaround is not make cascading fields not mandatory. This will allow acceptable data to be entered in your system immediately.

You should then upgrade to 3.0.3 immediately. Please let us know how this goes, especially if the workaround still does not work.

Cheers

Mark C


Mark Chaimungkalanont [Atlassian] added a comment - 14/Mar/05 11:04 PM
Tracked as part of JRA-5010