Announcement

Collapse
No announcement yet.

change the original select of the gird to use in group by...

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • change the original select of the gird to use in group by...

    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
Working...
X