In our queries AW will display the result in a grid. All the queries has the filter at the top of the grid.
My issue is:
1. How can I disable the case sensitive in the filter . Currently user need to enter accurate case for the filter in order for it to properly filter .
2. How can the queries to disable case sensitive duri appreciated.ng the db queries. I am using oracle
Any suggestion or direction is really
Case Sensitive
Hi,
I am not 100% sure about Oracle, but you might try setting this on your session in ORACLE not AWAREIM
alter session set NLS_SORT = GENERIC_BASELETTER;
From our app, we don't have such issues in MSSQL, the filter on top of the query returns both upper and lower-case.
I haven't used Oracle for a long time but give that a try. I am sure that it is Oracle you have to set to remove the case sensitivity.
Hope this helps
I am not 100% sure about Oracle, but you might try setting this on your session in ORACLE not AWAREIM
alter session set NLS_SORT = GENERIC_BASELETTER;
From our app, we don't have such issues in MSSQL, the filter on top of the query returns both upper and lower-case.
I haven't used Oracle for a long time but give that a try. I am sure that it is Oracle you have to set to remove the case sensitivity.
Hope this helps
Thanks in advance!
Cris
MSSQL 2008R2, Aware 7 b2146, IE11, , Firefox 35.0.1, Windows 8 Bootstrap theme
Cris
MSSQL 2008R2, Aware 7 b2146, IE11, , Firefox 35.0.1, Windows 8 Bootstrap theme