Filter on Specific Parts from List

Help me out here… I’m sure someone has a quick tool for this!

I have a large list of parts in an excel column that I want to set as the criteria for the Part Table in a BAQ.

Rather than entering these one at a time which is how the in “specified constant list” works, is there an efficient way to get the whole list from a prompt similar to sql in (‘xxxx1’, ’ xxxx2’, ‘xxxx3’, etc.)?

Vote for this idea!

https://epicor.ideas.aha.io/ideas/KIN-I-4998

For now you will need to use the baq designer in classic mode to paste insert your values.

2 Likes

Simpleton here is missing it … What’s the correct syntax or WHERE do you paste insert?

2 Likes

GIF seinfeld, mindblowing, kramer, best animated GIFs reactiongifs, wow, mind blown, whoa, free download

Thank you Jeff!

1 Like

learned something New! Thanks!