In Inventory-"IC Item Locations Master" I need to Filter for specified range of "Item Number". Please help as how to set the Filter.

Thanks.

The following Filter will allow you to specify 2 Item Codes; one is the starting point and the other is the ending point. All Item codes between will be displayed (including the starting and ending codes).

AND(
{Item #} >= QUERYSTRING("Enter Starting Item Code"),
{Item #} <= QUERYSTRING("Enter Ending Item Code")
)

If you don't want a dynamic filter, do the following (where you would replace the 2 item codes with your own values).

AND(
{Item #} >= "BKHUNI001",
{Item #} <= "BKHUNI099"
)

Note that the Item Codes are unformatted. Do not include the hyphens, dashes or spaces that Adagio automatically inserts for you. For instance, Item BKH.UNI-001 would be specified as BKHUNI001.

Hello Barb,

There's another way to accomplish the same task which might be easier and run more quickly if you have a large number of items.

1. Create a View showing the information you want from the Item Location Master.
2. Create another View that shows all your inventory items (perhaps just item number and description).
3. Define a link from the Item number in the inventory list to the location View.
4. Save the two Views as a workspace.

Now, to see the item quantity information for a specific item, just click on the item number in your item list. To see the quantities for multiple items, select them using shift-click or ctrl-click and double click to generate the link.

The lookup is virtually instantaneous.

I've attached a ZIP of the workspace I've described.

I need additional setting to the Filter, is that in between of the filtered range, fews items need to be excluded. How can I do it?

Thanks.

On what basis will you distinguish those items? What do they have in common?

The items number:

For example,from the range of number 150112204 to 150922002, in between the number 150822205 to 150842962 to be excluded from the list.

Thanks.

Try this:

AND(
{Item #} >= QUERYSTRING("Enter Starting Item Code"),
{Item #} <= QUERYSTRING("Enter Ending Item Code"),
{Item #}<>"150822205",
{Item #}<>"150842962"
)


If you need to exclude any more, just keep adding "{Item #}<>..." conditions.

Unfortunately, I cannot get it. It seems like it read only the first two lines setting not the last two line with the "<>" sign.

Thanks.

If your item numbers can be defined with more than 9 characters, there will be extra spaces in the item number value stored in the data, and thus the record selection that Ryan suggested would not work. If the way you want to select items is a 'pre-determined' way that will not change and you want to use the methods that Bruce and Ryan mentioned, you would have to modify specific item elimation by Trimming the item number of spaces:

AND(
TRIM({Item #}) >= QUERYSTRING("Enter Starting Item Code"),
TRIM({Item #}) <= QUERYSTRING("Enter Ending Item Code"),
TRIM({Item #})<>"150822205",
TRIM({Item #})<>"150842962"
)

If you want to be able to be able to select any combination of items for any rhyme or reason that is not 'pre-determined', then use Andrew's method to select the desired items in one view, and link them to a second view. The time it takes to multi-select the items will more than be saved in the processing time to do the filtering.

Make sure you check out the Adagio GridView Intro webinar to see how Filtering works.

If I understand correctly, you want to include:
150112204 to 150822205
150842962 to 150922002
Is that correct?