Can I use PXForeignReference on a DAC extension to ensure data integrity?

Question

I am attempting to use PXForeignReference on a DAC extension to ensure the field is set to null when the referenced document is deleted. It published fine but doesn’t work. Is this possible?

(NOTE: at the moment, ReferenceBehavior is ‘Restrict’ which should throw an exception upon deleting)

public class DSDPMCostBudget_Ext : PXCacheExtension<PX.Objects.PM.PMCostBudget>
{
    public static bool IsActive() => true;

    #region UsrPDPOType
    [PXDBString(2, IsUnicode = true)]
    [POOrderType.List()]
    [PXDefault(POOrderType.ProjectDropShip, PersistingCheck = PXPersistingCheck.Nothing)]
    [PXUIField(DisplayName = "PO Type")]
    public virtual string UsrPDPOType { get; set; }
    public abstract class usrPDPOType : BqlString.Field<usrPDPOType> { }
    #endregion

    #region UsrPDPONbr
    [PXDBString(15, IsUnicode = true)]
    [PO.RefNbr(typeof(Search2<POOrder.orderNbr,
        LeftJoinSingleTable<Vendor, On<POOrder.vendorID, Equal<Vendor.bAccountID>,
        And<Match<Vendor, Current<AccessInfo.userName>>>>>,
        Where<POOrder.orderType, Equal<Optional<usrPDPOType>>,
        And<Vendor.bAccountID, IsNotNull>>,
        OrderBy<Desc<POOrder.orderNbr>>>), Filterable = true)]
    // Here's the foreign reference
    [PXForeignReference(typeof(CompositeKey<
        Field<usrPDPOType>.IsRelatedTo<POOrder.orderType>, 
        Field<usrPDPONbr>.IsRelatedTo<POOrder.orderNbr>>), ReferenceBehavior.Restrict)]
    [PXUIField(DisplayName = "PO Nbr")]
    public virtual string UsrPDPONbr { get; set; }
    public abstract class usrPDPONbr : BqlString.Field<usrPDPONbr> { }
    #endregion
}

darylbowman · Accepted Answer

Turns out, if I knew how to use foreign references in the first place, it would have been working all along.

I forgot to add [PXReferentialIntegrityCheck] to POOrder.

For the next person, I did that like this, because for whatever reason, you can’t use [PXReferentialIntegrityCheck] with the CacheAttached event.

public class DSDPOOrder_Ext : PXCacheExtension<PX.Objects.PO.POOrder>
{
	public static bool IsActive() => true;

    #region OrderNbr
    [PXMergeAttributes(Method = MergeMethod.Append)]
    [PXReferentialIntegrityCheck]
    public string OrderNbr { get; set; }
    #endregion

}

Thanks @Brian Stevens (source)

Brian Stevens · Answer

Turns out, if I knew how to use foreign references in the first place, it would have been working all along.I forgot to add[PXReferentialIntegrityCheck] to POOrder.For the next person, I did that like this, because for whatever reason, you can’t use[PXReferentialIntegrityCheck] with the CacheAttached event.public class DSDPOOrder_Ext : PXCacheExtension<PX.Objects.PO.POOrder>{public static bool IsActive() => true;    #region OrderNbr    [PXMergeAttributes(Method = MergeMethod.Append)]    [PXReferentialIntegrityCheck]    public string OrderNbr { get; set; }    #endregion}Thanks@Brian Stevens(source)Glad my blog was able to help. You may know, but for those that may be wondering “why” for PXReferentialIntegrityCheck on CacheAttached…Keep in mind that CacheAttached is “from within this graph”. That means, it is basically an optional usage. Integrity is integrity in season and out of season, so to speak. As best I can tell, you can’t have integrity “when you feel like it” like within only one specific graph. You need it in the basicstructure of the DAC. As long as the DAC extension is active in this case, it will apply. If the DACisn’t active, the field you want to do an integrity check, for all practical purposes, does not exist. When it is active, it always must pass the integrity check, always.

Can I use PXForeignReference on a DAC extension to ensure data integrity?

4 replies

Reply

Most helpful members this week

Cookie policy

Cookie settings

Reply

Related topics

Freshdesk agent view of tickets customization question about contact detailsicon

Issue with Freshdesk and Freshsales Integrationicon

Trending topics in Freshdesk support- Edition 2, July 16

Marketplace Navigator: Uncovering the Top Communication Apps

The New FreshCaller - 6 Things you should know!!!

Most helpful members this week

Sign up

Social Login

Login to the community

Social Login

Scanning file for viruses.

This file cannot be downloaded

Cookie policy

Cookie settings