Grid filter not working (TypeError: val is null)

Suite and Optimus Suite 5
#1

Hi,

I’m using DHTMLX 2.6 Professional edition. Everything works fine until we tried to move to a new server where the database driver is SQLSRV instead of MSSQL.

Now the filters for grids are not working sometimes. Sometime they are working but for some data I think, it fails. The error message is:

TypeError: val is null
…/Dhtmx/dhtmlxGrid/codebase … _filter.js

Does anyone have the same problem?

Thanks,
Grace

#2

Unfortunately the issue cannot be reproduced locally.

Please, provide with any kind of sample of your code with the init of your grid.

#3

I will try, but I don’t know what kind of data will trigger the error. I suspect it’s related to NULL values of the data set.

#4

Now it looks like I have to look at this problem.

Here is a sample file:

#5

I’d like to add the sample data, but it always says:

The extension js is not allowed.

I tried .js, .php, .txt, and .json and they all didn’t work. Do you have an email address for me to send to?

Thanks.

#6

Unfortunately in case of using the dynamic loading you will have to use the server-side filtration.
Here you can find a tutorial:
docs.dhtmlx.com/doku.php?id=dhtm … parameters

#7

But we have been using the dynamic loading and smartrendering for a while. They work just like a charm. I don’t know what caused it stop working with the new web server and database.

#8

Unfortunately the client-side filtration is incompatible with dynamic loading of data.