Skip to main content
Solved

PXResultSet error "does not contain a definition for Select


Forum|alt.badge.img

Using V2023R2 trying to retrieve quantities from INSiteStatus in a processing program.

Error:

 

Error is on the .Select line that is in red in the code shown below:

using System;
using System.Collections;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Diagnostics;
using PX.Data;
using PX.Objects;
using PX.Data.BQL.Fluent;
using PX.Data.BQL;
using PX.Data.ReferentialIntegrity.Attributes;
using static PX.Api.SYMapping;
using MCB_Custom.MspData;
using PX.Objects.IN;
using PX.Objects.SO;

namespace MCBCustom
{
    public class FixMSPDataAlloc : PXGraph<FixMSPDataAlloc>
    {

        public PXCancel<MSPDataResult> Cancel;
        public PXProcessing<MSPDataResult> ResultView;

        public FixMSPDataAlloc()
        {
            ResultView.SetProcessDelegate(ProcessFixMSPDataAlloc);
            ResultView.SetProcessCaption("");  // not used in this program
            ResultView.SetProcessAllCaption("Process All");
        }
        public static void ProcessFixMSPDataAlloc(List<MSPDataResult> importSettings)
        {
            InventoryItemMaint graph = PXGraph.CreateInstance<InventoryItemMaint>();

            PXResultset<InventoryItem, INSiteStatus, INSite> result = SelectFrom<InventoryItem>
                .InnerJoin<INSiteStatus>.On<InventoryItem.inventoryID.IsEqual<INSiteStatus.inventoryID>>
                .InnerJoin<INSite>.On<INSiteStatus.siteID.IsEqual<INSite.siteID>>
                .Where<InventoryItem.stkItem.IsEqual<@P.AsBool>
                .And<InventoryItem.itemStatus.IsEqual<@P.AsString>>>
                .Select(graph, true, "AC");

            foreach (PXResult<InventoryItem, INSiteStatus, INSite> record in result)
            {
                InventoryItem resItem = (InventoryItem)record;
                INSiteStatus resStatus = (INSiteStatus)record;
                INSite resSite = (INSite)record;

 

Best answer by darylbowman

Try this:

var result = (PXResultset<InventoryItem, INSiteStatus, INSite>)SelectFrom<InventoryItem.InnerJoin<INSiteStatus>.On<InventoryItem.inventoryID.IsEqual<INSiteStatus.inventoryID>>.InnerJoin<INSite>.On<INSiteStatus.siteID.IsEqual<INSite.siteID>>.Where<InventoryItem.stkItem.IsEqual<@P.AsBool>.And<InventoryItem.itemStatus.IsEqual<@P.AsString>>>.View.Select(graph, true, "AC");

View original
Did this topic help you find an answer to your question?

11 replies

darylbowman
Captain II
Forum|alt.badge.img+13

For F-bql, you need View.Select()


Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • 21 replies
  • February 22, 2024

Thanks Daryl.  Now I am to a new error.

 


darylbowman
Captain II
Forum|alt.badge.img+13
  • 1745 replies
  • Answer
  • February 22, 2024

Try this:

var result = (PXResultset<InventoryItem, INSiteStatus, INSite>)SelectFrom<InventoryItem.InnerJoin<INSiteStatus>.On<InventoryItem.inventoryID.IsEqual<INSiteStatus.inventoryID>>.InnerJoin<INSite>.On<INSiteStatus.siteID.IsEqual<INSite.siteID>>.Where<InventoryItem.stkItem.IsEqual<@P.AsBool>.And<InventoryItem.itemStatus.IsEqual<@P.AsString>>>.View.Select(graph, true, "AC");


Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • 21 replies
  • February 22, 2024

Perfect.  That worked.  Thank-you very much!


darylbowman
Captain II
Forum|alt.badge.img+13

Fantastic. Could you mark that as the answer?


Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • 21 replies
  • February 22, 2024

Sorry I clicked on the wrong part as best answer.  Not sure how to undo that and make the actually code reply as the best answer.


darylbowman
Captain II
Forum|alt.badge.img+13

darylbowman
Captain II
Forum|alt.badge.img+13

Ha, just realized who this is. Good to see you 😁


Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • 21 replies
  • February 22, 2024

I got a chuckle out of you answering.  I am still working on how to split out a project for you.  Thanks for your help today.


darylbowman
Captain II
Forum|alt.badge.img+13
skalb11 wrote:

I got a chuckle out of you answering.

It’s good marketing 😉

Happy to help!


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2783 replies
  • February 22, 2024

I have fixed the best answer 😀


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings