Selector on new field causing error

You should avoid having underscore characters in your field names as it interferes with how the SQL statements are generated. I’d suggest changing UsrInst_InstallVendor to be UsrInstInstallVendor.

Hi ​@spforster,

Try to replace your code foe your custom field as below
 

#region UsrInstInstallVendor
    [PXDBString(255)]
    [PXUIField(DisplayName="Install Vendor")]

  [PXSelector(
    typeof(Search<PX.Objects.CR.BAccountR.bAccountID,
           Where<PX.Objects.CR.BAccountR.type, Equal<PX.Objects.CR.BAccountType.vendorType>>>),
    typeof(PX.Objects.CR.BAccountR.acctCD),  // Display the Account ID in the selector
    typeof(PX.Objects.CR.BAccountR.acctName), // Display the Account Name in the selector
    SubstituteKey = typeof(PX.Objects.CR.BAccountR.acctCD), // Allows the user to search by Account ID
    DescriptionField = typeof(PX.Objects.CR.BAccountR.acctName))] // Shows the Account Name as description

    public virtual string UsrInstInstallVendor { get; set; }
    public abstract class usrInstInstallVendor : PX.Data.BQL.BqlString.Field<usrInstInstallVendor> { }
    #endregion

Hope it helps!

​@Django thank you for that suggestion, I have changed field names to avoid any potential complications

​@Dipak Nilkanth Your code worked, once I learned where to place it. Being new to customizations, I though using the attributes of the field, under Data Access in the Customization Project Manager was the appropriate place to put the PXSelector attribute. However, after importing your example project, I was able to look closer and see how to add the cache extension and code for the selector there.

Thank you both very much for your help!