Search

Ur a wizard harry. Seriously though thank you for taking the time. I don't know java-script very well, but i'll play around with this and see if I can't figure it out. Thank you so much :).

Hi @tangerine, Ta for that. It should've read: We're happy to take a look, but it would help, as per the forum rules, if you could link to a running test case showing the issue so we can offer some help. Information on how to create a test case (if you aren't able to link to the page you are working on) is available here.

I had serverSide set to "true", which requires the server to handle sort/search functions. However, I can't find in the documentation exactly how to do that. Documentation Examples. I don't have an example that uses dataFilter I'm afraid, but those show how server-side processing with the table is expected to work. Return it from where? From the server? Yes, as the documentation linked to above notes you can return an error property in the JSON (or construct suitable JSON using dataFilter in this case). Allan

Hi @somayajulu , This is probably because you're including the correct files, and most likely missing the FixedHeader files. Take a look at the example here, the files you need are listed on both the JS and CSS tabs. Cheers, Colin

Hi @hcanning , We're happy to take a look, but it would help, as per the forum rules, if you could link to a running test case showing the issue so we can offer some help. Information on how to create a test case (if you aren't able to link to the page you are working on) is available here. Cheers, Colin

Do you mean you want something like this in your table? If so, just move the initialisation of the select input elements into initComplete which is triggered once the data has been loaded into the table. Allan

I've given up this approach and resorted to a different approach. Showing the Razor code too in case someone shares my scenario (i.e., using .NET MVC 5 and trying to do something similar). It's not an elegant approach and requires more page loads depending on how the user uses the View, but it works. Declare Reconciled as a variable in my C# ViewModel and submit the form to (re)load the View with the intended parameters. @using (Html.BeginForm("Index", "ReconcileSummaryStudentsStillAbsents", FormMethod.Get)) { <p style="display: inline-block">Campus: @Html.DropDownListFor(m => m.Campus, Model.CampusList)</p> <p style="display: inline-block">Reconciled: @Html.DropDownListFor(m => m.Reconciled, Model.ReconciledList)</p> <input type="submit" value="submit" id="SubmitButton" /> } When the View loads after form submit, the editor is called with the intended parameters. var dataTableConfig = { dom: "Blftipr", ajax: { url: "@Url.Action("EditorTable")", data: { campus: "@Model.Campus", reconciled: $("#Reconciled").val() }, type: "POST" }, serverSide: true, And now I'm able to see the desired records after changing a dropdown value.

Actually, @allan, upon further investigation I think the widths of the inputs are already at 100% by default. The <th> width is somehow being set to a specific pixels width for the first row (the actual header row), not the input row. That's where I was getting hung up before.

Hi, My server side script came from your generator https://editor.datatables.net/generator/index Do you have any example or give me the guidelines to do it? Best regards

Hi Allan, Thanks for pointing me in the right direction Your ->where( 'vendors.id', $_SESSION['userId'] ) only needed to be changed to ->where( 'vendors.id', $_SESSION['vendor'] ) Problem solved - couldn't have done it without you! Thanks and best wishes Ian