 |
|
|
Joined: 1/28/2008
Posts: 20
|
|
|
Hi,
I am currently using user defined table and there is a built in search which is case-sensitive. For example, if we have an entry called "Solutions" in the table and the user typed "solutions" for searching, it will not find any record. If the user types "Solutions", the record will be found.
Is it possible to make the search case-insensitive? (Is that actually a term? LOL)
Thank you for your help,
-Oliver
|
| |
|
|
 | |
|
|
|
Search is case sensitive, if you are using standard or costum XSL rendering. This limitation will be fixed in next major (!) release.
|
| |
|
|
| |
|
|
Joined: 1/28/2008
Posts: 20
|
|
|
Hi Sebastian,
Thank you for your reply. Here is the solution I propose:
Replace the following from:
<xsl:variable name="filteredData" select="udt:Data[contains(*[name()=$searchColumns][1],$search) or contains(*[name()=$searchColumns][2],$search) or contains(*[name()=$searchColumns][3],$search) or contains(*[name()=$searchColumns][4],$search) or contains(*[name()=$searchColumns][5],$search)or contains(*[name()=$searchColumns][6],$search)or contains(*[name()=$searchColumns][7],$search)or contains(*[name()=$searchColumns][8],$search)or contains(*[name()=$searchColumns][9],$search)or contains(*[name()=$searchColumns][10],$search)]" />
with the following:
<xsl:variable name="filteredData" select="udt:Data[contains(translate(*[name()=$searchColumns][1], 'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ'),translate($search,'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ')) or contains(translate(*[name()=$searchColumns][2], 'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ'),translate($search,'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ')) or contains(translate(*[name()=$searchColumns][3], 'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ'),translate($search,'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ')) or contains(translate(*[name()=$searchColumns][4], 'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ'),translate($search,'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ')) or contains(translate(*[name()=$searchColumns][5], 'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ'),translate($search,'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ'))or contains(translate(*[name()=$searchColumns][6], 'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ'),translate($search,'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ'))or contains(translate(*[name()=$searchColumns][7], 'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ'),translate($search,'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ'))or contains(translate(*[name()=$searchColumns][8], 'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ'),translate($search,'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ'))or contains(translate(*[name()=$searchColumns][9], 'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ'),translate($search,'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ'))or contains(translate(*[name()=$searchColumns][10], 'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ'),translate($search,'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ'))]" />
|
| |
|
|
| |
|
|
|
thank you  .
|
| |
|
|
| |
|
|
 |
Joined: 3/15/2008
Posts: 273
|
|
|
Does anybody have a drop down list box also working with the search form? Say you want to display a drop down list box from a defined list created from UDT, how could you add drop down list boxes to the search form so when a user wants to search through all the records, UDT then displays only the filtered records?
 |
City/Metro |
|
| Development |
|
| |
Price Range
|
To
|
| |
| |
Bedrooms
|
Baths
|
| |
|
|
|
|
| |
|
|
| |