Hello community. I had a question on a customization project I am working on. I have the code below where I am joining to quite a few other tables. When I am working in the code, am I able to reference the joined data or only the primary table? When I try to get Orders.Current to work it is only for SOOrder. Hoping I can somehow reference the data from the joins in my Orders view.
public PXFilteredProcessingJoin<SOOrder, RecertificationFilter,
InnerJoin<SOLine,
On<SOLine.orderType, Equal<SOOrder.orderType>,
And<SOLine.orderNbr, Equal<SOOrder.orderNbr>,
And<SOLine.orderType.IsEqual<SOOperation.receipt>>>>,
InnerJoin<SOShipLine,
On<SOLine.orderType, Equal<SOShipLine.origOrderType>,
And<SOLine.orderNbr, Equal<SOShipLine.origOrderNbr>,
And<SOShipLine.inventoryID, Equal<SOLine.inventoryID>,
And<SOShipLine.origLineNbr, Equal<SOLine.lineNbr>,
And<SOShipLine.lotSerialNbr, Equal<SOLine.lotSerialNbr>>>>>>,
LeftJoin<SOShipment,
On<SOShipment.shipmentNbr, Equal<SOShipLine.shipmentNbr>,
And<SOShipment.shipmentType, Equal<SOShipLine.shipmentType>>>,
LeftJoin<OrderTransfer,
On<OrderTransfer.orderNbr, Equal<SOShipmentExt.usrToTransferNbr>>,
LeftJoin<PX.Objects.SO.SOOrderShipment,
On<PX.Objects.SO.SOOrderShipment.orderNbr, Equal<OrderTransfer.OrderNbr>>,
LeftJoin<TransferLine,
On<TransferLine.orderNbr, Equal<OrderTransfer.orderNbr>,
And<TransferLine.OrderType,Equal<OrderTransfer.OrderType>>>,
LeftJoin<TransferShipment,
On<TransferShipment.inventoryID, Equal<TransferLine.inventoryID>,
And<TransferShipment.lineNbr, Equal<TransferLine.lineNbr>,
And<TransferShipment.lotSerialNbr, Equal<TransferLine.lotSerialNbr>>>>,
LeftJoin<INTran,
On<INTran.refNbr, Equal<PX.Objects.SO.SOOrderShipment.invtRefNbr>,
And<INTran.inventoryID, Equal<TransferLine.inventoryID>,
And<INTran.origLineNbr, Equal<TransferShipment.lineNbr>,
And<INTran.lotSerialNbr, Equal<TransferLine.lotSerialNbr>>>>>>>>>>>>>, Where<SOOrderExt.usrRecertStatus.IsEqual<RecertificationFilter.action.FromCurrent>.And<SOOrder.orderType.IsEqual<SOOrderTypeConstants.rmaOrder>>>> Orders;
public Recertifications()
{
Orders.SetProcessCaption("Process");
Orders.SetProcessAllCaption("Process All");
Orders.SetProcessDelegate(CreateTransferOrders);
}
protected void RecertificationFilter_RowUpdated(PXCache cache, PXRowUpdatedEventArgs e)
{
var row = (RecertificationFilter)e.Row;
Orders.View.RequestRefresh();
}
[Serializable]
[PXHidden]
[PXCacheName("Filter")]
public class RecertificationFilter : PXBqlTable, IBqlTable
{
#region Action
[PXString(10, IsUnicode = true)]
[PXUIField(DisplayName = "Action")]
[PXStringList(new string[] { "RECEIPT", "TRANSFER", "SHIPMENT", "RECERT" }, new string[] { "Create Transfer", "Create Shipment", "Complete Transfer", "Receive Recertifications" })]
public virtual string Action { get; set; }
public abstract class action : PX.Data.BQL.BqlString.Field<action> { }
#endregion
}
[Serializable]
[PXCacheName("OrderTransfer")]
public class OrderTransfer : SOOrder
{
public new abstract class OrderNbr : PX.Data.IBqlField { }
public new abstract class OrderType : PX.Data.IBqlField { }
public new abstract class UsrFromShipmentNbr : PX.Data.IBqlField { }
}
[Serializable]
[PXCacheName("TransferShipment")]
public class TransferShipment : SOShipLine
{
public new abstract class OrigOrderNbr : PX.Data.IBqlField { }
public new abstract class OrigOrderType : PX.Data.IBqlField { }
public new abstract class ShipmentNbr : PX.Data.IBqlField { }
public new abstract class InventoryID : PX.Data.IBqlField { }
public new abstract class LineNbr : PX.Data.IBqlField { }
public new abstract class LotSerialNbr : PX.Data.IBqlField { }
}
[PXCacheName("TransferLine")]
public class TransferLine : SOLine
{
public new abstract class OrderNbr : PX.Data.IBqlField { }
public new abstract class OrderType : PX.Data.IBqlField { }
public new abstract class InventoryID : PX.Data.IBqlField { }
public new abstract class LineNbr : PX.Data.IBqlField { }
public new abstract class LotSerialNbr : PX.Data.IBqlField { }
}