PXSelector not allowing to save Record (Section ID not found in the System).

Hi @MoulaliShaik79 

I too have a customization where I am using a selector field with similar details and attributes and that is working as expected for me.

Can you please share your DAC, Graph and aspx code pieces so we can verify with the same.

Hi @vivekm,

Hope you are doing good, please find the attachment.

Thanks,

Moulali Shaik.

Hi @MoulaliShaik79   Is Section ID field is KEY field?  If yes, please add attribute IsKey = True like below.

  #region IntegrationID

        [PXDBString(30, IsKey = true, IsUnicode = true, InputMask = "")]
        [PXDefault()]
        [PXUIField(DisplayName = "Integration ID", Required = true)]
        [PXSelector(typeof(Search<TestDAC.integrationID>), typeof(TestDAC.integrationID), typeof(TestDAC.description), typeof(TestDAC.integrationType))]
        public virtual string IntegrationID { get; set; }
        public abstract class integrationID : IBqlField { }

        #endregion

Hi @Naveen B ,

Actually, Section ID is a primary key. I have renamed SectionCode UI field with “Section ID” label.

Please see the below DAC details.

Thanks,

Moulali Shaik.

@MoulaliShaik79  Here is my suggestion. Hope this helps you.

• Please remove the PXDBIdentity from DAC and database (it is not required)
• You can make the SectionCode field as Key in DAC and database. and please find the updated DAC file here.

using System;
using PX.Data;

namespace SSS.SSP
{
  [Serializable]
  [PXCacheName("SSPAgreeSection")]
  public class SSPAgreeSection : IBqlTable
  {


    #region SectionCode
    [PXDBString(30, IskKey= true, IsUnicode = true, InputMask = "")]
    [PXUIField(DisplayName = "Section ID")]
    [PXDefault]
    [PXSelector(typeof(Search<SSPAgreeSection.sectionCode>),
          typeof(SSPAgreeSection.sectionCode),
          typeof(SSPAgreeSection.descr),
          typeof(SSPAgreeSection.sectionType),
          typeof(SSPAgreeSection.printDescr))]
        public virtual string SectionCode { get; set; }
    public abstract class sectionCode : PX.Data.BQL.BqlString.Field<sectionCode> { }
        #endregion

    #region SectionType
    [PXDefault("H")]
    [PXDBString(1, IsFixed = true, IsUnicode = true, InputMask = "")]
    [PXUIField(DisplayName = "Section Type")]
    [PXStringList(
      new string[]
      {
          Helper.Constant.Header,
          Helper.Constant.Footer
      },
      new string[]
      {
          Helper.Messages.Header,
          Helper.Messages.Footer
      })]
    public virtual string SectionType { get; set; }
    public abstract class sectionType : PX.Data.BQL.BqlString.Field<sectionType> { }
        #endregion

    #region Descr
    [PXDefault]
    [PXDBString(256, IsUnicode = true, InputMask = "")]
    [PXUIField(DisplayName = "Descr")]
    public virtual string Descr { get; set; }
    public abstract class descr : PX.Data.BQL.BqlString.Field<descr> { }
    #endregion

    #region PrintDescr
    [PXDefault(true)]
    [PXDBBool()]
    [PXUIField(DisplayName = "Print Descr")]
    public virtual bool? PrintDescr { get; set; }
    public abstract class printDescr : PX.Data.BQL.BqlBool.Field<printDescr> { }
    #endregion

    #region NoteHtml
    [PXDefault]
    [PXDBString(IsUnicode = true, InputMask = "")]
    [PXUIField(DisplayName = "Note Html")]
    public virtual string NoteHtml { get; set; }
    public abstract class noteHtml : PX.Data.BQL.BqlString.Field<noteHtml> { }
    #endregion

    #region Tstamp
    [PXDBTimestamp()]
    [PXUIField(DisplayName = "Tstamp")]
    public virtual byte[] Tstamp { get; set; }
    public abstract class tstamp : PX.Data.BQL.BqlByteArray.Field<tstamp> { }
    #endregion

    #region CreatedByID
    [PXDBCreatedByID()]
    public virtual Guid? CreatedByID { get; set; }
    public abstract class createdByID : PX.Data.BQL.BqlGuid.Field<createdByID> { }
    #endregion

    #region CreatedByScreenID
    [PXDBCreatedByScreenID()]
    public virtual string CreatedByScreenID { get; set; }
    public abstract class createdByScreenID : PX.Data.BQL.BqlString.Field<createdByScreenID> { }
    #endregion

    #region CreatedDateTime
    [PXDBCreatedDateTime()]
    public virtual DateTime? CreatedDateTime { get; set; }
    public abstract class createdDateTime : PX.Data.BQL.BqlDateTime.Field<createdDateTime> { }
    #endregion

    #region LastModifiedByID
    [PXDBLastModifiedByID()]
    public virtual Guid? LastModifiedByID { get; set; }
    public abstract class lastModifiedByID : PX.Data.BQL.BqlGuid.Field<lastModifiedByID> { }
    #endregion

    #region LastModifiedByScreenID
    [PXDBLastModifiedByScreenID()]
    public virtual string LastModifiedByScreenID { get; set; }
    public abstract class lastModifiedByScreenID : PX.Data.BQL.BqlString.Field<lastModifiedByScreenID> { }
    #endregion

    #region LastModifiedDateTime
    [PXDBLastModifiedDateTime()]
    public virtual DateTime? LastModifiedDateTime { get; set; }
    public abstract class lastModifiedDateTime : PX.Data.BQL.BqlDateTime.Field<lastModifiedDateTime> { }
    #endregion

    #region Noteid
    [PXNote()]
    public virtual Guid? Noteid { get; set; }
    public abstract class noteid : PX.Data.BQL.BqlGuid.Field<noteid> { }
    #endregion
  }
}

Hi @vivekm  and @Naveen B 

Thanks a lot both of you. Now I am able to save it.

Thanks,

Moulali Shaik.

@MoulaliShaik79 happy to help