I downloaded the latest version 5.5.2 core - JQuery and the runs successfully.
I started adding the entities using the RAD tool. The entity is created successfully and project builds successfully and when i run the everything loads successful and i am able to store the data into the table using the create button. I see the data in the database as well using the SSMS.
But the issues is, when i navigate to the View it does not return any data. all the columns are blank and data table error is thrown.
Here is the error: DataTables warning: table id=xxxx - Requested unknown parameter 'table.column' for row 0, column 1. For more information about this error, please see <a class="postlink" href="http://datatables.net/tn/4">http://datatables.net/tn/4</a>
FYI. in 5.4 version i did not have issues for the same entity type.
I know that issue is not with the datatables ,but the service is returning no data. I am not sure why this is. Can you please help.
5 Answer(s)
-
0
Most probable reason of this error is wrong matching table columns in html file and js file. Are the order of columns are same in those files?
It would be nice to see your generated code.
-
0
What code do you want me to share.
All i did was , Just created a fully audited entity with six columns using the RAD tool.
Can you please elaborate on order of columns where?
-
0
Oh wow. I figured out the issue. It is not because of the order of the columns but actually because of the columns names. I used all capital column names and in the js file created by Rad tool the columns are formatted in different format. Once i changed the columns to sentence case things rolled back to normal. I think Rad tool should have an ability to handle this.
-
0
Same issue. However, changing case has not helped. It is failing on the Datatables load generated by the RAD TOOL. Other columns load except for the VIP_Contact column. The edit form works. Server side service is loading correct data. Column order is good.
DataTables warning: table id=SourceSystemsTable - Requested unknown parameter 'sourceSystem.vIP_Contact' for row 0, column 7.
HTML file
<div class="col-md-3"> <div class="form-group"> <label for="VIP_ContactFilterId">@L("VIP_Contact")</label> <input type="text" class="form-control" name="vIP_ContactFilter" id="VIP_ContactFilterId"> </div> </div>JS File
listaction: ... vIP_ContactFilter: $('#VIP_ContactFilterId').val(), ... { targets: 7, data: "sourceSystem.vIP_Contact" }, -
0
@GACoder have you changed anything in the generated code?
