Forum Discussion

RyanB's avatar
RyanB
Ideator I
2 years ago

Query a List of Items

Hello,

I am an ARAS Innovator user. I have a list of parts in excel that I want to search for, but I don't want to search for them all individually.

For a list of size n that has elements I'll call item(i), I want the search to return results that contain item(1) OR item(2) OR item(3) ...OR item(n).

How can I do this? I am aware of the "simple, advanced, AML, and hidden" search options, but I don't know how to use them, nor do I know AML. Maybe one of those has the flexibility to perform this task.

Here is a picture of the screen I am working with.

 

Thanks,

-Ryan

2 Replies

  • asebastian's avatar
    asebastian
    Community Manager
    2 years ago

    Hello,

    The standard search grid allows use of the "Pipe" operator ( | ) to allow for multiple searches at once. You should be able to take your list from excel and delimit them by Pipes to show the desired list in the search grid!