Guriddo » Topic: toolbar search ignorecase

toolbar search ignorecase

Guriddo
ignorecase
toolbar search ignorecase

Tagged: ignorecase

This topic has 13 replies, 3 voices, and was last updated 8 years, 11 months ago by guriddo.support.

Creator

Topic

September 19, 2015 at 10:57 am #124353

ariadrianto

Participant

Hi ,

I can’t implement ignorecase. I have search all over forum but no luck… even your demo without any option is working with insensitive string.

`

$grid = new jqGridRender($conn); // Data from this SQL is 1252 encoded, so we need to tell the grid // Set the SQL Data source //$grid->showError = true; //$grid->debug = true; $table = 'DIVISI'; $grid->SelectCommand ='SELECT DIVISIID, GROUPS, DIVISI FROM '.$table; // set the ouput format to XML $grid->dataType = 'json'; // Let the grid create the model $grid->setPrimaryKeyId("DIVISIID"); $grid->setColModel(); $grid->table = $table; // set labels in the header $grid->setColProperty("DIVISIID", array("label"=>"ID", "hidden"=>true)); $grid->setColProperty("GROUPS", array("label"=>"Groups","width"=>30, "editoptions"=>array("style"=>"text-transform: uppercase;") ,"searchoptions"=>array("sopt"=>array("cn")))); $grid->setColProperty("DIVISI", array("label"=>"Divisi","width"=>90, "editoptions"=>array("style"=>"text-transform: uppercase;") ,"searchoptions"=>array("sopt"=>array("cn") ))); // Set the url from where we obtain the data $grid->setUrl('divisi_.php'); // Set some grid options $grid->setGridOptions(array("rowNum"=>99999,"rowList"=>array(10,20,30),"sortname"=>"DIVISI", "width"=>"500")); // Enable toolbar searching $grid->toolbarfilter = true; $grid->navigator = true; $grid->setNavOptions('navigator', array("excel"=>true,"add"=>true,"edit"=>true,"del"=>true,"view"=>true)); //$grid->setNavOptions('navigator',array("csv"=>true, "pdf"=>true)); $grid->setFilterOptions(array("stringResult"=>true,"searchOperators"=>true,"searchOnEnter"=>true,"defaultSearch"=>"cn","ignoreCase"=>true)); // Enjoy $grid->renderGrid('#grid','#pager',true, null, null, true,true); //echo "finish";

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38

$grid = new jqGridRender($conn);

// Data from this SQL is 1252 encoded, so we need to tell the grid
// Set the SQL Data source
//$grid->showError = true;
//$grid->debug = true;
$table = 'DIVISI';

$grid->SelectCommand ='SELECT DIVISIID, GROUPS, DIVISI FROM '.$table;

// set the ouput format to XML
$grid->dataType = 'json';
// Let the grid create the model
$grid->setPrimaryKeyId("DIVISIID");
$grid->setColModel();
$grid->table = $table;
// set labels in the header
$grid->setColProperty("DIVISIID", array("label"=>"ID", "hidden"=>true));
$grid->setColProperty("GROUPS", array("label"=>"Groups","width"=>30, "editoptions"=>array("style"=>"text-transform: uppercase;")
,"searchoptions"=>array("sopt"=>array("cn"))));
$grid->setColProperty("DIVISI", array("label"=>"Divisi","width"=>90, "editoptions"=>array("style"=>"text-transform: uppercase;")
,"searchoptions"=>array("sopt"=>array("cn") )));
// Set the url from where we obtain the data
$grid->setUrl('divisi_.php');
// Set some grid options
$grid->setGridOptions(array("rowNum"=>99999,"rowList"=>array(10,20,30),"sortname"=>"DIVISI", "width"=>"500"));
// Enable toolbar searching
$grid->toolbarfilter = true;

$grid->navigator = true;
$grid->setNavOptions('navigator', array("excel"=>true,"add"=>true,"edit"=>true,"del"=>true,"view"=>true));

//$grid->setNavOptions('navigator',array("csv"=>true, "pdf"=>true));
$grid->setFilterOptions(array("stringResult"=>true,"searchOperators"=>true,"searchOnEnter"=>true,"defaultSearch"=>"cn","ignoreCase"=>true));
// Enjoy
$grid->renderGrid('#grid','#pager',true, null, null, true,true);
//echo "finish";

I ‘m using jqgrid adodb connection to firebird database. I cannot run :
$conn->Execute(“SET NAMES utf8”);
so I skip this… if this cause the problem…

Thank you

Ari

This topic was modified 9 years ago by ariadrianto. Reason: add explanation about adodb and firebird connection

Creator

Topic

Viewing 13 replies - 1 through 13 (of 13 total)

Author

Replies

September 21, 2015 at 11:34 am #124358

tony

Keymaster

Hello,

ignoreCase is not setFelter option – it is jqGrid options. If you do not know it is by default true. This option is valid only if you use a local data searching . In your case this is option does not have effect.
SET UTF is a MySQL specific command and does not have any relation to case sensitive searching.
In you case the case sensitive search depend on your database – Firebird. Please check Firebird documantation how to to make case sensitive searching. Maybe this aricle can help you – Performing Case Insensitive Searches

Kind Regards,

This reply was modified 9 years ago by tony.

September 21, 2015 at 12:07 pm #124369

ariadrianto

Participant

When I used jqgrid javascript, i can handle “where statement”:

$wh = strtoupper($wh);

1 2	$wh = strtoupper($wh);

So I can handle sql before load :
$sql = “select * from division where 1=1 $wh “;

and where I can put firebird case sensitive searching, on jqgrid suite php…

September 21, 2015 at 12:41 pm #124370

tony

Keymaster

Hello,

Do you have read the article that I point you. At the end of article we have:

Starting with Firebird 2.1.2 (or earlier, at least 2.1.2 is what the Release Notes seem to tell), you can use a new Case Insensitive Collation named UNICODE_CI for the UTF8 character set (Unicode).

So when your default character set is UTF8, your table declaration might look like this:

CREATE TABLE PERSONS (

1

CREATE TABLE PERSONS (

PERS_ID INTEGER NOT NULL PRIMARY KEY,

1

  PERS_ID INTEGER NOT NULL PRIMARY KEY,

LAST_NAME VARCHAR(50) COLLATE UNICODE_CI, FIRST_NAME VARCHAR(50) COLLATE UNICODE_CI

1
2

  LAST_NAME VARCHAR(50) COLLATE UNICODE_CI,
  FIRST_NAME VARCHAR(50) COLLATE UNICODE_CI

);

1

);

Your Index is a regular index declaration without any specials:

CREATE INDEX IDX_PERSON_LASTNAME ON PERSONS (LAST_NAME);

1

CREATE INDEX IDX_PERSON_LASTNAME ON PERSONS (LAST_NAME);

And your search expressions need no UPPER or whatsoever:

SELECT * FROM PERSONS WHERE LAST_NAME = :SEARCH_STRING

1

SELECT * FROM PERSONS WHERE LAST_NAME = :SEARCH_STRING

That’s it.

This reply was modified 9 years ago by tony.

September 21, 2015 at 3:43 pm #124373

ariadrianto

Participant

Hi tony,

I don’t think to change on 200 firebird tables that has a bunch of records, would be wise.

Are there any other ways to change $_REQUEST filter before execute sql ? Just like I did when using jqgrid javascript ….

September 22, 2015 at 5:50 am #124374

ariadrianto

Participant

Hi Tony,

this is my code.. maybe you can give suggestion on uppercase search. This is just a little thing, but I need it… :

<!--?php //iniset("display_errors",1); require_once '../jq-config.php'; // Create the jqGrid instance $grid = new jqGridRender($conn); $table = 'DIVISI'; $_REQUEST['filters'] = strtoupper($_REQUEST['filters']); $grid->SelectCommand ='SELECT DIVISIID, GROUPS, DIVISI FROM '.$table;</p>
<p>// set the ouput format to XML<br ?-->

require_once '../jq-config.php';
$grid = new jqGridRender($conn);

$table = 'DIVISI';
$_REQUEST['filters'] = strtoupper($_REQUEST['filters']);

$grid->SelectCommand ='SELECT DIVISIID, GROUPS, DIVISI FROM '.$table;
$grid->dataType = 'json';

$grid->setPrimaryKeyId("DIVISIID");
$grid->setColModel();
$grid->table = $table;

$grid->setColProperty("DIVISIID", array("label"=>"ID", "hidden"=>true));
$grid->setColProperty("GROUPS", array("label"=>"Groups","width"=>30, "editoptions"=>array("style"=>"text-transform: uppercase;")
,"searchoptions"=>array("sopt"=>array("cn"), "style"=>"text-transform: uppercase;")));
$grid->setColProperty("DIVISI", array(
"label"=>"Divisi",
"width"=>90,
"editoptions"=>array("style"=>"text-transform: uppercase;"),
"searchoptions"=>array("sopt"=>array("cn"), "style"=>"text-transform: uppercase;" )
));
$grid->setUrl('divisi_.php');

$grid->setGridOptions(array("rowNum"=>99999,"rowList"=>array(10,20,30),"sortname"=>"DIVISI", "width"=>"500"));

$grid->toolbarfilter = true;

$grid->navigator = true;
$grid->setNavOptions('navigator', array("excel"=>true,"add"=>true,"edit"=>true,"del"=>true,"view"=>true));
$grid->setFilterOptions(array("stringResult"=>true,"searchOperators"=>true,"searchOnEnter"=>true,"defaultSearch"=>"cn","ignoreCase"=>true));

$grid->renderGrid('#grid','#pager',true, null, null, true,true);

$oper = $_POST['oper'];
if($oper == 'add') {
$grid->table = 'DIVISI';
$grid->setPrimaryKeyId('DIVISIID');
$data = array_map("strtoupper", $_POST);
$grid->insert($data);

} else if($oper == 'edit') {
$grid->table = 'DIVISI';
$grid->setPrimaryKeyId('DIVISIID');
$data = array_map("strtoupper", $_POST);
//array_map("strtoupper", $sample_array);
$grid->update($data);
} else {
$grid->setUrl('divisi_.php');
}

<!--?php //iniset("display_errors",1); require_once '../jq-config.php'; // Create the jqGrid instance $grid = new jqGridRender($conn); $table = 'DIVISI'; $_REQUEST['filters'] = strtoupper($_REQUEST['filters']); $grid->SelectCommand ='SELECT DIVISIID, GROUPS, DIVISI FROM '.$table;</p>

<p>// set the ouput format to XML<br ?-->

require_once '../jq-config.php';

$grid = new jqGridRender($conn);

$table = 'DIVISI';

$_REQUEST['filters'] = strtoupper($_REQUEST['filters']);

$grid->SelectCommand ='SELECT DIVISIID, GROUPS, DIVISI FROM '.$table;

$grid->dataType = 'json';

$grid->setPrimaryKeyId("DIVISIID");

$grid->setColModel();

$grid->table = $table;

$grid->setColProperty("DIVISIID", array("label"=>"ID", "hidden"=>true));

$grid->setColProperty("GROUPS", array("label"=>"Groups","width"=>30, "editoptions"=>array("style"=>"text-transform: uppercase;")

,"searchoptions"=>array("sopt"=>array("cn"), "style"=>"text-transform: uppercase;")));

$grid->setColProperty("DIVISI", array(

"label"=>"Divisi",

"width"=>90,

"editoptions"=>array("style"=>"text-transform: uppercase;"),

"searchoptions"=>array("sopt"=>array("cn"), "style"=>"text-transform: uppercase;" )

));

$grid->setUrl('divisi_.php');

$grid->setGridOptions(array("rowNum"=>99999,"rowList"=>array(10,20,30),"sortname"=>"DIVISI", "width"=>"500"));

$grid->toolbarfilter = true;

$grid->navigator = true;

$grid->setNavOptions('navigator', array("excel"=>true,"add"=>true,"edit"=>true,"del"=>true,"view"=>true));

$grid->setFilterOptions(array("stringResult"=>true,"searchOperators"=>true,"searchOnEnter"=>true,"defaultSearch"=>"cn","ignoreCase"=>true));

$grid->renderGrid('#grid','#pager',true, null, null, true,true);

$oper = $_POST['oper'];

if($oper == 'add') {

$grid->table = 'DIVISI';

$grid->setPrimaryKeyId('DIVISIID');

$data = array_map("strtoupper", $_POST);

$grid->insert($data);

} else if($oper == 'edit') {

$grid->table = 'DIVISI';

$grid->setPrimaryKeyId('DIVISIID');

$data = array_map("strtoupper", $_POST);

//array_map("strtoupper", $sample_array);

$grid->update($data);

} else {

$grid->setUrl('divisi_.php');

}

Thanks.

September 22, 2015 at 9:23 am #124376

ariadrianto

Participant

Hi Tony…

I ‘ve change jqgrid.php to solve my problem in :
protected function getStringForGroup( $group, $prm )

I’ve change :

$v = strtoupper($val['data']);
// to replace this
//$v = $val['data'];

$v = strtoupper($val['data']);

// to replace this

//$v = $val['data'];

But if you have any better solution… please tell me.
thanks.

September 22, 2015 at 10:42 am #124378

tony

Keymaster

Hello,

Thanks for investigation.

I think that this is a partial solution. To implement more common solution we need to upercase the searched column. This way it is not needed to insert the data in the DB in uppercase format – (I refer your previous post).

Since this is a common problem we will publisha updated version which will implement some of your code and much more. You then will not need to insert data inthe DB.

We will notify you at end of this week with the updated code and instructions how to use.

Kind Regards,

November 6, 2015 at 10:07 am #124487

ariadrianto

Participant

Hi Tony,

when I can get your updated code ?
has it already available ?

Thanks…

November 10, 2015 at 10:51 am #124499