How to club 2 queries in one formatted search query

[Former Member]

Hi All,

I have inserted a formatted search in the stock transfer for chnaging the 'From warehouse' based on series.

I have written following query for same,

SELECT $[$18.1.0]='08' WHERE $[OWTR.series] ='46'

It is working Fine

I want ot use same concept for selecting other based on other warehouse

e.g

SELECT $[$23.5.1]='02' WHERE $[OWTR.series] ='45'

But I am not able to club these queries on one formatted search query can anybody help to group it in one formatted search query....

Thanks and Regards,

Atul Joshi

Edited by: Atul Joshi on Dec 23, 2008 5:20 PM

[vijay_kumar1 · Accepted solution]

Hi Atul,

You could define the quey like this

SELECT

CASE

WHEN $[OWTR.series]='46' THEN '08'

WHEN $[OWTR.series]='45' then '02'

end

from OWTR

Regards,

Vijay kumar

SAP Business One Forums Team

[Former Member · Accepted solution]

Hi Vijay

Thanks a Lot!!!!!!!

I was looking for this only....

Thanks again..

Regards,

Atul Joshi