DAC created from SQL view returns empty fields in GI

Hi

Did you manage to resolve this?

Hi ​@jcox43 were you able to find a solution? Thank you!

One possibility is that your DAC does not look to have any key’s defined.  (looked at your project file) -    You need to add the IsKey=true to the fields that are true keys (for both interger and string based keys) . 

This is the exact result I get if I don’t have any keys defined for some of my views. 

example:

    #region InventoryID
    [PXDBInt(IsKey=true)]
    [PXUIField(DisplayName = "Inventory ID")]
    public virtual int? InventoryID { get; set; }
    public abstract class inventoryID : PX.Data.BQL.BqlInt.Field<inventoryID> { }
    #endregion

    #region Upc_count
    [PXDBInt()]
    [PXUIField(DisplayName = "Upc_count")]
    public virtual int? Upc_count { get; set; }
    public abstract class upc_count : PX.Data.BQL.BqlInt.Field<upc_count> { }
    #endregion

I also FORGOT to mention the view has to have COMPANYID column to work correctly (Which yours had) for others playing along at home.   Also don’t filter or filter where companyid > 0 the avoid snapshots.