Is there some JS that can sort my grid ?

Jaymer

Since we don’t have a way for multiple level sorts, can somebody come up with the JS that can be attached to a PANEL OPERATION Button on a Grid and executed with the Execute Javascript option for this:

On a Grid of data, I’d like a button to sort by 2 pre-specified fields when clicked, and redraw the grid.

Reason:
I may initially come into the grid showing transactions sorted strictly by date.
And then I want to see the same data sorted by Transaction Type, and Date within that at the click of the button.
I do not want to mess with grouping.

Jaymer

@jktb75 john
Any idea how to dynamically change the sort after a button press.

jktb75

Hi Jaymer,
If I understand you correctly, then all you need to do is:

Create a text in the Query toolbar with an ID (e.g: <span id=“fire”>Filter by StartTime</span>)

In the Query Scripts under Initialization script, add this:

config.dataBound = function(e) {
    var grid = e.sender;

    $("#fire").off("click").on("click", function() {
        var currentDir = $(this).data("dir") || "asc"; 

        grid.dataSource.sort([
            { field: "StartTime", dir: currentDir },
            { field: "Time", dir: currentDir }
        ]);

        var nextDir = currentDir === "asc" ? "desc" : "asc";
        $(this).data("dir", nextDir);
    });
};

In the script change the names StartTime and Time to the name of the Attributes you want to sort by
Let me know if this is what you need

BLOMASKY

Thanks. I did not ask for this, but I am sure I will find this useful. Guess I should have spent more time learning the DOM model!

Bruce