Problem in select-option in module pool

[Former Member]

Hi,

I have 4 fields in my module pool screen, all are select-option and i want to select the data

on basis of these fields.

but condition is that some fields can be blank.

So i have use select query with 'in' option but it does not work when i leave some of the fields blank...

please suggest wat to do.

I will be obliged...

[Former Member]

check this..

https://forums.sdn.sap.com/click.jspa?searchID=14672301&messageID=5880647

I am involved in this topic, if you have any issues in understanding let me know..

[Former Member]

one possible option is to use seperate select queries depending on if the select option has data..

IF s_field1[] IS INITIAL.

SELECT ...where ....

ELSE.

SELECT ...where in s_field1.

ENDIF.