#2865 Custom demographic extensions broken

[Peter HC]

Custom demographic extensions broken in trunk so that the update fails due to the new demographicExt unique key preventing a duplicate entry

To reproduce set the following properties and try to save or update a demographic

demographicExt = User Date|Study Subject|Band no

demographicExtForm = <input type="text" name="User_Date" id="User_Date" value="" size="10" readonly="">|<select name="Study_Subject"><option value="">---Select---</option><option value="Yes">Yes</option><option value="No">No</option></select>|<input type="text" name="Band_no" value="">

demographicExtJScript = <script type="text/javascript">Calendar.setup({ inputField : "User_Date", ifFormat : "%Y/%m/%d", showsTime :false, button : "User_Date_cal", singleClick : true, step : 1 });</script>

[Peter HC]

• Description has changed:

Diff:

--- old
+++ new
@@ -1,9 +1,9 @@
-Custom demographic extensions broken in trunk so that either the value does not update, or the update fails due to the new demographicExt unique key preventing a duplicate entry
+Custom demographic extensions broken in trunk so that the update fails due to the new demographicExt unique key preventing a duplicate entry

 To reproduce set the following properties and try to save or update a demographic

-demographicExt = User Date|Study Subject|Band Number
+demographicExt = User Date|Study Subject|Band no

-demographicExtForm = <input type="text" name="User Date" id="user_date" value="" size="10" readonly><img src="../images/cal.gif" id="user_date_cal">|<select name="Study_Subject"><option value="">---Select---</option><option value="Yes">Yes</option><option value="No">No</option></select>|<input type="text" name="Band_no" value=""/>
+demographicExtForm = <input type="text" name="User_Date" id="User_Date" value="" size="10" readonly><img src="../images/cal.gif" id="User_Date_cal">|<select name="Study_Subject"><option value="">---Select---</option><option value="Yes">Yes</option><option value="No">No</option></select>|<input type="text" name="Band_no" value=""/>

-demographicExtJScript = <script type="text/javascript">Calendar.setup({ inputField : "user_date", ifFormat : "%Y/%m/%d", showsTime :false, button : "user_date_cal", singleClick : true, step : 1 });</script>
+demographicExtJScript = <script type="text/javascript">Calendar.setup({ inputField : "User_Date", ifFormat : "%Y/%m/%d", showsTime :false, button : "User_Date_cal", singleClick : true, step : 1 });</script>

[Gregory Dernis]

Please provide step-by-step instructions.

[Tan]

I encountered the same bug

See fix:

https://source.oscartools.org:8080/#/c/10726/