Thursday, April 8, 2010

Clear GroupBy on a query for a form

While working on a form, I recently needed to group by Customer account but then use the actual, non-grouped query in a different location. To remove a group by field on a query, find the form's datasource that has the group by and use the following line of code replacing 'FormDataSource' with the target datasource.

FormDataSource_ds.query().ClearGroupBy;