LoisB993
(Lois BOUTIN)
1
Hello,
I’m having some issue about a query : it took to long for users to request a table.
After investigating, it appears that a Upper is summon by the request of my report definition.
i’m just asking to do a “select * from mytable where myproperty = ‘xxxxxxxx’;”
but I automaticaly have a “select * from mytable where (UPPER(myproperty) = ‘xxxxxxxx’);”
I havn’t seen any option to remove that Upper. Am I missing something ?
pavank
(Pavan Kalyan)
2
@LoisB993Are you looking to filter the values based on some property value which lower case and in DB it is in the upper case?
If yes you can select “Ignore Case” option in the report filters,
Please find the below screenshot for more details.
LoisB993
(Lois BOUTIN)
3
@pavan3753
Perfect, I forgot about this option, thanks !
