Previous in Forum: How Did This Happen?   Next in Forum: Has Anyone Switched to Windows 10
Close
Close
Close
20 comments
Rate Comments: Nested
Guru

Join Date: Feb 2008
Location: Large hole formally occupied by furry woodland creature.
Posts: 3385
Good Answers: 97

Creating a Wild Card Database Search

08/17/2015 4:21 PM

My company has a database that allows you to search for the parts that were used to construct the product at the factory.

The requirements are the first 7 digits of the product number and the serial number.

Would it be possible to develop a command set that could find the product number with only the serial number?

__________________
CRTL-Z
Register to Reply
Pathfinder Tags: wild card. database search
Interested in this topic? By joining CR4 you can "subscribe" to
this discussion and receive notification when new comments are added.
Guru

Join Date: Mar 2007
Location: by the beach in Florida
Posts: 33392
Good Answers: 1817
#1

Re: Creating a wild card database search.

08/17/2015 4:25 PM

They probably require the product number because the serial numbers are not unique....

__________________
All living things seek to control their own destiny....this is the purpose of life
Register to Reply
Guru

Join Date: Feb 2008
Location: Large hole formally occupied by furry woodland creature.
Posts: 3385
Good Answers: 97
#2
In reply to #1

Re: Creating a wild card database search.

08/17/2015 4:29 PM

The serial numbers are unique within a very narrow range. At least It would narrow it down.

My reason for asking is, some customers contact me with only the serial number.

__________________
CRTL-Z
Register to Reply
Guru
United Kingdom - Member - Indeterminate Engineering Fields - Control Engineering - New Member

Join Date: Jan 2007
Location: In the bothy, 7 chains down the line from Dodman's Lane level crossing, in the nation formerly known as Great Britain. Kettle's on.
Posts: 32175
Good Answers: 839
#4
In reply to #2

Re: Creating a wild card database search.

08/17/2015 4:43 PM

Then, obviously, design the database search form so that it can do what is wanted with the information available. Sheesh!

__________________
"Did you get my e-mail?" - "The biggest problem in communication is the illusion that it has taken place" - George Bernard Shaw, 1856
Register to Reply
Guru

Join Date: Mar 2007
Location: by the beach in Florida
Posts: 33392
Good Answers: 1817
#10
In reply to #2

Re: Creating a wild card database search.

08/17/2015 6:06 PM

They should be able to add Boolean search capabilities to the search engine....are you sure you don't have this already?

"Some search engines use symbols or all caps instead of words for their Boolean operations, but nearly all search engines are different:

AND = In Google and Yahoo a space between two words assumes AND.

If you use AND in Yahoo, it must be capitalized.

In other search engines, the + (plus sign) immediately before the second word: universities +norfolk will serve as the AND

Note: In Google, the + immediately before a word means you want that exact word -- without the +, Google automatically searches synonyms.

OR = Google and Yahoo require all caps when using OR.

In Google, the |(pipe sign) also indicates OR.

NOT = In Yahoo, NOT must be capitalized

- (minus sign) is a symbol many search engines use. In Google, the - must be placed immediately before the word/s you want to exclude: automobiles -trucks -vans

http://searchenginewatch.com/sew/how-to/2049150/boolean-searching

http://booleanstrings.com/custom-search-engines/

http://www.lib.odu.edu/genedinfolit/3searching/boolean_searching_in_search_engines.html

__________________
All living things seek to control their own destiny....this is the purpose of life
Register to Reply
Guru

Join Date: Oct 2009
Posts: 1460
Good Answers: 30
#11
In reply to #2

Re: Creating a wild card database search.

08/18/2015 5:37 AM

It sounds to me as if your company has a database which is not fit for purpose and you need to speak seriously to your IT department. As a customer, I would expect to provide a serial number, end of story. My car has a unique VIN number which fully identifies the vehicle without having to give a model number. My phone and dishwasher are similarly uniquely identified.
The answer to your question is therefore "Yes, even if my IT manager has to extract the information by force". A properly designed database would allow you to extract this and other information with very little in the way of commands.

Register to Reply
Guru
Canada - Member - If there is a way to screw someting up, there is someone to do so! Safety - Hazmat - New Member

Join Date: Mar 2007
Location: Iqaluit, NU. Canada
Posts: 1854
Good Answers: 140
#3

Re: Creating a wild card database search.

08/17/2015 4:42 PM

It certainly would be quite simple to pull a list of all parts that went into that serial number build. You need an additional key to find a particular part from within that data set.

__________________
Joe Contractor to Electrical Inspector, "What do you mean you are going to make me follow the code?".
Register to Reply
Guru
Popular Science - Biology - New Member Hobbies - Musician - New Member APIX Pilot Plant Design Project - Member - New Member Hobbies - CNC - New Member Fans of Old Computers - ZX-81 - New Member

Join Date: Jan 2007
Location: Centurion, South Africa
Posts: 3921
Good Answers: 97
#5

Re: Creating a wild card database search.

08/17/2015 4:44 PM

You would have to search where the field contain the serial number.

The word contain may be substituted by the word or symbol used in that particular query system.

The structure of the data should also be known.

__________________
Never do today what you can put of until tomorrow - Student motto
Register to Reply
Guru

Join Date: Feb 2008
Location: Large hole formally occupied by furry woodland creature.
Posts: 3385
Good Answers: 97
#6

Re: Creating a wild card database search.

08/17/2015 4:48 PM

So the consensus is, it would be possible.

Thanks.

Sheesh!

__________________
CRTL-Z
Register to Reply
Guru

Join Date: Oct 2008
Posts: 42355
Good Answers: 1693
#7

Re: Creating a wild card database search.

