[shimmorilParticipant]

Here is my grid code:

$("#reportGrid").jqxGrid ({
width: 775,
source: dataAdapter,
theme: theme,
altrows: true,
autoheight: true,
columnsresize: true,
selectionmode: 'none',
sortable: true,
filterable: true,
groupable: true,
groupsexpandedbydefault: true,
pageable: true,
virtualmode: true,
rendergridrows: rendergridrows,
pagesize: 25,
pagesizeoptions: ['25', '50', '100', '200', '400'],
columns: [
{text: 'EmployeeID', datafield: 'EmployeeID', width: 100},
{text: 'Name', datafield: 'Learner', width: 170},,
{text: 'Course', datafield: 'Course', width: 170},
{text: 'Assigned', datafield: 'Assigned', width: 95, cellsformat: 'dd-MMM-yyyy'},
{text: 'Started', datafield: 'Started', width: 95, cellsformat: 'dd-MMM-yyyy'},
{text: 'Completed', datafield: 'Completed', width: 95, cellsformat: 'dd-MMM-yyyy'},
});


I’ve gone line by line and removed the options you didn’t have in your example and then added them back in one-by-one. Enabling grouping is what caused the horizontal scrollbar to disappear for me.

[shimmorilParticipant]

Do you have any updates in regards to this issue?

[shimmorilParticipant]

Please read the thread before you reply. As I stated in my first post, and in a reply to you earlier this month, I HAVE set the type of my columns. I am using the latest version, and I can still reproduce this behaviour when the first row is empty.

Additionally, I’m not sure how the example you posted is supposed to prove that the bug no longer exists, since you have data in every row. As stated initially, and again in this response – the behaviour only occurs if the cell in the first row is empty.

Finally, as with my previous posts, we are loading data from XML, not from an array. I have provided XML and my grid source code below so you can replicate the issue. Sorting either the Employee ID column, or any of the date columns to have an empty value in the first row, and then attempting to filter will only provide the string filtering options, instead of the number or date options.

XML:

<LearnerReport>	
<Learner>
<UserID>1068645</UserID>
<LearnerName>user, test_10</LearnerName>
<CourseName>Exam Automation</CourseName>
<DateAssigned>23/07/2012</DateAssigned>
<DateStarted/>
<DateCompleted/> 
<EmployeeID/>
</Learner>
<Learner>
<UserID>1068646</UserID>
<LearnerName>user, test_11</LearnerName>
<CourseName>Test Course</CourseName>
<DateAssigned>23/07/2012</DateAssigned>
<DateStarted>23/07/2012</DateStarted>
<DateCompleted/> 
<EmployeeID/>
</Learner>
<Learner>
<UserID>1068647</UserID>
<LearnerName>user, test_12</LearnerName>
<CourseName>Test Course</CourseName>
<DateAssigned>23/07/2012</DateAssigned>
<DateStarted>26/07/2012</DateStarted>
<DateCompleted/> 
<EmployeeID/>
</Learner>
<Learner>
<UserID>1068648</UserID>
<LearnerName>user, test_13</LearnerName>
<CourseName>Test Course</CourseName>
<DateAssigned>23/07/2012</DateAssigned>
<DateStarted/>
<DateCompleted/> 
<EmployeeID/>
</Learner>
<Learner>
<UserID>1068649</UserID>
<LearnerName>user, test_14</LearnerName>
<CourseName>Test Course</CourseName>
<DateAssigned>23/07/2012</DateAssigned>
<DateStarted/>
<DateCompleted/> 
<EmployeeID/>
</Learner>
<Learner>
<UserID>1068650</UserID>
<LearnerName>user, test_15</LearnerName>
<CourseName>Test Course</CourseName>
<DateAssigned>23/07/2012</DateAssigned>
<DateStarted>23/07/2012</DateStarted>
<DateCompleted>24/07/2012</DateCompleted>
<EmployeeID/>
</Learner>
<Learner>
<UserID>1068651</UserID>
<LearnerName>user, test_16</LearnerName>
<CourseName>Test Course</CourseName>
<DateAssigned>23/07/2012</DateAssigned>
<DateStarted/>
<DateCompleted/> 
<EmployeeID/>
</Learner>
<Learner>
<UserID>1068652</UserID>
<LearnerName>user, test_17</LearnerName>
<CourseName>Test Course</CourseName>
<DateAssigned>23/07/2012</DateAssigned>
<DateStarted/>
<DateCompleted/> 
<EmployeeID/>
</Learner>
<Learner>
<UserID>1068653</UserID>
<LearnerName>user, test_18</LearnerName>
<CourseName>Test Course</CourseName>
<DateAssigned>23/07/2012</DateAssigned>
<DateStarted/>
<DateCompleted/> 
<EmployeeID/>
</Learner>
<Learner>
<UserID>1068654</UserID>
<LearnerName>user, test_19</LearnerName>
<CourseName>Test Course</CourseName>
<DateAssigned>23/07/2012</DateAssigned>
<DateStarted/>
<DateCompleted/> 
<EmployeeID/>
</Learner>
</LearnerReport>

Grid Source:

var source = {
datatype: "xml",
datafields: [
{name: 'UserID', map: '\\UserID', type: 'number'},
{name: 'EmployeeID', map: '\\EmployeeID', type: 'number'},
{name: 'Learner', map: '\\LearnerName', type: 'string'},
{name: 'Course', map: '\\CourseName', type: 'string'},
{name: 'Assigned', map: '\\DateAssigned', type: 'date'},
{name: 'Started', map: '\\DateStarted', type: 'date'},
{name: 'Completed', map: '\\DateCompleted', type: 'date'}
],
root: "LearnerReport",
record: "Learner",
id: '\\UserID',
url: url,
};


[shimmorilParticipant]

Do you have any further information on the status of this bug? It is affecting all of our grids and is very frustrating.

[shimmorilParticipant]

Further testiing indicates that there is a problem specifically with the dd-mmm-yyyy format. Data in the dd/mm/yyyy or mm/dd/yyyy format displays proper filter options (ie. greater than/less than). Possibly this is related to the previous filtering issue I brought up: http://www.jqwidgets.com/community/topic/empty-cell-filtering/.

[shimmorilParticipant]

Can you provide the contents or location of generatedata.js? I’m trying to work off your example from my other thread (http://www.jqwidgets.com/community/topic/horizontal-scrolling-filters/#post-6303), but I’m having difficulty creating the data.

[shimmorilParticipant]

It’s because you don’t have autoheight: true in your example. If I turn autoheight off, I am able to retain the horizontal scrollbar, but we do not want to be showing (potentially) hundreds of blank rows if a filter returns nothing.

[shimmorilParticipant]

My date column does not have greater than or less than options. My date is in a different format than yours – 24-Jul-12 and the format is not being set in the grid. Would this affect the filtering?

[shimmorilParticipant]

We’ve actually decided to go in another direction for this functionality, thanks for your assistance.

[shimmorilParticipant]

I’ve tried to implement the solution you suggested, but I’m having some difficulties.

I’m returning a count that will be used to hide/show the column. I’m not sure how to go about ‘get[ting] the additional params in the source’.

I’ve tried to pull the data directly out of the DataAdapter, but that’s not working either.

[shimmorilParticipant]

Thanks Peter.

[shimmorilParticipant]

What do you mean by ‘HTML with support for word wrapping’?

When you say that the row height will not be automatically adjusted, I assume you mean that we would need to manually specify the row height via the grid ‘rowsheight’ property? And if we didn’t set it correctly the contents of the row would not appear properly?

[shimmorilParticipant]

Oh wow. And that’s why starting at code for hours is a bad thing! Thanks Peter, that fixed the issue.

[shimmorilParticipant]

Okay, so further investigation shows that while the XML returned has 6 rows of data, when I add in an alert that shows dataAdapter.records[i].User I’m getting an alert w/ the first user’s name, then a blank alert, then the second user’s name etc. For some reason the source or dataAdapter isn’t reading the result properly.

This is my alert code:

var rendergridrows = function (params) {
for (var i=0; i<10; i++) {
alert(dataAdapter.records[i].User);
}
return dataAdapter.records;
}


[shimmorilParticipant]

There is a blank line between each User node, and a blank line separates the Report tags from the first/last child nodes, but this is true of all of our XML-populated grids, none of which have this problem.

Also, there are 6 records. If paging is on, only 6 rows are shown – 3 w/ data and three without. The number of rows is correctly reflected in the grid footer, and you cannot change the page. Changing the page size also doesn’t display any more rows. If paging is turned off, all 12 rows (6 w/ data and 6 w/o) are shown.

[Author]

Posts