Hi All,
I have created a projected DAC as follows.
[Serializable]
[PXCacheName("ProjectedSOLines")]
[PXProjection(
typeof(Select2<SOLine,
InnerJoin<SOOrder, On<SOLine.orderType, Equal<SOOrder.orderType>,
And<SOLine.orderNbr, Equal<SOOrder.orderNbr>>>>>), Persistent = true)]
public partial class ProjectedSOLines : IBqlTable
{
public abstract class orderNbr : PX.Data.BQL.BqlString.Field<orderNbr> { }
[PXDBString(15, IsKey = true, IsUnicode = true, InputMask = ">CCCCCCCCCCCCCCC", BqlField = typeof(SOOrder.orderNbr))]
[PXSelector(typeof(SOOrder.orderNbr))]
[PXUIField(DisplayName = "Order Nbr.", Visibility = PXUIVisibility.SelectorVisible, Enabled = false)]
//Other attributes like PXSelector
public virtual String OrderNbr { get; set; }
#region Status
public abstract class status : PX.Data.BQL.BqlString.Field<status> { }
[PXDBString(1, IsFixed = true, BqlField = typeof(SOOrder.status))]
[PXUIField(DisplayName = "Status", Visibility = PXUIVisibility.SelectorVisible, Enabled = false)]
[SOOrderStatus.List]
[PXDefault]
public virtual String Status { get; set; }
#endregion
#region Remark
public abstract class remark : PX.Data.BQL.BqlString.Field<remark> { }
[PXDBString(BqlField = typeof(SOLineExt.usrRemark))]
[PXUIField(DisplayName = "Remark")]
public virtual String Remark { get; set; }
#endregion
}
But for Some records Remark field shows wrong values as follows in the Grid which I created using Projected DAC.
Actual SOLine values for remark field as follows.
What did I do wrong here? Any help would be much appreciated.
Thanks.
Best answer by vardan22
View original