Update to table in database

Question

Hi All a!localVariables(
 local!crFeesComments_cdt: rule!CR_FN_getModuleComments(
 crModuleComments: ri!crModuleComments_cdt,
 commentId_int: cons!CR_AS_COMMENT_IDS[1]
 ),
 local!crPricingApprovalComments_cdt: rule!CR_FN_getModuleComments(
 crModuleComments: ri!crModuleComments_cdt,
 commentId_int: cons!CR_AS_COMMENT_IDS[2]
 ),
 local!crFxRatesBuy_cdt: index(
 ri!crFxRatesFromDb_cdt,
 wherecontains(
 { 1, 2, 3 },
 index(
 ri!crFxRatesFromDb_cdt,
 "seqNumber_int",
 {}
 )
 ),
 {}
 ),
 local!crFxRatesSell_cdt: index(
 ri!crFxRatesFromDb_cdt,
 wherecontains(
 { 4, 5, 6 },
 index(
 ri!crFxRatesFromDb_cdt,
 "seqNumber_int",
 {}
 )
 ),
 {}
 ),
 {
 rule!CR_RT_displayInformativeNote(
 pageName_txt: cons!CR_TXT_SECTION_NAMES_TODISPLAY_AMOUNT[3]
 ),
 rule!CR_SC_AS_displayROCOverview(
 cif_int: ri!cif_int,
 systemRequestId_int: ri!systemRequestId_int,
 crRocOverview_cdt: ri!crRocOverview_cdt
 ),
 rule!CR_SC_AS_displayFeeDetails(
 isReadOnly_bool: ri!isReadOnly_bool,
 isActive_bool: ri!isActive_bool,
 crFeeDetails_cdt: ri!crFeeDetails_cdt
 ),
 rule!CR_RTF_UI_displayRichTextFieldEditorComponent(
 moduleId_int: ri!moduleId_int,
 crModuleComments_cdt: ri!crModuleComments_cdt,
 placeHolder_txt: { "please enter value" },
 cif_int: ri!cif_int,
 commentId_int: cons!CR_AS_COMMENT_IDS[1],
 instructions_txt: null,
 isReadOnly_bool: ri!isReadOnly_bool,
 inputComment_cdt: local!crFeesComments_cdt,
 requestId_int: ri!requestId_int,
 role_txt: ri!role_txt,
 label_txt: cons!CR_LAB_COMMENT,
 isRequired_bool: false(),
 value_txt: clean(
 rule!CR_APP_FN_cleanRichTextEditorString(
 index(
 rule!CR_FN_getModuleComments(
 crModuleComments: ri!crModuleComments_cdt,
 commentId_int: cons!CR_AS_COMMENT_IDS[1]
 ),
 "comment_txt",
 {}
 )
 )
 ),
 helpTooltip_txt: null,
 
 ),
 rule!CR_SC_AS_displayFXRates(
 isReadOnly_bool: ri!isReadOnly_bool,
 isActive_bool: ri!isActive_bool,
 crFxRatesBuy_cdt: local!crFxRatesBuy_cdt,
 crFxRatesSell_cdt: local!crFxRatesSell_cdt,
 preffered_txt: ri!preffered_txt
 ),
 rule!CR_SC_AS_displayTariffBanding(
 isReadOnly_bool: ri!isReadOnly_bool,
 crTariffBanding_cdt: ri!crTariffBanding_cdt
 ),
 rule!CR_SC_AS_displayPricingDetails(
 cif_int: ri!cif_int,
 isReadOnly_bool: ri!isReadOnly_bool,
 requestId_int: ri!requestId_int,
 crPricingApprovals_cdt: ri!crPricingApprovals_cdt,
 uploadedDocIds_int: ri!uploadedDocIds_int,
 moduleId_int: ri!moduleId_int,
 isDashboard_bool: ri!isDashboard_bool
 ),
 rule!CR_RTF_UI_displayRichTextFieldEditorComponent(
 moduleId_int: ri!moduleId_int,
 crModuleComments_cdt: ri!crModuleComments_cdt,
 placeHolder_txt: { "please enter value" },
 cif_int: ri!cif_int,
 commentId_int: cons!CR_AS_COMMENT_IDS[2],
 instructions_txt: null,
 isReadOnly_bool: ri!isReadOnly_bool,
 inputComment_cdt: local!crPricingApprovalComments_cdt,
 requestId_int: ri!requestId_int,
 role_txt: ri!role_txt,
 label_txt: cons!CR_LAB_COMMENT,
 isRequired_bool: ri!isActive_bool,
 value_txt: clean(
 rule!CR_APP_FN_cleanRichTextEditorString(
 index(
 rule!CR_FN_getModuleComments(
 crModuleComments: ri!crModuleComments_cdt,
 commentId_int: cons!CR_AS_COMMENT_IDS[2]
 ),
 "comment_txt",
 {}
 )
 )
 ),
 helpTooltip_txt: rule!CR_DSC_getAccountStrategyToolTipsByFields(
 FieldName: cons!CR_LAB_ACCOUNT_STRATEGY_ALL_FIELDS[6]
 )
 ),
 a!columnsLayout(
 showWhen: if(
 rule!APN_isBlank(ri!isReadOnly_bool),
 true,
 not(ri!isReadOnly_bool)
 ),
 columns: {
 a!columnLayout(
 width: "AUTO",
 contents: {
 rule!CR_UI_displayMessageCard(save_dt: ri!save_dt)
 }
 ),
 a!columnLayout(
 width: "NARROW",
 contents: {
 a!buttonArrayLayout(
 align: "END",
 buttons: {
 a!buttonWidget(
 label: cons!APN_TXT_SAVE_DRAFT,
 value: cons!APN_TXT_SAVE,
 submit: true(),
 saveInto: {
 a!save(
 ri!buttonAction_txt,
 cons!APN_TXT_SAVE_DRAFT
 ),
 a!save(
 ri!crFxRatesFromDb_cdt,
 local!crFxRatesBuy_cdt
 ),
 a!save(
 ri!crFxRatesFromDb_cdt,
 append(
 ri!crFxRatesFromDb_cdt,
 local!crFxRatesSell_cdt
 )
 ),
 rule!CR_FN_storeModuleStatusHistory(
 moduleRecommendationStatus_cdt: ri!moduleRecommendationStatus_cdt,
 requestId_int: ri!requestId_int,
 cif_int: ri!cif_int,
 role_txt: ri!role_txt,
 originalExpiry_dt: ri!originalExpiry_dt,
 moduleStatus_txt: cons!CR_AS_MODULE_STATUS[1],
 crModuleStatusHistory_cdt: ri!crModuleStatusHistory_cdt,
 moduleId_int: ri!moduleId_int,
 workflowId_int: ri!workflowId_int,
 buttonAction_txt: cons!APN_TXT_SAVE_DRAFT,
 currentNetROC_dec: ri!crRocOverview_cdt.currentNetRoc_dec
 ),
 rule!CR_FN_AS_storeFeeDetails(
 crFeeDetails_cdt: ri!crFeeDetails_cdt,
 requestId_int: ri!requestId_int,
 cif_int: ri!cif_int,
 moduleId_int: ri!moduleId_int
 ),
 rule!CR_FN_AS_storeFXRates(
 crFxRatesFromDb_cdt: ri!crFxRatesFromDb_cdt
 ),
 rule!CR_FN_AS_storeTariffBanding(
 crTariffBanding_cdt: ri!crTariffBanding_cdt
 ),
 rule!CR_FN_AS_storePricingApprovals(
 crPricingApprovals_cdt: ri!crPricingApprovals_cdt
 ),
 a!save(
 ri!docSectionName_txt,
 cons!CR_AS_SECTION_NAME[1]
 ),
 a!writeToMultipleDataStoreEntities(
 valuesToStore: {
 a!entityData(
 entity: cons!CR_ENTITY_MODULE_COMMENTS,
 data: ri!crModuleComments_cdt
 ),
 a!entityData(
 entity: cons!CR_ENTITY_MODULE_STATUS_HISTORY,
 data: ri!crModuleStatusHistory_cdt
 ),
 a!entityData(
 entity: cons!CR_ENTITY_AS_FEE_DETAILS,
 data: ri!crFeeDetails_cdt
 ),
 a!entityData(
 entity: cons!CR_ENTITY_AS_FX_RATES,
 data: ri!crFxRatesFromDb_cdt
 ),
 a!entityData(
 entity: cons!CR_ENTITY_AS_TARIFF_BANDING,
 data: ri!crTariffBanding_cdt
 ),
 a!entityData(
 entity: cons!CR_ENTITY_AS_PRICING_APPROVALS,
 data: ri!crPricingApprovals_cdt
 )
 },
 onSuccess: {
 a!save(
 ri!crModuleComments_cdt,
 index(fv!storedValues, 1, "data", {})
 ),
 a!save(
 ri!crModuleStatusHistory_cdt,
 index(fv!storedValues, 2, "data", {})
 ),
 a!save(
 ri!crFeeDetails_cdt,
 index(fv!storedValues, 3, "data", {})
 ),
 a!save(
 ri!crFxRatesFromDb_cdt,
 index(fv!storedValues, 4, "data", {})
 ),
 a!save(
 ri!crTariffBanding_cdt,
 index(fv!storedValues, 5, "data", {})
 ),
 a!save(
 ri!crPricingApprovals_cdt,
 index(fv!storedValues, 6, "data", {})
 ),
 a!save(
 ri!moduleRecommendationStatus_cdt,
 rule!CR_FN_getModuleStatusHistoryByStatus(
 crModuleStatusHistory_cdt: ri!crModuleStatusHistory_cdt
 )
 ),
 a!save(
 local!crFeesComments_cdt,
 rule!CR_FN_getModuleComments(
 crModuleComments: ri!crModuleComments_cdt,
 commentId_int: cons!CR_AS_COMMENT_IDS[1]
 )
 ),
 a!save(
 local!crPricingApprovalComments_cdt,
 rule!CR_FN_getModuleComments(
 crModuleComments: ri!crModuleComments_cdt,
 commentId_int: cons!CR_AS_COMMENT_IDS[2]
 )
 ),
 a!save(ri!save_dt, now())
 }
 )
 },
 style: "NORMAL",
 validate: false()
 ),
 a!buttonWidget(
 label: cons!APN_TXT_SAVE,
 value: cons!APN_TXT_SAVE,
 submit: true(),
 saveInto: {
 a!save(ri!buttonAction_txt, cons!APN_TXT_SAVE),
 a!save(
 ri!crFxRatesFromDb_cdt,
 local!crFxRatesBuy_cdt
 ),
 a!save(
 ri!crFxRatesFromDb_cdt,
 append(
 ri!crFxRatesFromDb_cdt,
 local!crFxRatesSell_cdt
 )
 ),
 rule!CR_FN_storeModuleStatusHistory(
 moduleRecommendationStatus_cdt: ri!moduleRecommendationStatus_cdt,
 requestId_int: ri!requestId_int,
 cif_int: ri!cif_int,
 role_txt: ri!role_txt,
 originalExpiry_dt: ri!originalExpiry_dt,
 moduleStatus_txt: cons!CR_AS_MODULE_STATUS[1],
 crModuleStatusHistory_cdt: ri!crModuleStatusHistory_cdt,
 moduleId_int: ri!moduleId_int,
 workflowId_int: ri!workflowId_int,
 buttonAction_txt: cons!APN_TXT_SAVE,
 currentNetROC_dec: ri!crRocOverview_cdt.currentNetRoc_dec
 ),
 rule!CR_FN_AS_storeFeeDetails(
 crFeeDetails_cdt: ri!crFeeDetails_cdt,
 requestId_int: ri!requestId_int,
 cif_int: ri!cif_int,
 moduleId_int: ri!moduleId_int
 ),
 rule!CR_FN_AS_storeFXRates(
 crFxRatesFromDb_cdt: ri!crFxRatesFromDb_cdt
 ),
 rule!CR_FN_AS_storeTariffBanding(
 crTariffBanding_cdt: ri!crTariffBanding_cdt
 ),
 rule!CR_FN_AS_storePricingApprovals(
 crPricingApprovals_cdt: ri!crPricingApprovals_cdt
 ),
 a!save(
 ri!docSectionName_txt,
 cons!CR_AS_SECTION_NAME[1]
 ),
 a!writeToMultipleDataStoreEntities(
 valuesToStore: {
 a!entityData(
 entity: cons!CR_ENTITY_MODULE_COMMENTS,
 data: ri!crModuleComments_cdt
 ),
 a!entityData(
 entity: cons!CR_ENTITY_MODULE_STATUS_HISTORY,
 data: ri!crModuleStatusHistory_cdt
 ),
 a!entityData(
 entity: cons!CR_ENTITY_AS_FEE_DETAILS,
 data: ri!crFeeDetails_cdt
 ),
 a!entityData(
 entity: cons!CR_ENTITY_AS_FX_RATES,
 data: ri!crFxRatesFromDb_cdt
 ),
 a!entityData(
 entity: cons!CR_ENTITY_AS_TARIFF_BANDING,
 data: ri!crTariffBanding_cdt
 ),
 a!entityData(
 entity: cons!CR_ENTITY_AS_PRICING_APPROVALS,
 data: ri!crPricingApprovals_cdt
 )
 },
 onSuccess: {
 a!save(
 ri!crModuleComments_cdt,
 index(fv!storedValues, 1, "data", {})
 ),
 a!save(
 ri!crModuleStatusHistory_cdt,
 index(fv!storedValues, 2, "data", {})
 ),
 a!save(
 ri!crFeeDetails_cdt,
 index(fv!storedValues, 3, "data", {})
 ),
 a!save(
 ri!crFxRatesFromDb_cdt,
 index(fv!storedValues, 4, "data", {})
 ),
 a!save(
 ri!crTariffBanding_cdt,
 index(fv!storedValues, 5, "data", {})
 ),
 a!save(
 ri!crPricingApprovals_cdt,
 index(fv!storedValues, 6, "data", {})
 ),
 a!save(
 ri!moduleRecommendationStatus_cdt,
 rule!CR_FN_getModuleStatusHistoryByStatus(
 crModuleStatusHistory_cdt: ri!crModuleStatusHistory_cdt
 )
 ),
 a!save(
 local!crFeesComments_cdt,
 rule!CR_FN_getModuleComments(
 crModuleComments: ri!crModuleComments_cdt,
 commentId_int: cons!CR_AS_COMMENT_IDS[1]
 )
 ),
 a!save(
 local!crPricingApprovalComments_cdt,
 rule!CR_FN_getModuleComments(
 crModuleComments: ri!crModuleComments_cdt,
 commentId_int: cons!CR_AS_COMMENT_IDS[2]
 )
 ),
 a!save(ri!save_dt, now())
 }
 )
 },
 style: "NORMAL",
 validate: true
 )
 }
 )
 }
 )
 }
 )
 }
) 
 
 I am trying to update one value to the table ,Field name is preferred_txt created in child UI called in the code which is pasted above . 
 I need to write that preferred_txt value to the db on save and save draft buttons. How can i do that please let me know the solution. 
 note: preferred_txt is a dropdown value. 
 
 that preferred_txt is called here in the above code .Let me know if anybody has questions and please give me the solution ASAP.

Thanks in advance

Mike Schmitt · Answer

From your screenshot, first you're overwriting "ri!crFxRatesFromDb_cdt" with the value of "local!crFxRatesFromDb_cdt" (which is, i assume, intentional and correct) 
 Then the very next a!save statement, you're overwriting the value AGAIN but this time trying to overwrite it with the (plaintext?!?) value of "ri!preffered_txt" 
 You'll have to straighten out this mess first. I'm not sure what you're trying to do overall but this won't work as-is.