Introduction:
I wanted to pull a specific list of inventory items from a generic inquiry. 

Problem: 
I tried to use "Is In" operator for a condition. However, it does not seem to work as expected. (I tried various combination while profiling and could not get the SQL to translate to tcolumn] in ('test123', 'test456', 'test789')) 

If there is a way to use the "Is In" operator, please share.

Solution:
Add a parameter to enter the list of items. (Set the Schema Field to InventoryItem.Body for maximum characters) 

In Result Tab, add a column that utilizes "InStr()" to search for the InventoryCD in the parameter field. (Convert to CDec() for better filtering)

Paste a list of item numbers and filter the formula column “greater than” zero.

I hope this helps.