B4J Question Websocket table order

Philip Prins · Aug 10, 2015

I would like to order the displayed items in the table ,

tried

B4X:

FillAlarmsTable(tblAlarms, Main.db.ExecQuery2("SELECT NR,ID,Name ,Message,updated_time,Type  FROM Alarms WHERE Client = ? ORDER BY updated_time DESC", Array As String(ws.Session.GetAttribute("client"))))

Also tried

B4X:

jq.RunMethod("dataTable", Array As Object(CreateMap("aaData": data, "bFilter": False, _
        "bPaginate": True,"order": "[ 4, asc ]")))

But the order of displayed items will not change, any help is appreciated

Regards,
Philip

Erel · Aug 10, 2015

It should work. How are you storing the updated time values?

Philip Prins · Aug 10, 2015

Erel said:
It should work. How are you storing the updated time values?

In the database as ticks

Erel · Aug 10, 2015

The values returns from the SQL query will be ordered correctly. Go over the process with the debugger to see where the order changes.

Philip Prins · Aug 10, 2015

The database query order works ok ,the problem occurs when the data is send to the table, somehow the table orders it .
How can i send a order command to the jq run method?

B4X:

jq.RunMethod("dataTable", Array As Object(CreateMap("aaData": data, "bFilter": False, _
        "bPaginate": True)))

rwblinn · Aug 10, 2015

Philip,

try by adding

B4X:

"order":[]

Info from this link.

or

B4X:

"aaSorting": []

Philip Prins · Aug 11, 2015

rwblinn said:
Philip,

try by adding

B4X:

"order":[]

Info from this link.

or

B4X:

"aaSorting": []

When i try order there is no difference, when i use aaSorting i get an empty table,

B4X:

jq.RunMethod("dataTable", Array As Object(CreateMap("aaData": data, "bFilter": False, _
        "bPaginate": True,"aaSorting":"[[4,'asc']")))

Am i sending the aaSorting correct?

rwblinn · Aug 11, 2015

Philip,

attached is an example. Disable sorting is set like:

B4X:

$(document).ready(function() {
       $('#table1').dataTable( {
                "bProcessing":    true,
                "bPaginate":        false,
                "aaSorting": [],
                "sAjaxSource":    'TableHelper?method=show'
            } );
        });

Philip Prins · Aug 12, 2015

rwblinn said:

Philip,

attached is an example. Disable sorting is set like:

B4X:

$(document).ready(function() {
       $('#table1').dataTable( {
                "bProcessing":    true,
                "bPaginate":        false,
                "aaSorting": [],
                "sAjaxSource":    'TableHelper?method=show'
            } );
        });

Thanks ,this work but i am using the run method to update the table, if i add aaSorting the table remains empty

B4X:

jq.RunMethod("dataTable", Array As Object(CreateMap("bDestroy": True,"aaData": data, "bFilter": False, _
        "bPaginate": True,"bProcessing":True ,"aaSorting":"[[4,'asc']]")))

rwblinn · Aug 12, 2015

Hi Philip,

without additional code hard to find out. Could you share your code - esp. where the jq.RunCommand is defined?

I have tried another way using WebSocket and the Eval Method (in index.html datatable statement taken out in the script section), like

B4X:

Dim dtu As String
dtu = "$(""#table1"").dataTable( {""bProcessing"":""True"",""bPaginate"":""False"", ""aaSorting"": []," & data & "} );"
ws.Eval(dtu, Null)
ws.Flush

with the same result = Order of the records as set by the Select command and NOT by the datatable. To note again, that data is string generated by the JSONgenerator (as in the first example)
Please find attached simple example.

Philip Prins · Aug 13, 2015

rwblinn said:
Hi Philip,

without additional code hard to find out. Could you share your code - esp. where the jq.RunCommand is defined?

I have tried another way using WebSocket and the Eval Method (in index.html datatable statement taken out in the script section), like

B4X:

Dim dtu As String dtu = "$(""#table1"").dataTable( {""bProcessing"":""True"",""bPaginate"":""False"", ""aaSorting"": []," & data & "} );" ws.Eval(dtu, Null) ws.Flush

with the same result = Order of the records as set by the Select command and NOT by the datatable. To note again, that data is string generated by the JSONgenerator (as in the first example)
Please find attached simple example.

Hello Rob,

The run method is defined in the javascript b4j_ws.js ;

B4X:

function b4j_connect(absolutePath) {
    if (typeof WebSocket === 'undefined') {
        window.alert("WebSockets are not supported by your browser.");
        return;
    }
    var l = window.location, fullpath;
    fullpath = ((l.protocol === "https:") ? "wss://" : "ws://") + l.hostname + ":" + l.port + absolutePath;
    b4j_ws = new WebSocket(fullpath);
    b4j_ws.onmessage = function (event) {
        var ed = JSON.parse(event.data);
        if (ed.etype === "runmethod") {
            $(ed.id)[ed.method].apply($(ed.id), ed.params);
        } else if (ed.etype === "runmethodWithResult") {
            b4j_sendData($(ed.id)[ed.method].apply($(ed.id), ed.params));
        } else if (ed.etype === "setAutomaticEvents") {
            b4j_addAutomaticEvents(ed.data);
        } else if (ed.etype === "runFunction") {
            b4j_runFunction(ed.prop, ed.value);
        } else if (ed.etype === "runFunctionWithResult") {
            b4j_sendData(b4j_runFunction(ed.prop, ed.value));
        } else if (ed.etype === "eval") {
            b4j_eval(ed.value, ed.prop);
        } else if (ed.etype === "evalWithResult") {
            b4j_sendData(b4j_eval(ed.value, ed.prop));
        } else if (ed.etype === "alert") {
            window.alert(ed.prop);
        }
       
    };
}

rwblinn · Aug 13, 2015

Philip,

thx for sharing. Below a solution (attached is this example tested)

B4X:

Sub Class_Globals
    Private table1 As JQueryElement

...
    Dim m As Map
    m.Initialize
    m.Put("aaData", Main.DB.GetContacts)   
    m.Put("bFilter",False)
    m.Put("bPaginate": True)
    m.Put("bSort": False)
    table1.RunMethod("dataTable", Array As Object(m))

Philip Prins · Aug 13, 2015

B4J Question Websocket table order

Philip Prins

Active Member

Erel

B4X founder

Philip Prins

Active Member

Erel

B4X founder

Philip Prins

Active Member

rwblinn

Well-Known Member

Philip Prins

Active Member

rwblinn

Well-Known Member

Attachments

Philip Prins

Active Member

rwblinn

Well-Known Member

Attachments

Philip Prins

Active Member

rwblinn

Well-Known Member

Attachments

Philip Prins

Active Member

Similar Threads

B4J Question Websocket table order

Active Member

B4X founder

Active Member

B4X founder

Active Member

Well-Known Member

Active Member

Well-Known Member

Attachments

Active Member

Well-Known Member

Attachments

Active Member

Well-Known Member

Attachments

Active Member

Similar Threads

Privacy & Transparency

Privacy & Transparency