访问关联表数据报错求助：已定位到var ret = cmd.Select()行

Hey there, let's work through this issue with your Acumatica code where the error hits at var ret = cmd.Select(); when accessing related table data. Based on what you've shared, here are the most likely fixes and things to check:

1. Fix the Incomplete PXSelectJoin Definition #

Your code cuts off mid-join condition (On<SOShipment.shipmentNbr, Equal<SO...), which will definitely break SQL generation. You need to fully define the join logic with complete, properly nested conditions—don’t forget to include critical fields like companyID to avoid cross-company data access errors.

2. Pass the Correct Graph Context to the Query #

When executing Select() on a PXSelectJoin instance, you must pass the current graph context (i.e., this) to ensure the query runs within the correct Acumatica session context. Omitting this can lead to permission or data access failures that are hard to trace.

3. Apply Filter Conditions from Your Filter DAC #

Since you’re using PXFilteredProcessing, tie your PXSelectJoin query to the EDCreateASNFilter criteria. This ensures you only return results that match the user’s filter, which aligns with expected behavior for filtered processing delegates.

4. Ensure Proper DAC Mapping (if EDASNShipProj is a Projection) #

If EDASNShipProj is a custom projection DAC, make sure it correctly maps to fields from SOShipment and SOOrderShipment. Without proper mapping, you’ll run into issues when yielding query results back to the processing view.

Corrected Code Example #

Here’s a revised version of your delegate method addressing these points:

[PXFilterable]
public PXFilteredProcessing<EDASNShipProj, EDCreateASNFilter> Shipment;

protected virtual IEnumerable shipment()
{
    int ii = 0;
    foreach (var row in Shipment.Cache.Cached)
    {
        ii++;
        yield return row;
    }

    if (ii == 0)
    {
        // Fully define the join and apply filter conditions
        var shipmentQuery = new PXSelectJoin<SOShipment,
            LeftJoin<SOOrderShipment, 
                On<SOShipment.shipmentNbr, Equal<SOOrderShipment.shipmentNbr>,
                And<SOShipment.companyID, Equal<SOOrderShipment.companyID>>>>,
            Where<SOShipment.status, Equal<Current<EDCreateASNFilter.status>>>>(this);

        try
        {
            // Execute query with the current graph context
            var results = shipmentQuery.Select();
            
            foreach (SOShipment shipResult in results)
            {
                // Map SOShipment data to your EDASNShipProj (adjust based on your DAC structure)
                EDASNShipProj projRow = new EDASNShipProj();
                projRow.ShipmentNbr = shipResult.ShipmentNbr;
                projRow.Status = shipResult.Status;
                // Add other required field mappings here

                yield return projRow;
            }
        }
        catch (Exception ex)
        {
            // Log detailed error for easier debugging
            PXTrace.WriteError($"Error fetching shipment data: {ex.ToString()}");
            throw;
        }
    }
}

Quick Debugging Tip #

Wrap the Select() call in a try-catch block and use PXTrace.WriteError to log the full exception details. This will give you specific info like missing fields, invalid join conditions, or permission issues that are causing the error.

内容的提问来源于stack exchange，提问作者Jerry Welliver