In one column, some of the lines are just empty

chagold

I have a table with a lot of data sent in JSON from the server to the client.
For some reason, although JSON comes complete, there is one column where some of the rows are empty.

Anyone know the problem?

kthorngren

This is a case where we will need to see your data and the resulting table to troubleshoot the problem. Please post a link to your page or a test case replicating the issue.
https://datatables.net/manual/tech-notes/10#How-to-provide-a-test-case

Kevin

chagold

http://bit.ly/2Do7w1Y

Thanks

chagold

You can see it easily in the "פרטי המשרה", when sorting through it I see a lot of empty fields

Thanks

kthorngren

Not sure specifically which rows you have in mind. Is this what you are referring to?

The row that has 050-2404410 for example?

Here is the record from the JSON:

{
    "id": "27484",
    "business_owner": "",
    "source": "\u05d9\u05e8\u05d5\u05e9\u05dc\u05d9\u05dd \u05d3\u05e8\u05d5\u05e9\u05d9\u05dd",
    "contact_person": "",
    "email": "",
    "area": "\u05d9\u05e8\u05d5\u05e9\u05dc\u05d9\u05dd",
    "city": "\u05d9\u05e8\u05d5\u05e9\u05dc\u05d9\u05dd",
    "date": "18\/11\/2019",
    "date_orginal": "2019-11-18",
    "name_rep": "\u05d1\u05ea \u05e9\u05d1\u05e2",
    "job_id": "\u05d1\u05d9\u05d8\u05d5\u05d7",
    "job_sub_id": "\u05de\u05d6\u05db\u05d9\u05e8\/\u05d4",
    "genedr": "\u05d2,\u05e0",
    "hot_job_or_not": "\u05dc\u05d0",
    "citi_name": "\u05d9\u05e8\u05d5\u05e9\u05dc\u05d9\u05dd",
    "city_location": "14",
    "scope": "\u05e2.\u05d6\u05de\u05e0\u05d9\u05ea",
    "job_info": "\u05d3\u05e8\u05d5\u05e9\/\u05d4 \u05de\u05d6\u05db\u05d9\u05e8\/\u05d4 \u05dc\u05e2\u05d1\u05d5\u05d3\u05d4 \u05de\u05e9\u05e8\u05d3\u05d9\u05ea \u05dc\u05e1\u05d5\u05db\u05e0\u05d5\u05ea \u05d1\u05d9\u05d8\u05d5\u05d7 \u05d1\u05ea\u05dc\u05e4\u05d9\u05d5\u05ea. \u05d4\u05e2\u05d1\u05d5\u05d3\u05d4 \u05dc\u05de\u05e9\u05da \u05d7\u05d5\u05d3\u05e9 \u05d5\u05d7\u05e6\u05d9. \u05e9\u05db\u05e8 \u05d4\u05d5\u05d2\u05df",
    "private_company": null,
    "class": "9",
    "sub_class": "81",
    "publish_on_others": "0",
    "job_phone": "050-2404410",
    "job_fax": "",
    "job_email": "",
    "bo_Name": "",
    "phone": "050-2404410",
    "Mobile": null,
    "adress": null,
    "owner_contact_person": null,
    "approved_by_karyera": "1",
    "u_name": null,
    "u_password": null,
    "credit_owner_full_name": null,
    "id_number": null,
    "credit_type": "\u05d0\u05e9\u05e8\u05d0\u05d9",
    "credit_num": null,
    "cvv": null,
    "expire": null,
    "phone_to_credit_copmany": null,
    "comment": null
}

This looks to be the first set of columns:

        columns: [
        { data: 'job_id' },
        { data: 'job_sub_id' },     
        { data: 'city' },
        { data: 'scope' ,"width": "60px"},

        { data: 'job_phone' ,"width": "60px"},
        { data: 'job_fax' ,"width": "60px"},
        { data: 'job_email' ,"width": "60px"},
        { data: 'genedr' ,"width": "60px"},
        { data: 'date' ,"width": "60px"},

        { data: 'hot_job_or_not' ,"width": "60px"},

        { data: 'job_info' ,"width": "60px"},
                ......

It does look like many of the fields in the JSON are blank. This would be from your server script. If this is not a good example then please post a specific example with the data from the JSON and what fields are blank that should have data.

Kevin

chagold

The following line numbers appear in JSON but do not appear in the table

29045
29046
29047

kthorngren

Looks ok here using Chrome:

The blue strips are form the Scroller extension, I believe. Does it work for you if you disable the scroller?

What browser are you using?

Is that screenshot from the same example you provided above?

The developers will need to look at the non-working version so the more details you can provide the easier it will be for them to recreate.

Kevin