Ideas for Acumatica

Feedback processing: We do not reply to all messages, but we do read them, analyze them, and work to improve Acumatica based on the feedback we receive. Ideas and comments may not appear immediately. Some legitimate ideas are flagged as spam and will be added when we review the spam folders.
Content: This portal is for product ideas and feedback only. If you need customer service assistance, contact your Acumatica Support Partner, submit a support case, or get assistance from community resources: LinkedIn Group or StackOverflow
No Reliance: Information is maintained on a best-efforts basis and may be changed without notice. Acumatica cannot guarantee the accuracy of the information provided or guarantee completion of features/ideas described on this portal.

Distinct BQL Operator

In SQL, we can do statements like this

WHERE CompanyID = 2

However, in BQL, if we want similar functionality, we have to do this

Search4<BAccount.bAccountID, Aggregate<GroupBy<BAccount.bAccountID>>>

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.

  • Angel Sanchez
  • Feb 22 2017
  • Attach files