Ajax DataGrid Support Product Page

Search function appears to use regular expression, LIKE %this%.

Asked 12 Oct 2012 23:47:28

has this question

12 Oct 2012 23:47:28 Paul Coonan posted:

Search function appears to use regular expression, LIKE %this%. Where do I change that so the search query will get the exact thing searched, "="?

Replied 13 Oct 2012 07:11:29

13 Oct 2012 07:11:29 Paul Coonan replied:

Answered my own question.

In dms_grid1.php

I changed line 172

	//$where .= ($where ? 'AND ' : 'WHERE ') . "$qtype LIKE '%$query%' ";
	$where .= ($where ? 'AND ' : 'WHERE ') . "$qtype = '$query' ";

Replied 13 Oct 2012 07:55:34

13 Oct 2012 07:55:34 Paul Coonan replied:

This works until I update a grid and then it is overwritten. Is the schema text-editable? Where can I find it on Windows 7?