undefined value of ranges in the server side mode about jquery-datatables-column-filter HOT 15 CLOSED

I accidentally duplicated this bug report, but ran into a separate issue. My 
duplicate report with separate issue is Issue 26. I do not see how your or my 
solution yields a functioning filter as long as there are more than one number 
range. Were you able to resolve this?

I use only number range + date range, try this:

@@ -304,8 +305,8 @@

             for (j = 0; j < aiCustomSearch_Indexes.length; j++) {
                 var index = aiCustomSearch_Indexes[j];
-                var fnSearch_ = function () {
-                    return $("#range_from_" + index).val() + 
properties.sRangeSeparator + $("#range_to_" + index).val()
+                               var fnSearch_ = function (fieldIndex) {
+                    return $("#" + oTable.attr("id") + "_range_from_" + 
fieldIndex).val() + properties.sRangeSeparator + $("#" + oTable.attr("id") + 
"_range_to_" + fieldIndex).val();
                 }
                 afnSearch_.push(fnSearch_);
             }
@@ -321,7 +322,7 @@

                         for (k = 0; k < aoData.length; k++) {
                             if (aoData[k].name == "sSearch_" + index)
-                                aoData[k].value = afnSearch_[j]();
+                                aoData[k].value = afnSearch_[j](index);
                         }
                     }
                     aoData.push({ "name": "sRangeSeparator", "value": properties.sRangeSeparator });

Thank you! That is _infinitely_ better than the eval() solution I came up with!

i am sorry to say but this did not fix my issue with server side range 
filtering.  I have:

            for (j = 0; j < aiCustomSearch_Indexes.length; j++) {
                var index = aiCustomSearch_Indexes[j];
            var fnSearch_ = function (fieldIndex) {
                    return $("#" + oTable.attr("id") + "_range_from_" + fieldIndex).val() + properties.sRangeSeparator + $("#" + oTable.attr("id") + "_range_to_" + fieldIndex).val();
                }
                afnSearch_.push(fnSearch_);
            }
and

for (k = 0; k < aoData.length; k++) {
     if (aoData[k].name == "sSearch_" + index) {
          oData[k].value = afnSearch_[j](index);
      }
}

did i forget something?  The database field i am trying to sort is a float, 
does that matter?

Do i need to define the min and max in the html?

What you get from this script on the server side?

sRangeSeparator ~
sSearch 
sSearch_0   
sSearch_1   
sSearch_2   
sSearch_3   undefined~undefined
sSearch_4   
sSortDir_0  asc

is what firebug shows as parameters sent to the server when i begin typing 
something

sorry, i looked at my code some more and found a mistake.
The parameters are now being sent correctly, but i am still not getting any 
records when i type anything i get no matching records.

sRangeSeparator ~
sSearch 
sSearch_0   
sSearch_1   
sSearch_2   
sSearch_3   1.1~9.9
sSearch_4   
sSortDir_0  asc

these are the parameters now being sent.

You can modify your server-side scripts.

jQuery.DataTables server-side example 
(http://www.datatables.net/release-datatables/examples/server_side/server_side.h
tml) don't work with ranges.
For example, lines from 88 to 106: 
https://github.com/riuson/eaaphp2/blob/313491b1bb9a8d997dc586b581e58eda8b6b03b1/
classes/datatables_common.php

Thank you for your suggestion.  I see exactly what you are talking about.

Do you have a simple example of where to put that in my server side script to 
get range filtering to work correctly?  I tried to follow along with your 
project on git hub, but it is very sophisticated.

Vanilla server-side script from 
http://www.datatables.net/release-datatables/examples/server_side/server_side.ht
ml

Modified with this:

--- vanilla.php 2011-08-12 21:18:34 +0500
+++ modified.php        2011-08-12 21:29:28 +0500
@@ -107,7 +107,24 @@
                        {
                                $sWhere .= " AND ";
                        }
-                       $sWhere .= $aColumns[$i]." LIKE 
'%".mysql_real_escape_string($_GET['sSearch_'.$i])."%' ";
+                       $columnFilterValue = 
$this->registry['db']->escape($_POST['sSearch_' . $i]);
+                       // check for values range
+                       $rangeSeparator = "~";
+                       if (!empty($rangeSeparator) && 
strstr($columnFilterValue, $rangeSeparator)) {
+                               // get min and max
+                               preg_match("/(.*)\~(.*)/", $columnFilterValue, 
$columnFilterRangeMatches);
+                               // get filter
+                               if (empty($columnFilterRangeMatches[1]) && 
empty($columnFilterRangeMatches[2]))
+                                       $sWhere .= " 0 = 0 ";
+                               else if (!empty($columnFilterRangeMatches[1]) 
&& !empty($columnFilterRangeMatches[2]))
+                                       $sWhere .= $aColumns[$i] . " BETWEEN '" 
. $columnFilterRangeMatches[1] . "' and '" . $columnFilterRangeMatches[2] . "' 
";
+                               else if (empty($columnFilterRangeMatches[1]) && 
!empty($columnFilterRangeMatches[2]))
+                                       $sWhere .= $aColumns[$i] . " < '" . 
$columnFilterRangeMatches[2] . "' ";
+                               else if (!empty($columnFilterRangeMatches[1]) 
&& empty($columnFilterRangeMatches[2]))
+                                       $sWhere .= $aColumns[$i] . " > '" . 
$columnFilterRangeMatches[1] . "' ";
+                       } else {
+                               $sWhere .= $aColumns[$i] . " LIKE '%" . 
$columnFilterValue . "%' ";
+                       }
                }
        }

Thank you so much for this explanation.  I had the error:

Using $this when not in object context in 
/examples/server_side/scripts/modified.php on line 109

but i fixed it with the following line and everything works!  Thank you for 
your help!



                        }
                       $sWhere .= $aColumns[$i]." LIKE '%".mysql_real_escape_string($_GET['sSearch_'.$i])."%' ";
-                       $columnFilterValue = 
$this->registry['db']->escape($_POST['sSearch_' . $i]);
+ $columnFilterValue = mysql_real_escape_string($_GET['sSearch_' . $i]);
                       // check for values range
                       $rangeSeparator = "~";

Hi,

Could you please try it again with verison 1.2.3?

Thanks,
Jovan

Please reopen this issue if it happens again with the latest version of code.

Thanks,
Jovan

Do we still need to modify the server processing script from datatables?

I'm still not getting it to work, although it does go a lot further than it did 
toward working.

I used the modified server processing PHP along with the one line change on 
comment 11 and it is now working.