Hello,
We have a RadGrid which is displaying some jobs. It has 3 columns: Job name, Run Time and Status. In the ItemDataBound event of the RadGrid, we have a case statement which changes the text value of Run Time depending on the status of the job. If the job is scheduled to run in the future, its next run date is shown in the Run Time column. However, if the job is either running or pending, the job's last modified date is shown in the Run Time column.
The problem that we have now is that we would like to sort by the value in the Run Time column, but since the Run Time column does not have one underlying datasource field, the sorting is not working correctly. Is there a way to sort by the text value in the column and not by an underlying datasource field?
If anyone also has an alternate idea, I'd welcome that as well; it's always possible that I'm overlooking a better solution. :) Thanks in advance for any help that anyone can give.
Regards,
John
We have a RadGrid which is displaying some jobs. It has 3 columns: Job name, Run Time and Status. In the ItemDataBound event of the RadGrid, we have a case statement which changes the text value of Run Time depending on the status of the job. If the job is scheduled to run in the future, its next run date is shown in the Run Time column. However, if the job is either running or pending, the job's last modified date is shown in the Run Time column.
The problem that we have now is that we would like to sort by the value in the Run Time column, but since the Run Time column does not have one underlying datasource field, the sorting is not working correctly. Is there a way to sort by the text value in the column and not by an underlying datasource field?
If anyone also has an alternate idea, I'd welcome that as well; it's always possible that I'm overlooking a better solution. :) Thanks in advance for any help that anyone can give.
Regards,
John