Remove a "group by" statement from QueryBuildDataSource at runtime

Question

I need to remove a group by statement from a QueybuildDataSource object. Is there any method to do this? (The opposite of addGroupByField).

Answer 1

@Artem, I don't think you can do it from the QBDS level. I think you need to do it from query().clearGroupBy();

@ian_scho, users under 100 reputation can't answer their own questions for 4-8 hours after posting...that's probably why he didn't post as an answer.

Answer 2

Unfortunately, x++ does not have any method to remove one field from group by but by some tricks we can do that. I have written a method for removing group by field:

public void removeGroupByField(FieldID _fieldId, TableId _tableId, Query _query)
    {
        int i = 1;
        QueryGroupByField       qgbf;
        QueryBuildDataSource    qbdsOld, qbdsNew;
        Query                   newQuery;

        qbdsOld             = _query.dataSourceTable(_tableId);

        newQuery            = new Query(_query);    
        qbdsNew             = newQuery.dataSourceTable(_tableId);

        newQuery.clearGroupBy();

        for(i = 1 ; i<= _query.groupByFieldCount(); i++)
        {
            qgbf    = _query.groupByField(i, qbdsOld);
            
            if(qgbf.fieldID() != _fieldId)
            {
                qbdsNew.addGroupByField(qgbf.fieldID());
            }
        }

        _query  = newQuery;
    }

And for better performance u can change this method to input container of field Id which u want to remove from group by.

Answer 3

Have you tried?...

QueryBuildDataSource qbds = ????;
QueryBuildFieldList qbdsFL;
;
qbdsFL = qbds.fields();
qbdsFL.clearFieldList();

You can then add fields to be grouped programmatically. Mimmicking a Select Distinct clause for example.