Skip to main content

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.

This is a nice trick but I can only get it to work for one item.  If I paste a list of items, I get no results.

I tried separating items with commas, semicolons, etc.   What is the trick to be able to paste multiple items?

 

Thanks


Pretty nifty trick, thanks for sharing!


Reply