Skip to Content
-1

Native SQL ?

Mar 21, 2017 at 09:29 PM

52

avatar image

Hi All,

my user enters email id ( ex: *vam* ) on portal which is based on our webdynpro application,now the issue is when it passed to the select query as %vam% system unable to get the mail id ( VamsiKrishna) as it is case sensitive.

Solution1 : ( I Used this )

i pull all the mail id's( twice means i used same field twice in the select query ) from adr6 into internal table then convert one field to upper case , then using this table to find the user entered string.

Solution2 :

is to use the native SQL query to pull the case sensitive mail id .

in the Solution2 the mail id i am passing is not a key field in the adr6 table & also there are 5 mail id fields are there on the selection screen in portal so i need to hit the table 5 times or 1 time with all the 5 non key patterns ( *abc* , *bcd* .....).i have only around 12000 entries in the adr6 table in the production.

now my worry here is i need to select all the data from adr6 each time the component is reloading ( not closing & re opening the portal ). we are also using the assistance class but this is initializing on reload.

So which approach is better in this case ?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Horst Keller
Mar 21, 2017 at 10:07 PM
0
Share
10 |10000 characters needed characters left characters exceeded