Skip to main content
Answer

PXSelector for 24 R2 version

  • March 6, 2025
  • 7 replies
  • 68 views
H
Varsity I
Forum|alt.badge.img+1

Hi,

I have problem with PXSelector on acumatica 24 R2, bql query worked fine for previous versions but not on the 24 R2. Now it gives odd message “The method or operation is not implemented”. My query looks like

 

[PXSelector(typeof(Search2<InventoryItem.inventoryID, InnerJoin<POLine, On<InventoryItem.inventoryID,
        Equal<POLine.inventoryID>, And<POLine.orderNbr, Equal<Current<MyDAC.poorderid>>>>>>),
    typeof(InventoryItem.inventoryCD), typeof(InventoryItem.descr),
    SubstituteKey = typeof(InventoryItem.inventoryCD),
    DescriptionField = typeof(InventoryItem.inventoryCD))]

 

Best answer by hotdok

Yes [Inventory] attribute works fine but it is not exactly what I need. So finally I figured out. The issue was DAC that had to be inherited from PxBqlTable interface as well as IBqlTable. This is requirement from 24 version

    7 replies

    A
    Captain II
    Forum|alt.badge.img+8
    • aiwan
    • Captain II
    • March 6, 2025

    HI ​@hotdok 

     

    Try this:

    [PXSelector(typeof(SearchFor<InventoryItem.inventoryID>.InnerJoin<POLine>.On<InventoryItem.inventoryID.IsEqual<POLine.inventoryID>.And<POLine.orderNbr.IsEqual<MyDac.poorderid.FromCurrent>>>(Rest Of Your Selector))]

     

    Aleks
    Chris Hackett
    P
    Freshman I
    Forum|alt.badge.img

    Hi ​@hotdok ,

    [PXSelector(typeof(Search2<InventoryItem.inventoryID, InnerJoin<POLine, On<POLine.inventoryID, Equal<InventoryItem.inventoryID>>>, Where<POLine.orderNbr, Equal<Current<MyDAC.poorderid>>>>), typeof(InventoryItem.inventoryCD), typeof(InventoryItem.descr), SubstituteKey = typeof(InventoryItem.inventoryCD), DescriptionField = typeof(InventoryItem.inventoryCD))]

     

    Can you try this?

    Chris Hackett
    H
    Varsity I
    Forum|alt.badge.img+1
    • hotdok
    • Author
    • Varsity I
    • March 6, 2025

    HI ​@hotdok 

     

    Try this:

    [PXSelector(typeof(SearchFor<InventoryItem.inventoryID>.InnerJoin<POLine>.On<InventoryItem.inventoryID.IsEqual<POLine.inventoryID>.And<POLine.orderNbr.IsEqual<MyDac.poorderid.FromCurrent>>>(Rest Of Your Selector))]

     

    Thanks but InnerJoin gives error in your BQL.

    H
    Varsity I
    Forum|alt.badge.img+1
    • hotdok
    • Author
    • Varsity I
    • March 6, 2025

    Hi ​@hotdok ,

    [PXSelector(typeof(Search2<InventoryItem.inventoryID, InnerJoin<POLine, On<POLine.inventoryID, Equal<InventoryItem.inventoryID>>>, Where<POLine.orderNbr, Equal<Current<MyDAC.poorderid>>>>), typeof(InventoryItem.inventoryCD), typeof(InventoryItem.descr), SubstituteKey = typeof(InventoryItem.inventoryCD), DescriptionField = typeof(InventoryItem.inventoryCD))]

     

    Can you try this?

    Thanks,

    But this gives same issue.

    A
    Captain II
    Forum|alt.badge.img+8
    • aiwan
    • Captain II
    • March 6, 2025

    Thanks but InnerJoin gives error in your BQL.

    It does, sorry!

     

    Could you try using the [Inventory] attribute, and a PXRestrictor for the PO nbr?

     

    Aleks

    Aleks
    Chris Hackett
    H
    Varsity I
    Forum|alt.badge.img+1
    • hotdok
    • Author
    • Varsity I
    • Answer
    • March 6, 2025

    Yes [Inventory] attribute works fine but it is not exactly what I need. So finally I figured out. The issue was DAC that had to be inherited from PxBqlTable interface as well as IBqlTable. This is requirement from 24 version

    Chris Hackett
    Chris Hackett
    Community Manager
    Forum|alt.badge.img
    • Chris Hackett
    • Acumatica Community Manager
    • March 7, 2025

    Thank you for sharing your solution with the community ​@hotdok!

    Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
    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