Add an Address to the Branch

Question

I am trying to add another address to a Branch in 21.203, similar to the how the DefAddress works. I have extended the Branch DAC and added the field to the extension. I also tried extending the BAccount DAC and table to get this to work but, nothing is working so far. The Address record is being created in the Address table but, the PXDBChildIdentity attribute doesn't seem to be sending back the ID to the Address record. On the screen, when I enter the values for the address, and click Save, all of the values are wiped out and the custom field (UsrCustomAddress) is never populated.

#region UsrCustomAddress
[PXDBInt()]
[PXUIField(DisplayName="Custom Address")]
[PXDBChildIdentity(typeof(Address.addressID))]
public virtual Int32? UsrCustomAddress { get; set; }
public abstract class usrCustomAddress : PX.Data.BQL.BqlInt.Field<usrCustomAddress> { }
#endregion

And, then, I added the View to the BranchMaint extension.

<code>
namespace PX.Objects.CS
{
  public class BranchMaint_Extension : PXGraphExtension<BranchMaint>
  {

  public PXSelect<Address, Where<Address.bAccountID, Equal<Current<BAccount.bAccountID>>, 
  And<Address.addressID, Equal<Current<BAccountExt.usrCustomAddress>>>>> CustomAddress;
 }
 }
</code>

Not sure what I'm missing?

TIA!

Answer 1

I handled this by manually calling .Insert() on the specific Data View in the row inserting event and writing it to the field. PXDBChildIdentity then can update the field with the real identity value (on row persist) after the link is established.

    protected void _(Events.RowInserting<Branch> e)
    {
        if (e.Row is null) return;
        Address newAddress = CustomAddress.Insert();

        BranchExt ext = e.Cache.GetExtension<BranchExt >(e.Row);
        ext.UsrCustomAddress = newAddress.AddressID;
    }

If anyone knows how to do this in an attribute id love to know. Note, this will only work for newly created records. Any existing records would not have a row inserting event fire and fill your custom field. You need to backfill the data with SQL or just a temporary custom action that you can invoke this code manually.