how to group 3 fields using dynamic query

Hi all ,

I need to group the Project id , Section and Act Code in single line using dynamic queries. and sum the total Hours of all lines. 

i write the code like this. but not working.

qbdsProjectLines.addGroupByField(fieldNum(AttendanceProjectLines,projectId));//, Sections, Activity1Code));
qbdsProjectLines.addGroupByField(fieldNum(AttendanceProjectLines,Sections));
qbdsProjectLines.addGroupByField(fieldNum(AttendanceProjectLines,Activity1Code));

Suggest me any one.

Related
Recommended