How to custom Grid SQL?

[shanbw]

Hi,
After i use Grid Builder,the display order result is not ideal.
So i want to use SQL statement e.g.order by to achieve my project.
How to modify?
In before select event?
How to deliver the parameter?

thanks.

[yehlu]

You Can use Data Source ->Build Query

[學學安]

function Tasks_ds_BeforeBuildSelect() {
global $Tasks;

If ($Tasks->ds->Order == "") {
$Tasks->ds->Order = "task_name DESC";
}

}