Search Custom Field for PXUnboundDefault

Hi @jayson 

The field you are adding is database bound because you are using PXDBInt. Therefore, the value will be stored in the SOShipment table and you do not need retrieve the value via PXUnboundDefault

    [PXUnboundDefault(typeof(Search<SOOrderExt.usrBoard,
      Where<SOOrder.orderNbr, Equal<Current<SOLine.orderNbr>>,
          And<SOOrder.orderType, Equal<Current<SOLine.orderType>>>>>))]

PXUnboundDefault is used to default unbound columns if you want to execute the query during the fetch of the record, for each record. A more efficient way to do it is using PXDBScalar.

I would simplify the class as follow:

namespace MyCustom
{
  public class SOShipmentExt : PXCacheExtension<PX.Objects.SO.SOShipment>
  {
    #region UsrSOBoard

    [PXDBInt]
    [PXIntList(new int[] {0, 1}, new string[] {"WMS", "MTM"})]
    [PXUIField(DisplayName = "Board")]
    public virtual int? UsrSOBoard { get; set; }

    public abstract class usrSOBoard : BqlType<IBqlInt, int>.Field<usrSOBoard> { }

    #endregion
  }
}

Make sure you added the custom field to the table in the Custom Package:

Hope this can help

Hi @jayson 

The field you are adding is database bound because you are using PXDBInt. Therefore, the value will be stored in the SOShipment table and you do not need retrieve the value via PXUnboundDefault

    [PXUnboundDefault(typeof(Search<SOOrderExt.usrBoard,
      Where<SOOrder.orderNbr, Equal<Current<SOLine.orderNbr>>,
          And<SOOrder.orderType, Equal<Current<SOLine.orderType>>>>>))]

PXUnboundDefault is used to default unbound columns if you want to execute the query during the fetch of the record, for each record. A more efficient way to do it is using PXDBScalar.

 

I would simplify the class as follow:

namespace MyCustom
{
  public class SOShipmentExt : PXCacheExtension<PX.Objects.SO.SOShipment>
  {
    #region UsrSOBoard

    [PXDBInt]
    [PXIntList(new int[] {0, 1}, new string[] {"WMS", "MTM"})]
    [PXUIField(DisplayName = "Board")]
    public virtual int? UsrSOBoard { get; set; }

    public abstract class usrSOBoard : BqlType<IBqlInt, int>.Field<usrSOBoard> { }

    #endregion
  }
}

Make sure you added the custom field to the table in the Custom Package:

 

Hope this can help

What I really want to do is to be able to add “Board” a custom field of Sales order into Process Shipments just like this one:
 

namespace MyCustom
{
	public sealed class SOShipmentExt : PXCacheExtension<SOShipment>
	{
		#region UsrSOBoard

		[PXInt]
		[PXIntList(new int[] { 0, 1 }, new string[] { "WMS", "MTM" })]
		[PXUIField(DisplayName = "Board")]
		[PXDBScalar(typeof(Search2<SOOrderExt.usrBoard,
			InnerJoin<SOOrderShipment, 
				On<SOOrder.orderNbr, Equal<SOOrderShipment.orderNbr>, 
					And<SOOrder.orderType, Equal<SOOrderShipment.orderType>>>>,
		  Where<SOOrderShipment.shipmentNbr, Equal<Current<SOShipment.shipmentNbr>>>>))]
		public int? UsrSOBoard { get; set; }

		public abstract class usrSOBoard : BqlType<IBqlInt, int>.Field<usrSOBoard> { }

		#endregion
	}
}

Thank you so much! I just changed PXDBScalar to PXUnboundDefault in your code and it is working perfectly now.