Maybe bug?: REST + joined tables = blank joined column

Maybe bug?: REST + joined tables = blank joined column

burncharburnchar Posts: 118Questions: 12Answers: 0
edited October 2012 in Editor
I have a table with "equipment" column from a join (using check boxes in the UI) and "editor" using REST.

Joined columns are blanked (except for commas) on any edit submission.
Old value: CIETN01X, CIETN03X, CIVAR11X, CIVAR62X
New value: ,,,

If I re-edit the row, appropriate values of "equipment" are still checked, but they are never again displayed until I refresh the web page.

My return JSON from an edit follows:
[code]{"id":"1","error":"","fieldErrors":[],"data":[],"aaData":null,"row":null,"children":null}[/code]
(If children and row are completely omitted, the same thing happens)

Further information about the table setup is in this post:
http://datatables.net/forums/discussion/12195/read-only-columns-displayed-only-in-datatable#Item_5

Replies

  • allanallan Posts: 61,446Questions: 1Answers: 10,054 Site admin
    What is Editor submitting to the server when you do that?

    Allan
  • burncharburnchar Posts: 118Questions: 12Answers: 0
    The following is the raw HTTP data both ways during a test this morning:

    [code]
    PUT http://localhost:53367/API/MainView HTTP/1.1
    x-requested-with: XMLHttpRequest
    Accept-Language: en-us
    Referer: http://localhost:53367/Manage/MainView
    Accept: application/json, text/javascript, */*; q=0.01
    Content-Type: application/json
    Accept-Encoding: gzip, deflate
    User-Agent: Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; WOW64; Trident/5.0)
    Host: localhost:53367
    Content-Length: 426
    Connection: Keep-Alive
    Pragma: no-cache
    Cookie: ASP.NET_SessionId=wgtrbjhkktyec3srd0z3fpej

    {"action":"edit","table":"MainView","id":"row_1410","data":{"DEVICE":"","ROM":"","ECA":"","PROCESS":"C5N","STAGE":"PTUBIMP","PARENT_ORDER":"2","CHILD_ORDER":"","DOSE":10000000000000,"RECIPE":"STD-C5X-PTI","PARENT_RECIPE":"","SPECIES_AMU":"49","SPECIES_CHEMICAL_FORMULA":"BF2","ENERGY":"60","TILT":"0","TWIST":"22","ROTATION":"1","CHARGE":"1","EQUIPMENT":[{"id":"4"},{"id":"5"}],"RECIPE_NOTES":""},"_approval_transaction":"13"}
    [/code]

    [code]
    HTTP/1.1 200 OK
    Server: ASP.NET Development Server/10.0.0.0
    Date: Tue, 23 Oct 2012 14:26:57 GMT
    X-AspNet-Version: 4.0.30319
    Cache-Control: no-cache
    Pragma: no-cache
    Expires: -1
    Content-Type: application/json; charset=utf-8
    Content-Length: 62
    Connection: Close

    {"id":"1","error":"","fieldErrors":[],"data":[],"aaData":null}
    [/code]
    Is population of the "row" object necessary when no special server-side changes are made?
This discussion has been closed.