Search

[code] public static string GetProjectData() { string QueryText = HttpContext.Current.Request.Params["iQueryText"]; String JsonData = String.Empty; if (!String.IsNullOrEmpty(QueryText)) { try { int iDisplayLength = 0; int iDisplayStart = 0; int sEcho = 0; int.TryParse(HttpContext.Current.Request["iDisplayLength"], out iDisplayLength); int.TryParse(HttpContext.Current.Request["iDisplayStart"], out iDisplayStart); int.TryParse(HttpContext.Current.Request["sEcho"], out sEcho); int iSortCol = Convert.ToInt32(HttpContext.Current.Request["iSortCol_0"]); string sSortDir = HttpContext.Current.Request["sSortDir_0"]; int iSortingCols = Convert.ToInt32(HttpContext.Current.Request["iSortingCols"]); string sStatus = HttpContext.Current.Request["sSearch_6"]; if (!String.IsNullOrEmpty(sStatus)) { QueryText = QueryText + " AND (PROJSTATUS:\"OPEN\")\""; } SearchServiceApplicationProxy proxy = (SearchServiceApplicationProxy)SearchServiceApplicationProxy.GetProxy (SPServiceContext.GetContext(SPContext.Current.Site)); KeywordQuery query = new KeywordQuery(proxy); query.ResultsProvider = Microsoft.Office.Server.Search.Query.SearchProvider.Default; query.QueryText = QueryText; query.SelectProperties.Add("GADIRProjectskey"); query.SelectProperties.Add("GADIRProjectsname"); query.SelectProperties.Add("GADIRhasocg"); query.RowLimit = iDisplayLength;// int.MaxValue; query.StartRow = iDisplayStart; query.TrimDuplicates = false; //Sorting if (iSortingCols == 1) { if (sSortDir == "asc" && iSortCol == 0) { query.SortList.Add("GADIRhasocg", Microsoft.Office.Server.Search.Query.SortDirection.Ascending); } if (sSortDir == "desc" && iSortCol == 0) { query.SortList.Add("GADIRhasocg", Microsoft.Office.Server.Search.Query.SortDirection.Descending); } if (sSortDir == "asc" && iSortCol == 1) { query.SortList.Add("GADIRProjectsname", Microsoft.Office.Server.Search.Query.SortDirection.Ascending); } if (sSortDir == "desc" && iSortCol == 1) { query.SortList.Add("GADIRProjectsname", Microsoft.Office.Server.Search.Query.SortDirection.Descending); } } // query.ResultTypes |= ResultType.RelevantResults; ResultTableCollection searchResults = query.Execute(); if (searchResults.Exists(ResultType.RelevantResults)) { ResultTable searchResult = searchResults[ResultType.RelevantResults]; DataTable result = new DataTable(); result.TableName = "aaData"; result.Load(searchResult, LoadOption.OverwriteChanges); JsonData = JsonConvert.SerializeObject(result, Formatting.None, new IsoDateTimeConverter() { DateTimeFormat = "MM/dd/yyyy" }); //build JSON StringBuilder jdata = new StringBuilder(); jdata.Append("{"); //sEcho jdata.Append("\"sEcho\":" + sEcho); jdata.Append(","); jdata.Append("\"iTotalRecords\":" + searchResult.TotalRows); jdata.Append(","); jdata.Append("\"iTotalDisplayRecords\":" + searchResult.TotalRows); jdata.Append(","); jdata.Append("\"aaData\":" + JsonData); jdata.Append("}"); JsonData = jdata.ToString(); } } catch (Exception ex) { JsonData = String.Format("Error:\"{0}\"",ex.Message); } } return JsonData; } [/code]

Server-side processing is pointless without paging to be honest, since al rows are needed up front anyway. How long does the server take to respond to the ajax request? Can you please link to a test page as noted in the forum rules. Allan

Excellent :-)

Very cool indeed, but as I say, I'm afraid not something that I can support at the moment. I am interested in what you come up with, but v1.10 is taking my priority at the moment rather than experimental new features. Sorry. Allan

ok, so I've stumbled into an answer, or at least a partial answer. 'full' is the full array of data for the row (I'm not sure how it differs from 'row'), so I can get the data from a particular column by referring to its index for the above example... [code] "aoColumnDefs": [ { "aTargets": [ 1 ], "mRender": function ( data, type, full ) { if(full[0] < 0.25){ return ''+data+''; }else{ return data; } } ] [/code] I've run into some issues due to the fact that I have complex headers in the actual table, as well as others, but it's a start

Can anybody help please ?? :(

Another issue/feature I found relevant to get this whole thing working http://code.google.com/p/jquery-datatables-column-filter/wiki/ColumnFilter

you can use fnServerParams see the reference documentation on http://datatables.net/ref [quote] It is often useful to send extra data to the server when making an Ajax request - for example custom filtering information, and this callback function makes it trivial to send extra information to the server. The passed in parameter is the data set that has been constructed by DataTables, and you can add to this or modify it as you require. [/quote] you can push the value of your checkbox onto the aoData array [code] $(document).ready( function() { $('#example').dataTable( { "bProcessing": true, "bServerSide": true, "sAjaxSource": "scripts/server_processing.php", "fnServerParams": function ( aoData ) { aoData.push( { "name": "status", "value": $('#my_secret_checkbox').val() } ); } } ); } ); [/code]

I wasn't aware of any issues in IE7 with 2.0.3, but it sounds like its only some of the more complex examples which don't work? However, IE6/7 support for FixedColumns is effectively at an end now. This commit as part of the work in 2.5 terminates IE6/7 support in FixedColumns: https://github.com/DataTables/FixedColumns/commit/1124405 . Having said that, if there is a simple fix, I'm happy to release 2.0.4 with it. Allan

thanks kkopczyk