VC: Search with wildcard in JDBC

[benot_delporte]

Hello

My request is quite simple but I've spent several hours and couldn't find the answer

I want to have a search critera screen which allow to search for a user by name (with or without a wildcard)

the search will be performed in a DB (MS sqlserver).

It's working well when I write the full name but if I write the beginning + wildcard ("bdel*" for example), it doesn't work.

I've tried with BI integration wizard, SQL editor but without success.

Can someone help ?

Thank you

Benoit

[benot_delporte]

Hello

I've found part of the answer so I share it with you:

Here is the code to write in the "SQL Editor" of the called BI query (related to the table ECCPUsers); it will search userid starting with P*:

Select "ECCPUsers"."dbo"."CreatedUsers"."UserId" , "ECCPUsers"."dbo"."CreatedUsers"."CompanyId" from "ECCPUsers"."dbo"."CreatedUsers" where "ECCPUsers"."dbo"."CreatedUsers"."UserId" LIKE 'P%'

But now my problem is to have this userid search dynamic with a input parameter. I've tried many syntax around the following one but without success:

Select "ECCPUsers"."dbo"."CreatedUsers"."UserId" , "ECCPUsers"."dbo"."CreatedUsers"."CompanyId" from "ECCPUsers"."dbo"."CreatedUsers" where "ECCPUsers"."dbo"."CreatedUsers"."UserId" LIKE '" & @INname & "'

Or the other solution I'm looking for but without success is to call a stored procedure. But when I search in my BI_JDBC system, it only show me tables and view. Not stored procedure...

Do you have any idea ?

thank you

Benoit

[Former Member]

Wondering if it is "case" sensitive?

[benot_delporte]

Thanks again!

I don't see how to set these options in VC (and I want to use VC instead of WebDynpro when I can).

I've used the ValueHelp option and indeed it shows all entries so I can select the right one for the next step but I still can't filter on the value I want and here I want to go to the next step with all users whose name start with bdel*.

Regards

[Former Member]

Hi ,

u need in vc Right u have desired functionality for Valuehelp in Sql .

if u have u can import

go to input filed -> Right click -> Valuehelp -> import ur procedure -> click ur search option there -> give ur key ( by search with key right like emp id , ...) -> and down steps u can give values filed for particular key wht fileds u have display -> selefct the value -> click on finish -> its over

display and check

Note : u sholud have value help functionality in ur SQl system

Regards ,

venkat

[benot_delporte]

Thank you for your answer but my DB is not related to any SAP R3 or BI systems. It's just a simple MS sqlserver DB with specific tables.

Any other idea ?

[Former Member]

Hi ,

If u r devloping application using Web dyn pro for java

we have three optios for searching

SVS,OVS ,EVS

Take this valuehelp optiosn and try ur saying ur DB is SQL Right it will work

Regards ,

venkat

[Former Member]

Hi ,

This Can be do with Valuehelp in vc7.1 by using ur key field u can search ur Values from theR/3 03 Bi System .

Just Right click on input filed -> Add Value help -> Define ur common bapi functionality for valuehelp -> Next -> give Ur key and valuees -> finish.

now u can search ur vbalue using key values .

Like this

*frtd meas it will give all the values from starts a to z

try this

Regards,

venkat