Acumatica custom field needs PXSelector for specific attribute Description values

Question

I have added a custom field to a screen and want to have a Selector to choose values from the Description of a specific attribute called BASEITEM.

[PXDBString(50, IsUnicode = true)]
[PXUIField(DisplayName = "Document Number", Visibility = PXUIVisibility.SelectorVisible)]
[PXSelector(typeof(Search<CSAttributeDetail.Description,
 Where<CSAttributeDetail.AttributeID.StartsWith("BASEITEM")>,
 OrderBy<Asc<CSAttributeDetail.Description>>>),
 DescriptionField = typeof(CSAttributeDetail.Description)]

However, when I try to publish this I get errors.

Building directory '/WebSiteValidationDomain/App_RuntimeCode/'.
/AcuDocCenterWebsite/App_RuntimeCode/PX_Objects_IN_InventoryItem_extensions.cs(27): error CS1003: Syntax error, '>' expected
/AcuDocCenterWebsite/App_RuntimeCode/PX_Objects_IN_InventoryItem_extensions.cs(27): error CS1525: Invalid expression term ','
/AcuDocCenterWebsite/App_RuntimeCode/PX_Objects_IN_InventoryItem_extensions.cs(27): error CS1026: ) expected
/AcuDocCenterWebsite/App_RuntimeCode/PX_Objects_IN_InventoryItem_extensions.cs(27): error CS1003: Syntax error, ']' expected
/AcuDocCenterWebsite/App_RuntimeCode/PX_Objects_IN_InventoryItem_extensions.cs(28): error CS1519: Invalid token '>' in class, struct, or interface member declaration
/AcuDocCenterWebsite/App_RuntimeCode/PX_Objects_IN_InventoryItem_extensions.cs(29): error CS1519: Invalid token '=' in class, struct, or interface member declaration
/AcuDocCenterWebsite/App_RuntimeCode/PX_Objects_IN_InventoryItem_extensions.cs(29): error CS1519: Invalid token ')' in class, struct, or interface member declaration
Compiler time, seconds: 0.8243028
Validation failed.

enter image description here

Your code doesn't compile, you are missing a parenthesis at the end. DescriptionField = typeof(CSAttributeDetail.Description))] — Simon ML
[PXDBString(60, IsUnicode = true)] [PXUIField(DisplayName = "Document Number", Visibility = PXUIVisibility.SelectorVisible)] [PXSelector(typeof(Search<CSAttributeDetail.Description), Where<CSAttributeDetail.AttributeID.StartsWith("BASEITEM")>, OrderBy<Asc<CSAttributeDetail.Description>>>), DescriptionField = typeof(CSAttributeDetail.Description))] — David Eichner
error CS1003: Syntax error, '>' expected error CS1525: Invalid expression term ',' error CS1026: ) expected /AcuDocCenterWebsite/App_RuntimeCode/PX_Objects_IN_InventoryItem_extensions.cs(27): error CS1003: Syntax error, ']' expected error CS1519: Invalid token '>' in class, struct, or interface member declaration error CS1519: Invalid token '=' in class, struct, or interface member declaration error CS1519: Invalid token ')' in class, struct, or interface member declaration — David Eichner

Simon ML Simon ML · Accepted Answer · 2016-08-10T20:01:00

There are a couple of strange things in your attributes, so let's try if fixing them will resolve your problem. Here is the complete snippet that should work :

    [PXDBString(50, IsUnicode = true)]
    [PXUIField(DisplayName = "Document Number", Visibility = PXUIVisibility.SelectorVisible)]
    [PXSelector(typeof(Search<CSAttributeDetail.description,
     Where<CSAttributeDetail.attributeID,  Like<string_BASEITEMPCT>>,
     OrderBy<Asc<CSAttributeDetail.description>>>),
     DescriptionField = typeof(CSAttributeDetail.description))]

Here is the constant class used in the PXSelector attribute

    public class string_BASEITEMPCT : Constant<string>
    {
        public string_BASEITEMPCT()
            : base("BASEITEM%")
        {
        }
    }

You were missing a parenthesis at the end of the PXSelector attribute which prevented build and publish.
You need to use the classes inheriting IBqlField instead of specific field i.e. use the lowercase class instead of the uppercase field when doing BQL.
To compare a field value to a string, use the Like<> operator and a string constant. To create that constant, create a class and specify the string value as the argument of the base constructor. The % at the end of "BASEITEM%" has the same purpose as the SQL wildcard %

Acumatica custom field needs PXSelector for specific attribute Description values

1 Answers