We are on version 10.1.500.35 and when using Part Search “Where Part Description Contains”, not all results are returned.
Given the following part description;
“Washer, Flat, 7/8 USS, 0.938 ID x 2.25 OD x 0.136 Thk Min, Zinc Plt (ASTM F1941 Fe/Zn 5)”
If we try searching for all parts description containing “USS”, we should get 16 part entries. However we only get 1 result, a lengthy hardware kit description that does contain USS.
Any ideas?
For a couple of the part descriptions that contain USS but don’t show up when you search for USS, can you provide the full part description for review?
Emphasis mine
try the search using all records…not just the first 500.
For me, I noticed that all the searching is behaving the same. By default your setting probably say Maximum rows returned : 500
well it will search for all ESS in the first 500 records, not the first 500 records that contains ESS…
It is annoying…
Change the option to return all rows and test your search…
Pierre
Here are some samples that don’t show up in a search for “USS”;
“Huck Pin, Truss Head, 1/4” - 10 x 1.955" , 0.062-0.625" Grip Range, Zinc Plated, Huck# MGPT-R8-10G, (1800/Box)"
“Washer, Flat, 1/2 USS, 0.5625 ID x 1.375 OD x 0.086 Thk Min, Zinc Cobalt Plt Yellow (ASTM F1941 Fe/Zn-Co 5C)”
“Washer, Flat, 5/16 USS, 0.375 ID x 0.875 OD x 0.061 Thk Min, Zinc Plt (ASTM F1941 Fe/Zn 5) Spaenaur #91-SN-ZP or Equivalent”
This is the only part that is returned;
"Factory Assembly Hardware Kit, 536-04 Filter House
(Qty 524) Bolt, Hex, 1/4 - 20 X 1.00, Gr8, TL 0.75, Zinc Dichromate Plt Yellow (Astm F1941 Fe/Zn 5c)
(Qty 8) Bolt, Hex, 1/2 - 13 X 0.50, Full Thread, SS304
(Qty 6) Bolt, Hex, 1/2 - 13 X 2.25 , TL 1.25, SS304
(Qty 8) Bolt, Hex, 5/8 - 11 X 1.50, Full Thread, SS304
(Qty 25) Screw, Hex Washer Head, Self Drilling, 12-14 X 0.75, T/3 Point, Zinc Plt (Astm F1941 Fe/Zn 5) Ucan #Thw 1234 Or Equiv
(Qty 24) Nut, Hex, Lock, N/I, 3/8 - 16, SS304
(Qty 10) Nut, Hex, Lock, N/I, 1/2 - 13, SS304
(Qty 18) Nut, Hex, 1/2 - 13, SS304
(Qty 520) Nut, Self-Retaining, 1/4 X 20, Type U, Zinc Dichromate Plt Yellow (Astm F1941 Fe/Zn 5c)Reference Only: Spaenaur #202-387-Yzp
(Qty 88) Screw, Hex Washer Head, Self Drilling, 1/4-14 X 1.00, T/3 Point, Ss410ucan #Trh 141bss Or Equiv
(Qty 3) Screw, Thread Cutting, Phillips Drive Pan Head, Type F, 10 - 32 X 0.50, Full Thread, Stainless Steel Adams # 832-1032-0050
(Qty 6) Clevis Pin, SS304, 1/2 X 1 1/2 Lg, Spaenaur # 234-024
(Qty 8) Washer, Disc Spring, 1/2, SS17-7PH, 0.512 Id X 0.130 High X 0.098 Thk, Spaenaur # 680-863
(Qty 4) Cross Hand Wheel, Plastic Tapped Thru, 1/2 – 13, Spaenaur # 135-044
(Qty 24) Screw, Shoulder, Hex Socket Head, 3/8 - 16, SS304, Tl 0.625, Shoulder Dia 0.50 X 0.625 Lg Spaenaur #364-827 Or Equivalent
(Qty 524) Washer, Flat, 1/4 Uss, 0.3125 Id X 0.625 Od X 0.050 Thk Min, Zinc Dichromate Plt Yellow (Astm F1941 Fe/Zn 5c)
(Qty 2) Washer, Flat, 3/4, SS304, 0.8125 Id X 1.875 Od X 0.109 Thk Min, Spaenaur #W-2043 Or Equivalent
(Qty 12) Washer, Flat, 1/4 , SS304, 0.266 Id X 1.000 Od X 0.062 Thk Min, Spaenaur #658-066 Or Equivalent
(Qty 24) Washer, Flat, 3/8 , SS304, 0.391 Id X 1.000 Od X 0.062 Thk Min, Spaenaur #W-2039 Or Equivalent
(Qty 8) Washer, Flat, 1/2 , SS304, 0.5625 Id X 1.25 Od X 0.078 Thk Min, Spaenaur #W-2041 Or Equivalent
(Qty 92) Washer, Flat, 1/2, SS304, 0.5625 Id X 1.50 Od X 0.078 Thk Min, Spaenaur #658-071 Or Equivalent
(Qty 8) Washer, Flat, 5/8, SS304, 0.6875 Id X 1.50 Od X 0.078 Thk Min,
(Qty 18) Washer, Flat, 3/4, SS304, 0.8125 Id X 1.875 Od X 0.109 Thk Min, Spaenaur #W-2043 Or Equivalent
(Qty 8) Washer, Lock, Helical Split, 5/8, SS304, 0.203 Wide X 0.156 Thk, Spaenaur #W-2033 Or Equivalent
(Qty 13) Nut, Weld, Double Tab, 1/4 - 20, SS304
(Qty 8) Nut, Weld, Projection, 5/8 - 11, Plain
(Qty 3) T304 Stainless Threaded Rod, 1/2" Dia., 3 Ft Lengths
(Qty 4) Single Strut Channel 1 5/8" H X 1 5/8" W Galv 12 Ga Unslotted, P/N: 999-P-1000-4ft,
(Qty 16) Hitch Pin Clip, SS302, 1/8 Spaenaur # 090-840 Or Equivalent
(Qty 16) Washer, Lock, Helical Split, 1/4, SS304, 0.109 Wide X 0.062 Thk, Spaenaur #W-2028 Or Equivalent
(Qty 8) Bolt, Hex, 1/4 - 20 X 1.00, Full Thread, SS304
(Qty 8) Bolt, Hex, 1/4-20 X 0.75, Full Thread, SS304
(Qty 4) Screw, Machine, Philips Round Head, 6 - 32 X 0.75, Full Thread, SS304 Spaenaur Or Equivalent
(Qty 4) Nut, Hex, 6 - 32, SS304, Spaenaur Or Equivalent
(Qty 16) Washer, Flat, #6 SAE, 0.1562 Id X 0.375 Od X 0.036 Thk Min, SS304 Spaenaur Or Equivalent"
Tried searching with “Return All Rows” selected, no difference.
Do you have access to SQL Management Studio? If so, you can determine exactly which terms are searchable via this search.
The full text parser isn’t always intuitive.
select os_language_version,* from sys.dm_os_windows_info
select * from sys.dm_fts_parser('"Washer, Flat, 5/8, SS304, 0.6875 Id X 1.50 Od X 0.078 Thk Min"', 1033, 0, 0)If there is a currency code that is part of the ISO 4217 standard SQL has special rules about it.
Based on this test, that is what is happening with USS
From that Wikipedia article:
There is a write up I did on a different code (BRE), with some suggestions on how to work around this.
What about if you do %USS%
SQL contains searches only allow trailing wildcards, not leading.
One article that discusses this.
I submitted an enhancement request a while ago against 10.0.700.x to allow for a SQL like search instead of CONTAINS (it would be selectable by the user/company setting), but, it hasn’t been targeted.
Thanks, that is certainly the cause. A bit annoying, since this has nothing to do with a currency. Works fine when searching with like ‘%uss%’
We are stuck on 10.0.7.4 and created our own part quick search as the standard one had so many issues with things like this and an inability to cope with hyphens and leading zeros in parts
