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 [column] 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.
