title: how to pxselect and put it on a var
body: <p>Hi i am new in acumatica development how can i pxselect a single column and get the result from the bql command can you show me how to do it thank you. This is for the Sales Order I have been searching the web for a sample but its not the same as my problem can someone help me</p>
  
  <pre><code> var str = "10020";
  
   var cmd = PXSelect &lt; SOOrder , Where &lt; SOOrder.OrderNbr, Equal&lt;
   str&gt;&gt;&gt;;
  </code></pre>
  
  <p>then get a string result from cmd i do not know how to code it properly thank you in advance. i have been trying several codes on how to do it but it always return a null value.</p>