depgrid

Forum Replies Created

Viewing 5 replies - 1 through 5 (of 5 total)
  • Author
    Replies
  • in reply to: jqGrid filtertoolbar client side search not working #124865
    depgrid
    Participant

    Search is working now after clearing post data object. Thanks. Couldn’t have figured it out as ajax post data supports string in order to send the data in Json format. Our services (microsoft asmx or page methods) have restriction of accepting only JSON format.

    in reply to: jqGrid filtertoolbar client side search not working #124841
    depgrid
    Participant

    My requirement is to send the postdata as json object. Otherwise, my services wont recognize them.

    On your example, even though postData is json object, the actual request payload sent to service is serialized to URL encoded format.

    This is how the payload looks like in chorme developer tool – <span class=”header-value source-code”>myvar=%7BDivision%3A+%221%22%2C+GLNum%3A+%222%22%7D&_search=false&nd=1455208829824&rows=10&page=1&sidx=&sord=asc. </span>

    If it is object, i would get invalid json primitive error.

    http://stackoverflow.com/questions/2445874/invalid-json-primitive-in-ajax-processing

     

    in reply to: jqGrid filtertoolbar client side search not working #124830
    depgrid
    Participant

    Hi Will,

    Thanks for the reply. I have no issue with post data. if object is passed, jquery appends the values to to the query string and if the string is passed , it will go as object. I dont have any issue passing as string. As i get the data and binding is happening.

    My main issue is that client side search (loadonce is true) is not working for POST( mytpe:”POST”) calls. Where as it works for GET calls (mtype:”GET”) calls.

    I did test this with my code. For GET, I just returned same json response as i get from POST call. I think your library stops or wont do client side search for all POST calls. can you please confirm this? If not, do you have any example of client side search with POST call?

    And thanks for the quick response. I really appreciate it.

    Thanks

    Kishore

    • This reply was modified 8 years, 8 months ago by depgrid.
    • This reply was modified 8 years, 8 months ago by depgrid.
    in reply to: jqGrid filtertoolbar client side search not working #124824
    depgrid
    Participant

    Hi,

    I could able to get the data and see the table when using postData the way I do. I  am constructing the post data object with my variables. That works fine. I tried to do object way and I get error as variables are not recognized by jqGrid as those variables are out of the scope.

    One more thing I observed is keeping my code as it is and making mtype to “GET” and commenting postData and using my json data, I could able to do client side search.

    So I think the problem is with POST only. Do you have any example that the client side search works for POST calls?

    in reply to: jqGrid filtertoolbar client side search not working #124818
    depgrid
    Participant

    Hi,

    I tried searchoptions and it is still not working. searchOnEnter is false, because i dont want to get the data as soon as text is entered. What i meant input the search text and on key press down (Enter Button), the search should happen. But it is not the case. Below is my sample json data

     

    {“d”:”[{\”GLAcct\”:\”905.03\”,\”Borough\”:\”2\”,\”GLDescription\”:\”WO-UTL- BRONX\”,\”BeginBalance\”:\”-$22,818.96\”,\”TodaysDebits\”:\”$0.00\”,\”TodaysCredits\”:\”$0.00\”,\”CurrentBalance\”:\”-$22,818.96\”,\”DateLastTran\”:\”01/21/2016\”,\”RowCount\”:\”422\”},{\”GLAcct\”:\”905.03\”,\”Borough\”:\”3\”,\”GLDescription\”:\”WO-UTL- BROOKLYN\”,\”BeginBalance\”:\”-$9,805.04\”,\”TodaysDebits\”:\”$0.00\”,\”TodaysCredits\”:\”$0.00\”,\”CurrentBalance\”:\”-$9,805.04\”,\”DateLastTran\”:\”02/05/2016\”,\”RowCount\”:\”423\”},{\”GLAcct\”:\”905.03\”,\”Borough\”:\”4\”,\”GLDescription\”:\”WO-UTL- QUEENS\”,\”BeginBalance\”:\”-$121,727.47\”,\”TodaysDebits\”:\”$0.00\”,\”TodaysCredits\”:\”$0.00\”,\”CurrentBalance\”:\”-$121,727.47\”,\”DateLastTran\”:\”02/05/2016\”,\”RowCount\”:\”424\”},{\”GLAcct\”:\”905.03\”,\”Borough\”:\”5\”,\”GLDescription\”:\”WO-UTL- STATEN ISLAND\”,\”BeginBalance\”:\”-$12,295.23\”,\”TodaysDebits\”:\”$0.00\”,\”TodaysCredits\”:\”$0.00\”,\”CurrentBalance\”:\”-$12,295.23\”,\”DateLastTran\”:\”01/21/2016\”,\”RowCount\”:\”425\”},{\”GLAcct\”:\”905.14\”,\”Borough\”:\”1\”,\”GLDescription\”:\”WO-PLP- MANHATTAN\”,\”BeginBalance\”:\”$25,623.55\”,\”TodaysDebits\”:\”$0.00\”,\”TodaysCredits\”:\”$0.00\”,\”CurrentBalance\”:\”$25,623.55\”,\”DateLastTran\”:\”08/31/2009\”,\”RowCount\”:\”426\”},{\”GLAcct\”:\”905.14\”,\”Borough\”:\”2\”,\”GLDescription\”:\”WO-PLP- BRONX\”,\”BeginBalance\”:\”$18,409.23\”,\”TodaysDebits\”:\”$0.00\”,\”TodaysCredits\”:\”$0.00\”,\”CurrentBalance\”:\”$18,409.23\”,\”DateLastTran\”:\”08/23/2011\”,\”RowCount\”:\”427\”},{\”GLAcct\”:\”905.14\”,\”Borough\”:\”3\”,\”GLDescription\”:\”WO-PLP- BROOKLYN\”,\”BeginBalance\”:\”$11,914.06\”,\”TodaysDebits\”:\”$0.00\”,\”TodaysCredits\”:\”$0.00\”,\”CurrentBalance\”:\”$11,914.06\”,\”DateLastTran\”:\”06/29/2010\”,\”RowCount\”:\”428\”},{\”GLAcct\”:\”905.14\”,\”Borough\”:\”4\”,\”GLDescription\”:\”WO-PLP- QUEENS\”,\”BeginBalance\”:\”$23,825.78\”,\”TodaysDebits\”:\”$0.00\”,\”TodaysCredits\”:\”$0.00\”,\”CurrentBalance\”:\”$23,825.78\”,\”DateLastTran\”:\”07/20/2010\”,\”RowCount\”:\”429\”},{\”GLAcct\”:\”905.14\”,\”Borough\”:\”5\”,\”GLDescription\”:\”WO-PLP- STATEN ISLAND\”,\”BeginBalance\”:\”$6,622.14\”,\”TodaysDebits\”:\”$0.00\”,\”TodaysCredits\”:\”$0.00\”,\”CurrentBalance\”:\”$6,622.14\”,\”DateLastTran\”:\”06/22/2010\”,\”RowCount\”:\”430\”},{\”GLAcct\”:\”905.15\”,\”Borough\”:\”2\”,\”GLDescription\”:\”WO-PUT- BRONX\”,\”BeginBalance\”:\”$40,164.46\”,\”TodaysDebits\”:\”$0.00\”,\”TodaysCredits\”:\”$0.00\”,\”CurrentBalance\”:\”$40,164.46\”,\”DateLastTran\”:\”11/03/2010\”,\”RowCount\”:\”431\”},{\”GLAcct\”:\”905.15\”,\”Borough\”:\”3\”,\”GLDescription\”:\”WO-PUT- BROOKLYN\”,\”BeginBalance\”:\”$15,481.26\”,\”TodaysDebits\”:\”$0.00\”,\”TodaysCredits\”:\”$0.00\”,\”CurrentBalance\”:\”$15,481.26\”,\”DateLastTran\”:\”08/07/2014\”,\”RowCount\”:\”432\”},{\”GLAcct\”:\”905.15\”,\”Borough\”:\”4\”,\”GLDescription\”:\”WO-PUT- QUEENS\”,\”BeginBalance\”:\”$8,707.80\”,\”TodaysDebits\”:\”$0.00\”,\”TodaysCredits\”:\”$0.00\”,\”CurrentBalance\”:\”$8,707.80\”,\”DateLastTran\”:\”11/14/2012\”,\”RowCount\”:\”433\”},{\”GLAcct\”:\”905.15\”,\”Borough\”:\”5\”,\”GLDescription\”:\”WO-PUT- STATEN ISLAND\”,\”BeginBalance\”:\”$5,418.21\”,\”TodaysDebits\”:\”$0.00\”,\”TodaysCredits\”:\”$0.00\”,\”CurrentBalance\”:\”$5,418.21\”,\”DateLastTran\”:\”06/22/2010\”,\”RowCount\”:\”434\”}]”}

Viewing 5 replies - 1 through 5 (of 5 total)

Stay connected with us in your favorite flavor!