hi guys, i have a grid for a table with student_id, student_name, student_number, student_class, student_dob, student_group, student_available …etc.
now all is ok with group by by student_class, student_group…
but, when i want to group_by “student_available” field, I want to change the original select of the gird…
like to give me all student_available that equal = to 1 (yes) and meanwhile to distinct the class, in other words, i want to group by both, all available students and only one of the repeated “student_class” field… this is basically original GROUP BY studnet_class sql statemnt which we can add to the grid select but hence will apply to all the gird… i just want to change it for one group by rule…
is that even possible? i tried sc_lookup and couldn’t success, i tried many other macros and put them on_groupby_studnet_available event but nothing works…
please advise if you faced something similar
thank you
Mike