title: BQL on custom DAC referencing SOOrder.orderNbr not reflecting current Order Nbr
body: <p>We have a test DAC called UsrNonRelatedScanField with two fields : <em>OrderNbr</em> and <em>ScanStatus</em>. </p>
  
  <p>Here's our simple query to grab the correct ordernbr and assign it to a SOOrderExt field:</p>
  
  <pre><code>NonRelatedScanField lastScan = PXSelect&lt;NonRelatedScanField, 
                                 Where&lt;NonRelatedScanField.orderNbr,                                
                                 Equal&lt;Required&lt;SOOrder.orderNbr&gt;&gt;&gt;&gt;.Select(Base, row.OrderNbr);
  if(lastScan != null)
  {
      rowExt.UsrNonRelatedScanField = lastScan.ScanStatus;
  }
  </code></pre>
  
  <p>This logic is held in a SOOrder_RowSelecting() method.</p>
  
  <p><strong>Full Method implementation</strong>:</p>
  
  <pre><code>    protected virtual void SOOrder_RowSelecting(PXCache sender, PXRowSelectingEventArgs e)
      {
          SOOrder row = (SOOrder)e.Row;
          if (row == null) return;
          SOOrderExt rowExt = PXCache&lt;SOOrder&gt;.GetExtension&lt;SOOrderExt&gt;(row);
  
          NonRelatedScanField lastScan = PXSelect&lt;NonRelatedScanField, 
                                         Where&lt;NonRelatedScanField.orderNbr, 
                                         Equal&lt;Required&lt;SOOrder.orderNbr&gt;&gt;&gt;&gt;.Select(Base, row.OrderNbr);
  
          if (lastScan != null)
          {
              rowExt.UsrNonRelatedScanField = lastScan.ScanStatus;
          }
      }
  </code></pre>
  
  <p><strong>Expected Results</strong> : Get the current Orders scan status from lastScan DAC</p>
  
  <p><strong>Actual Results:</strong> Will populate correctly only on the initial order opened. When selecting other orders the old value is persisting <strong>unless</strong> I manually refresh the page. When manually refreshed the correct data comes in.</p>
  
  <p>I haven't had any issues in the past with BQL queries, this specific query is not behaving as expected.</p>
  
  <p>Thank you</p>