Skip to Content
0
Former Member
May 19, 2010 at 04:40 AM

Itemcode in formatted search

32 Views

I have added a user defined field in the matrix of purchase order i.e TC.If the itemcode is 392042A04 or 392044A04 or 392049004 then Yes should be displayed in the column TC.For this I created query as,

select (case when charindex
($[$38.11],'HRPSAL0519,HRPGEN0593,BBAGEN0006,392042A04,392044A04,392049004,392057004,392070004,392072004,341023004') >0 then 'Yes'  else 'No' END)

Later I created formatted search on the change event of itemcode.But it is not working.