Partial UPC search

[Fred Slota]

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

[Steven L. Dasinger]

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 %.

 

 

[Fred Slota]

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.