Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Formatted search

Hello Everyone,

I am trying to set the filter on a formatted search. So if I type something and then pull up the formatted search the filter only pulls in results with the first few letters typed. Also it is possible to return the first field but search based on the criteria in the second or third field by default??

Thank you



you could check the field for a value using the $ dereference.

If you find a value you can execute a sql query with the term like in the where clause

ie where cardcode like $[ORDR.Cardcode]

then if you don't find a value in the dereferenced field don't use like.

if $[ORDR.Cardcode] = '' begin

select ...




select ... where cardcode like $[ORDR.Cardcode]


i don't know if it works- u need to try it....

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question