cishpix Hi all... I have a BO (call it as StudentData) with 2 attributes (Name and DOB). I want to create a query that can show all the data of the BO with the below criteria all the data will be group by month from DOB If there are some data that have same month (DOB) then the data will be sort by date from DOB I have try set like below in the "Group Template Header" but it not works well Month of DOB: #= kendo.toString(value,'MMMM') # Any idea??
himanshu Hi Suwandy, create a new attribute Month and calculate month from the DOB and assign value in it. create query and group by month order by DOB
cishpix Hi Himanshu.. many thanks for your idea.. himanshu wrote create a new attribute Month and calculate month from the DOB and assign value in it I already create like your suggestion and I got it as number in Month attribute. So, my question how can I convert it as month name not as number in query when I set it in grouping?
cishpix Hi Himanshu.. thanks again for your help.. it works but.. himanshu wrote instead of number you can save the Month Name too.. how can I sort the month name when I set it as group? Currently it sort as ascending but I want the month name sort like in calendar.. Any idea again 😃
himanshu could be couple of ways... a quick idea on this save your Month text attribute value something like this 01-Jan.. 02-Feb.. 03-March =PAD_LEFT(MONTH(CustomDate),'0',2)+'-'+MONTH_TEXT(MONTH(CustomDate))
cishpix Hi Himanshu.. You're really perfect man! Many thanks for your help.. It's really works.. But I'm curious and want to know, is it possible only show the group by month name (not include with the month number) and sort like in Calendar?
himanshu a quick solution to achieve is keep both values in two columns MONTH_TEXT and MONTH attributeMonth= MONTH(CustomDate) = MONTH_TEXT(attributeMonth) hide the attributeMonth col in grid query and sort order by attributeMonth. I think this way you have what you looking.. :idea:
PointsWell This is covered here with an example Group on One Attribute Sort by Another. (comment)&hilit=Group+sort#p56022
