[MatthewVParticipant]

Thanks for letting me know, I would like to see that feature as no I have to import yet another bloated library just for this function.

[MatthewVParticipant]

I also just noticed the “group” demo it just groups them, I want a check box next to the group name so someone can select that to toggle the checkboxes for all child items.

[MatthewVParticipant]

Thank you, the tree solution does not appear as it will work as it take up to much screen space. The other link looks like it might be what I want but I only see a way to add items to a group by manually adding each item. I am loading the list via a jqxDataAdapter, is there a way to assign the group with this method?

    $("#FiscalYearSelectBox").jqxDropDownList({
        checkboxes: true,
        displayMember: "FiscalPeriod",
        height: "25",
        selectedIndex: 1,
        source: new $.jqx.dataAdapter({
            dataFields: [
                { name: "FiscalPeriod" }
            ],
            dataType: "json",
            url: "GetFiscalPeriods"
        }),
        valueMember: "FiscalPeriod",
        width: "200"
    });

[MatthewVParticipant]

That demo does not help. I don’t know PHP so I can’t tell 100% but it looks like that fetches all the results on the back end at once then passes the total amount of results up. As I have stated before I can not do this, the SQL I run takes over 15 minutes to get all the results back so I do pagination at the SQL side, though only ever returning 20 results at a time. I can not calculate the total amount of rows to return to allow jqwidgets to figure out how many pages there are going to be. I need a solution that does not require me to know the total rows. Nothing you have given me helps me do this.

As for checking my backend, why? There is nothing wrong with my backend. It is 100% the jqwidgets issue of not being able to get it to fire an AJAX call and refresh the page. This is a blocking issue now, I either need a solution from you guys on how to get jqwidgets grid to do a full refresh and AJAX call so I can pass another 20 results to it as I have described here multiple times. If you guys are not willing to provide that information, can not provided that information, or your product can not do this I need to know now so I can move on to finding a software sweet that is more capable.

So in summery: Please quickly provide examples/demos of creating a pager that does not require knowing the total amount of rows. Just a single back and forward button that will create an AJAX call to a back end page and refresh the grid with the new result set.

[MatthewVParticipant]

I don’t think that will work since the SQL query is only returning 20 results and not all results there is no way to calculate how many pages there will be. Every example I have see on your site all presume that all the results of the entire query come back at once. This is not possible for me, I don’t want to force my users to sit for 15 minutes on every run of the report so there is no way of knowing the amount of pages. I need a solution that will allow me to just do an AJAX call, get the next set of results, and refresh the grid with that. Is that even possible or should we be moving to a different product?

Also, in all this time you still have not given any examples of how to use the “pager:” code from my first post.

[MatthewVParticipant]

I have looked at that first link before and I did not see anything of help, I have already tried using

            pagerrenderer: function ()
            {
                var element = $("<div style='margin-top: 5px; width: 100%; height: 100%;'></div>");
                var paginginfo = $("#ReportTable").jqxGrid('getpaginginformation');
                
                    var anchor = $("<a style='padding: 5px;' href='#1'>" + 1 + "</a>");
                    anchor.appendTo(element);
                    anchor.click(function (event)
                    {
                        var pagenum = parseInt($(event.target).text());
                        $("#ReportTable").jqxGrid('gotopage', pagenum);
                    });
                return element;
            },

but that does nothing to the rendered grid. That second demo just uses the built in pageing which I have already said does not work and either link answer the code question. So both links do nothing to answer anything I asked.

[MatthewVParticipant]

Thanks, I had looked at the MVC version of that since I am using MVC and they are JSON examples. I will study the code you linked to and see if I can’t adapt it.

[MatthewVParticipant]

Can you please provide a link to these tutorials for XML with ASP.Net? I can’t find them on your site and I really need to figure this out or I can’t use your product anymore.

[MatthewVParticipant]

Can you link me to where that at? I have not seen any going though your documentation section

[MatthewVParticipant]

Thank you but that is still using JSON, I want to avoid JSON as even your “LargeJsonResult” has a max limit to it.

[MatthewVParticipant]

Thanks, I have been doing this and it is working great. I would like to suggest that this be a built in thing, you have the ability for column data to do this and I have had to had type this out for almost 50 columns so it would be great if there was a parameter I could use like the autoRowHeight.

[MatthewVParticipant]

Thanks, I was able to get it working using your example.

[MatthewVParticipant]

Keeping a horizontal bar is fine, but having the vertical scroll wheel scroll horizontally is not. If a person wants to do horizontal scroll they should either do it with a horizontal wheel, found on some mouse, or by standard click/drag of the horizontal bar.

I do not want to do a fixed with of potentially over 2000 pxs causing the grid to go off screen and screw up the entire layout of my site. That is just as bad a UI design as your grid horizontally scrolling on a vertical scroll wheel.

[MatthewVParticipant]

Ok, what is the difference between that code/JSON and the below? The below table renders just fine with JSON that appears to have the exact same date.

[{"ID":52081,"ProjectCode":"CSSI0100009","ProjectDescription":"C Squared Company Overhead","TaskCode":"INTPROGRA","TaskDescription":"Internal Software Programming","StartDateTime":"\/Date(1477281600000)\/","HoursWorked":8.00,"WorkDescription":"Worked on MTN Alarm Report"}]

Table code:

    $("#TimeCardWeeklyOverview").jqxDataTable(
    {
        altRows: true,
        autoRowHeight: false,
        columns: [
            { dataField: "ProjectCode", text: "Project Code" },
            { dataField: "ProjectDescription", text: "Project Description" },
            { dataField: "TaskCode", text: "Task Code", width: 100 },
            { dataField: "TaskDescription", text: "Task Description" },
            { cellsformat: "dddd", dataField: "StartDateTime", text: "Day Worked", width: 100 },
            { dataField: "HoursWorked", text: "Hours Worked" },
            { dataField: "WorkDescription", text: "Work Description" }
        ],
        sortable: true,
        source: new $.jqx.dataAdapter({
            dataFields: [
                { name: "ProjectCode", type: "string" },
                { name: "ProjectDescription", type: "string" },
                { name: "TaskCode", type: "string" },
                { name: "TaskDescription", type: "string" },
                { name: "StartDateTime", type: "date" },
                { name: "HoursWorked", type: "number" },
                { name: "WorkDescription", type: "string" }
            ],
            dataType: "json",
            id: "ID",
            url: "/Timecard/TimeCardWeeklyOverview?selectedEmployeeID=" + $("#SelectedEmployeeID").val() + "&selectedDate=" + $("#SelectedDate").val()
        }),
        width: 900
    });

[MatthewVParticipant]

This really should not be forced on people, it was requested over a year ago that this function become option and I will second that request. The vertical scroll wheel on a mouse has a standard function of moving up and down, your over riding that function and forcing the end users into an unconventional situation. Please add the ability to disable this so users can have a consistent and predictable experience

[Author]

Posts