Hi Team,

I am writing a view to select the items below from a table, is there another way to arbitrarily select multiple items from a database instead of using "OR". My past experience that work well was for say 2 - 4 items but now I am not finding all records in the Filter of 21 items...??

Any HELP welcomed...

One Love...

Edward.

Actual Filter in use:

AND(
{Station}= 1
,
{Line Type} = 2
,
OR (
TRIM ({Item #}) = "AA0301",
TRIM ({Item #}) = "AB0071",
TRIM ({Item #}) = "AC0041",
TRIM ({Item #}) = "AD0001",
TRIM ({Item #}) = "AE0045",
TRIM ({Item #}) = "AF0001",
TRIM ({Item #}) = "AG0003",
TRIM ({Item #}) = "AH0006",
TRIM ({Item #}) = "AI0011",
TRIM ({Item #}) = "AJ0701",
TRIM ({Item #}) = "AK0041",
TRIM ({Item #}) = "AL0201",
TRIM ({Item #}) = "AM0301",
TRIM ({Item #}) = "AN7001",
TRIM ({Item #}) = "AP0081",
TRIM ({Item #}) = "AQ0901",
TRIM ({Item #}) = "AR5001",
TRIM ({Item #}) = "AS0091",
TRIM ({Item #}) = "AT0011",
TRIM ({Item #}) = "AU0601",
TRIM ({Item #}) = "AZ0101"

)
,
{Date} >= Querydate("Enter Start Date YYYYMMDD", DATE(2022,06,01))
,
{Date} <= Querydate("Enter End Date YYYYMMDD", DATE(2022,06,30))
)

Hi Edward

You don’t want to hardcode such a list into a View.

You want to pick a field in the item master table, for example Report Group ( or an optional field) and have the users enter something in that field for items to be selected.

Then the view filter is simply

{Report Group} = “x” (or whatever the user enters into that field).

Not only is the filter simpler, but the View doesn’t have to be edited to modify the list.

Steve

Hi Steve

THANK YOU SO MUCH... understood.


ONE LOVE
Edward