Custom field on Cases screen is not updating when I set a value to it

Hi @Joe Schmucker   We should avoid including the Cache.Update(row) statement. With this statement, the system will continuously trigger of the FieldUpdated event in the same view and leads to the overflow exceptions.

I don’t see any issues with the above code, but can you try like below and confirm?

protected void CRCase_UsrRecordTypeID_FieldUpdated(PXCache cache, PXFieldUpdatedEventArgs e)
    {
        CRCase row = (CRCase)e.Row;
        if (row == null) return;

        CRCaseExt itemExt = row.GetExtension<CRCaseExt>();

        if (itemExt == null) return;

        itemExt.UsrServiceTypeID = null;
    }

@Naveen Boga  I did try that and a cache.Update on the FieldUpdated handler did crash the site. 

I changed to using the FieldUpdating handler and I found that cache.Update(row) caused an exception.

Using cache.Update(itemExt) works (sort of).  I will explain below.

My next step was to check for a default value from the maintenance table.  If there is a default = true, it updates the Service Type field.  YAY.

However, if I try to set it to null, it does not clear the field.  I was just told moments ago that every Record Type will be required to have a default value.  So, this code works and solves my issue:

        protected void CRCase_UsrRecordTypeID_FieldUpdating(PXCache cache, PXFieldUpdatingEventArgs e)
        {
            CRCase row = (CRCase)e.Row;
            if (row == null) return;

            CRCaseExt itemExt = PXCache<CRCase>.GetExtension<CRCaseExt>(row);

            if (itemExt == null) return;

            SSGCRRecordType sSGCRRecordType = SelectFrom<SSGCRRecordType>.Where<SSGCRRecordType.recordTypeCD.IsEqual<@P.AsString>>.View.Select(Base, e.NewValue);

            foreach (SSGCRServTypeRecTypeLinks link in SelectFrom<SSGCRServTypeRecTypeLinks>.
                InnerJoin<SSGCRRecordType>.On<SSGCRRecordType.recordTypeID.IsEqual<SSGCRServTypeRecTypeLinks.recordTypeID>>
                .Where<SSGCRServTypeRecTypeLinks.recordTypeID.IsEqual<@P.AsInt>>.View.Select(Base, sSGCRRecordType.RecordTypeID))
            {
                if (link.IsDefault == true)
                {
                    itemExt.UsrServiceTypeID = link.ServiceTypeID;
                }
            }
            cache.Update(itemExt);
            //cache.Update(row);
        }

Since there will always be a default in the maint table, this will always populate a value in the service type field.  I am putting code on the maintenance screen to require a default service type for each record type.

@Naveen Boga 

protected void CRCase_UsrRecordTypeID_FieldUpdated(PXCache cache, PXFieldUpdatedEventArgs e)
    {
        CRCase row = (CRCase)e.Row;
        if (row == null) return;

        CRCaseExt itemExt = row.GetExtension<CRCaseExt>();

        if (itemExt == null) return;

        itemExt.UsrServiceTypeID = null;
    }

I tried that too.  Many iterations ago.  :-)  I just tried that code again and it works (but only once).

Here is the really strange thing.  If you load the record onto the Cases screen, it WORKS ONE TIME.  It will clear the service type field the first time you change the record type field.  If you don’t save and change the RecordType field again, it doesn’t null the service type field.  So, it kind of works, but only the first time.

However, since I am now populating the field with a default value in the FieldUpdating, I don’t need to null the field.  It is strange that that doesn’t work.