1. 

   jasmondluk, Member

   Warning: Undefined array key 2 in /var/www/vhosts/dreamware.com.hk/httpdocs/ischool/DBR/apps/showReport.php on line 4045
   Warning: Undefined array key 2 in /var/www/vhosts/dreamware.com.hk/httpdocs/ischool/DBR/apps/showReport.php on line 4046

   SQL
   

   select 'DBR.text' as 'DBR.text', '604 iSchool Demo Center 2' as 'centername';
   
   select 'DBR.text' as 'DBR.text', 'A drop is counted if the student has dropped all schedule/free/weekly classes only' as 'A drop is counted if the student has dropped all schedule/free/weekly classes only';
   
   select 'dbr.css', '.nowrap {white-space:nowrap}';
   
   select 'dbr.colstyle', 'Record date', '[white-space:nowrap;]';
   
   select 'dbr.colstyle', 'Student', '[white-space:nowrap;]';
   
   select 'DBR.subtitle' as 'DBR.subtitle', 'Enrollment or drop in the last 120 day' as 'Enrollment or drop in the last 120 day';
   
   select 'DBR.crosstab' as 'DBR.crosstab', '[Type]' as '[Type]';
   
   select 'dbr.hdr', 'Month';
   
   select 'dbr.search', 1;
   
   select 'dbr.crosstab.col', 'Enrolled 新生報讀', 'Resumed 舊生重讀', 'Dropped 停學';
   
   select 'dbr.colsort', 'Record date';
   
   select '2024-05' as 'Month', '2024-05-22' as 'Record date', 'Enrolled 新生報讀' as '[Type]', 'new 24 ' as 'Student', 'SID009134' as 'ID', 'Active Writers / TBD' as 'Course / Teacher', 'Weekly' as 'Schedule', '2024-05-22 (#8 class)' as 'First or last(dropped) class', '' as 'Media / Source'
   
   ...
2. 

   myDBR Team, Key Master

   The dbr.colsort command takes two ColumnReferences as parameters and sorts the first column based on the values from the second column. This allows you to sort, for example, a datetime column that is displayed to the user in a non-sortable but friendlier format (e.g., the column might show "Yesterday afternoon," but the sorting is done based on the actual datetime value).

   What you are probably trying to use is the dbr.sort command, which sorts the column based on its value.

   We'll add a user warning for the dbr.colsort command when a parameter is missing.
   --
   myDBR Team

Reply

You must log in to post.