passing values to query according to text and not key

[Former Member]

Hi,

I have a query that accept the get from input filed customers values. the values should be the customers key.

I would like to pass text values to the query and want to get all customers that the texts exists in text description of the customers.

Can I do such thing?

Thanks

Ami

[Former Member]

Ami Halm,

You will need to create your own web service to acomplish this, the following artice illustrates a similar example.

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/7000a4db-d4e2-2a10-ebaf-c6e1de63...

Regards,

Ahmed Salah

[Former Member]

Thanks Ahmed for your reply. The aritcle is very helpful.

I manged to solve this out by use the charactrestic as the data service (instead of a query) and then pass it the parameter with the following format,

1ROWCOUNT:'&2000&'::LE:I;'& '1TEXT:'&UPPER(@param)&'::CP:I'

this search for value in text instead of key

Points were rewarded.

Thanks

Ami