Skip to main content
Answer

PXSelector static where clause

  • September 13, 2021
  • 3 replies
  • 1096 views
R
Freshman I

I have added a field to the existing SOOrder DAC in order to carry a ReasonCode.. But I only want to select records from the ReasonCode where the Usage field is equal to ‘A’

Here is my selector code to display the ReasonCodeID and Descr fields..

[PXSelector(typeof(Search<ReasonCode.reasonCodeID, Where<ReasonCode.usage, Equal<'A'>>>), typeof(ReasonCode.reasonCodeID), typeof(ReasonCode.descr))]
 

 

But this is the error:

\App_RuntimeCode\PX_Objects_SO_SOOrder_extensions.cs(36): error CS1031: Type expected

Best answer by Gabriel Michaud

Hi @ryanmoon32,

You cannot include scalar values directly in BQL queries. You need to use a constant class, like this one:

public class myConstant : Constant<string> { public myConstant() : base(“A”) { } }

It just so happens there’s already a set of constants defined for reason code usage in the ReasonCodeUsages class; you don’t need to redefine it. Here’s how it should look:

[PXSelector(typeof(Search<ReasonCode.reasonCodeID, Where<ReasonCode.usage, Equal<ReasonCodeUsages.adjustment>>>), typeof(ReasonCode.reasonCodeID), typeof(ReasonCode.descr))]

 

    3 replies

    Gabriel Michaud
    Captain II
    Forum|alt.badge.img+11

    Hi @ryanmoon32,

    You cannot include scalar values directly in BQL queries. You need to use a constant class, like this one:

    public class myConstant : Constant<string> { public myConstant() : base(“A”) { } }

    It just so happens there’s already a set of constants defined for reason code usage in the ReasonCodeUsages class; you don’t need to redefine it. Here’s how it should look:

    [PXSelector(typeof(Search<ReasonCode.reasonCodeID, Where<ReasonCode.usage, Equal<ReasonCodeUsages.adjustment>>>), typeof(ReasonCode.reasonCodeID), typeof(ReasonCode.descr))]

     

    Gabriel Michaud Founder @ Velixo, Excel-based reporting for Acumatica
    R
    Freshman I
    • ryanmoon32
    • Author
    • Freshman I
    • September 13, 2021

    Thanks @Gabriel Michaud 
    For future reference, where would that class for the constant go inside of my customization project?

    Code - Create Code File - New Graph or Code File?

    Naveen Boga
    Captain II
    Forum|alt.badge.img+19
    • Naveen Boga
    • Captain II
    • September 14, 2021

    Hi @ryanmoon32  Yes.

    As per standard practice, you need to create the separate class file (Constants.cs), where you can maintain all constants of your project and access it from here.

    Naveen B - Acumatica MVP 🏆 | Independent Developer for Hire 🚀 ⏩ https://www.linkedin.com/in/boga-naveen-kumar-54079a66/
    R
    Terms & ConditionsCookie settingsAccessibility statement
    About Acumatica ERP system
    Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
    © 2008 — 2024  Acumatica, Inc. All rights reserved