08/17/2015 4:53 PM

What happens if you Google the serial number?

Register to Reply
Guru

Join Date: Feb 2008
Location: Large hole formally occupied by furry woodland creature.
Posts: 3385
Good Answers: 97
#8
In reply to #7

Re: Creating a wild card database search.

08/17/2015 4:57 PM

I tried, nothing. The company even has a Google Based search engine.

I thought I would ask you guys before I asked the IT guys. I usually get a "no" before I finish the question.

__________________
CRTL-Z
Register to Reply
Guru

Join Date: Oct 2008
Posts: 42355
Good Answers: 1693
#9
In reply to #8

Re: Creating a wild card database search.

08/17/2015 5:39 PM

Smart move. Even if we can't help you find the answer right.

But, most IT guys are like used car salesmen.

They can usually find something shiny that runs, for awhile, costs more than it should and will never do what you really needed it to do in the first place.

Register to Reply
Guru

Join Date: Feb 2008
Location: Large hole formally occupied by furry woodland creature.
Posts: 3385
Good Answers: 97
#12
In reply to #9

Re: Creating a wild card database search.

08/18/2015 9:24 AM

IT guy: "WORK!"

__________________
CRTL-Z
Register to Reply
Guru
Engineering Fields - Power Engineering - New Member

Join Date: May 2007
Location: NYC metropolitan area.
Posts: 3230
Good Answers: 444
#13

Re: Creating a Wild Card Database Search

08/18/2015 10:34 AM

The question can't be answered correctly without knowing the type of database engine; i.e., Access, Excel, SAP, Oracle, etc. Some provide the means to produce an adhoc query, others don't, and in many cases the IT guys have the data locked down so that without the proper permissions it can't be done even if the program would otherwise allow.

__________________
“Tell me and I forget. Teach me and I remember. Involve me and I learn.” Ben Franklin.
Register to Reply
Guru

Join Date: Feb 2008
Location: Large hole formally occupied by furry woodland creature.
Posts: 3385
Good Answers: 97
#15
In reply to #13

Re: Creating a Wild Card Database Search

08/18/2015 10:47 AM

Your reply indicates that it May be possible.

Thank you.

__________________
CRTL-Z
Register to Reply
Guru
Engineering Fields - Power Engineering - New Member

Join Date: May 2007
Location: NYC metropolitan area.
Posts: 3230
Good Answers: 444
#16
In reply to #15

Re: Creating a Wild Card Database Search

08/18/2015 11:47 AM

Correct. Unfortunately, inflexibility is often a sign of a home-grown database that has no standard structure like SQL (Structured Query Language) so that any nonstandard query has to be handcrafted by the IT guys, many of whom consider this as "job security".

__________________
“Tell me and I forget. Teach me and I remember. Involve me and I learn.” Ben Franklin.
Register to Reply
Guru

Join Date: Feb 2008
Location: Large hole formally occupied by furry woodland creature.
Posts: 3385
Good Answers: 97
#17
In reply to #16

Re: Creating a Wild Card Database Search

08/18/2015 12:06 PM

The database might in be inflexible, I am waiting to find out.

My problem is probably one of over-logic, whereby the data base uses the first few digits of the product number and the complete serial number to search. So I suppose, there would have to be a link....or not.

__________________
CRTL-Z
Register to Reply
Guru
Engineering Fields - Power Engineering - New Member

Join Date: May 2007
Location: NYC metropolitan area.
Posts: 3230
Good Answers: 444
#18
In reply to #17

Re: Creating a Wild Card Database Search

08/18/2015 4:33 PM

You're applying modern logic to a potentially ancient database. You're thinking that the serial number/product number are separate fields and individually searchable when in fact it could just be one long string of alphanumerical characters.

The only way to search something like that is to parse each character and match it with the search string character by character until you get a perfect match, a time consuming process if your field is very wide. There are quicker ways like indexing the database or doing a hash, but if you're a non-programmer the price of the beers for the IT guys goes up very quickly.

__________________
“Tell me and I forget. Teach me and I remember. Involve me and I learn.” Ben Franklin.
Register to Reply
Guru

Join Date: Feb 2008
Location: Large hole formally occupied by furry woodland creature.
Posts: 3385
Good Answers: 97
#19
In reply to #18

Re: Creating a Wild Card Database Search

08/18/2015 4:49 PM

RAMConsult, thank you very much for the enlightenment. Now I can go forth and meet the dragon.

__________________
CRTL-Z
Register to Reply
Guru
Engineering Fields - Power Engineering - New Member

Join Date: May 2007
Location: NYC metropolitan area.
Posts: 3230
Good Answers: 444
#20
In reply to #19

Re: Creating a Wild Card Database Search

08/18/2015 6:27 PM

Wear fire resistant shorts and bring lots of beer! Good luck.

__________________
“Tell me and I forget. Teach me and I remember. Involve me and I learn.” Ben Franklin.
Register to Reply
Power-User
Hobbies - Musician - New Member

Join Date: Dec 2014
Posts: 418
Good Answers: 3
#14

Re: Creating a Wild Card Database Search

08/18/2015 10:43 AM

Of course its "&", if you could find one you get the other because they are inclusive.

__________________
"When I thought I exceeded to be wise but wisdom was far from me" -King Solomon
Register to Reply Score 2 for Off Topic
Register to Reply 20 comments
Copy to Clipboard

Users who posted comments:

Hendrik (1); Kulas (1); lyn (2); North of 60 (1); phph001 (1); PWSlack (1); RAMConsult (4); SolarEagle (2); Unredundant (7)

Previous in Forum: How Did This Happen?   Next in Forum: Has Anyone Switched to Windows 10

Advertisement