I am working on an “inherited” oracle database. The idiots that set it up decided to make it case-SENSITIVE, but, all text fields are stored in UPPERCASE. So, my problem is that when I type text in the connector_text_filter, it only works if I remember to type it in UPPERCASE. Is the anyway that I can force whatever is typed into the connector_select_filter into UPPERCASE before it filters the underlying grid?
Please, try to use the following solution:
mygrid.loadXML(url,function(){
var inp=mygrid.getFilterElement(1) // 1 - index of the column with the needed filter
inp.style.textTransform="uppercase";
});
Thanks for the suggestion: the result is funny:
What you suggest DOES turn the typed text into uppercase, but the filter does not work!!!
Let me explain:
If I type “smith” (in lower case), the filter appears to contain “SMITH”, but it does not filter for “SMITH”, if, instead, I type “SMITH” in uppercase the filter does work! So, it appears to change the case of the typed text AFTER it has been used to filter, and thus the filter fails!
Unfortunately the issue cannot be reproduced locally.
Please, provide us with a demo link where issue can be reproduced or a complete demo.
The only way I can reproduce the issue for you is if you have a case-sensitive DB, with a column that has been populated with text in uppercase.
Let me try to explain better:
Imagine a database that has been created as case SENSITIVE
a table that has a field name called “Artist”
This table has been populated with names, all in UPPERCASE
what happens with your suggestion is the following:
let’s imagine a number of artists with part of the name “KING” like
ALBERT KING
BB KING
BEN KINGSTON
If I DO NOT have caps-lock and I type “king” in the filter, then “KING” appears in the filter (i.e. it is correctly converted to uppercase), but NO ARTIST APPEARS.
If instead I engage caps-lock, or hold down the shift key, then “KING” appears in the filter just as above, but the artists DO Appear.
This means that the filter test is being converted into UPPERCASE only AFTER it has been used to filter the db!
Can I not do anything with the connector script (java or php)??