In SQL, we can do statements like this
SELECT DISTINCT BAccountID FROM BAccount
WHERE CompanyID = 2
However, in BQL, if we want similar functionality, we have to do this
This is all well and nice, however, when the select statements get more complicated, oftentimes the BQL results are slightly different than the SQL results.
Would it be possible to add a Distinct BQL Operator to Acumatica?
Or possibly a SearchDistinct class, since the first argument in any Search is the field.