Jump to content
Fred Slota

Partial UPC search

Recommended Posts

New, possibly odd, issue in hand.  I figured rather than trying to find the title, I'd search for the UPC.  No go.  I gave up.

Next week, post update, I try again with the UPC.  No go.

I decide to hunt for the title and find it.  I scroll down to look for the issue, and I think I find it, but no cover scans.  I move over to look at the UPC codes, and I find that it is apparently an unentered variant for an existing issue.  That explains not finding it by UPC search.

 

How about some form of partial UPC search in the find box?

I can think of several forms...

 

Enter 10 or 12 digits and try to find a title.

Enter 15 digits and try to match issues.

Enter 17 characters, mix of digits and 'x's, and try to wildcard match issues

Share this post


Link to post
Share on other sites

You can do the first two with Find, Item Field -> UPC and Begins With.

Enter the first 10, 12, or 15 UPC numbers.

For the last item, if you have it available, the Advanced Find works. Use Like and an underscore ( _ ) to replace any 1 position or a percent  ( % ) for any number of positions

Items Where...

I.[UPC] LIKE '75960607090900_11'

or

I.[UPC] LIKE '759606082292%11'

PS if needed, you can mix/match the use of _ and %.

 

 

Share this post


Link to post
Share on other sites

Thank you for that.  Figured that there were ways, at least with Advanced Find.

 

Just thought it would be useful to have it available right on the main window, without the need to construct a find on the fly or load a saved find.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...