Help Needed

[hammadParticipant]

Hi

I had downloaded your application and some how configure it with the help of examples given. My questions are as follow:-

1. I want the search filters on one or two columns like Name, Address and City not on others. Will you guide me how to do it.

2. I want to set the value for number of records to be shown on a grid (paginating option). Please tell me where can i set the values of my own choice like 10, 30, 50, All

3. I want a column in this format :

Column Heading : Age Date (First Line)
Gender Time (Second Line)
There are four fields need to be shown in two columns. Cell is again spilted to show the value.

Regards

Hammad

[DimitarParticipant]

Hello Hammad,

1. Each column has a filterable property. If you set it to false, the column will not be filterable, i.e.:

   { text: 'Ship Name', datafield: 'ShipName', width: 250, filterable: false },

2. Please set the pagesizeoptions to [“10”, “30”, “50”], i.e.:

   $('#jqxGrid').jqxGrid({ pagesizeoptions: ["10", "30", "50"]});

   Note, however, that there is no option for “all”. You can show all rows by setting the page size to the number of rows or by switching paging off (setting pageable to false).

3. Please check out the demo Columns Hierarchy for an example on the matter.

Best Regards,
Dimitar

jQWidgets team
http://www.jqwidgets.com/

[hammadParticipant]

Hi Dimitar

Thanks for your prompt reply. i am looking @ following link (http://www.jqwidgets.com/jquery-widgets-documentation/documentation/jqxgrid/jquery-grid-cellsformatting.htm) but i failed to get the required result for date and time. in database my date data is saved in this format (Year Month and day) 19980414,20081204,20081210 and time in 203538.960689, 114238.000 , 195206.000. Can you guide me how can i display date and time using provided formats.

Secondly can i put calendar on my search grid. So that user simply click on the filed, opens the calendar , choose date and there goes the result.

Thirdly some of my table heading is too long. Can i some how wrap the text. So, that user cannot scroll left to right to view the required data.

Please guide.

–Hammad

[Peter StoevKeymaster]

Hi Hammad,

You cannot load a Date from 19980414, but you can manually modify the data before loading it by using the jqxDataAdapter’s beforeLoadComplete callback function. For more information, see: http://www.jqwidgets.com/jquery-widgets-documentation/documentation/jqxdataadapter/jquery-data-adapter.htm

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com/

[DimitarParticipant]

Hi Hammad,

As for your second and third questions:

2. Please check out the demo Filter Row to see how to filter dates through a calendar;
3. The forum topic Column Text Wrapping gives some tips on how to wrap the text in column headers.

Best Regards,
Dimitar

jQWidgets team
http://www.jqwidgets.com/

[Author]

Posts