cancel
Showing results for 
Search instead for 
Did you mean: 

How can change the query where clause values in formatted search

Former Member
0 Kudos

Hi

I have a formatted search with the below sql

Select ItemCode,ItemName from OITM

where ItemCode like 'FX%'

how can I change 'FX%' to another value

I tried to make it as paramter

where ItemCode like $[ItemCode]

but I am receiving an error

sincerely yours

Riade Asleh

Accepted Solutions (1)

Accepted Solutions (1)

rasmuswulff_jensen
Active Contributor
0 Kudos

Try this:

Select ItemCode,ItemName from OITM

where ItemCode = $[$5.0.0]

5 = Item number of form (On item master data 5 is item-number)

0 = Column of item... since item 5 is no matrix 0 shoul be used.

0 = Casting type (0 is default, but int, string and date is possible)

Answers (0)