enter a "title"(free text-string) and may enter the following optional
fields: "title acronym"(free text-string), "agency"(select box-int), and
"bureau"(select box-int). What I would like to do before inserting a new
opportunity is to check to see if maybe they are entering an opportunity
that has already been identified. I can easily say give me all the records
where the AGENCY_ID and BUREAU_ID are EQ to the ones identified, but I need
to incoroporate the free text title and title acronym fields; but how? Would
it be best to strip out all non relevant words like: the, a, an, in, on,
that, this, etc... And select the records LIKE '%TITLE%' OR LIKE
'%TITLE_ACRONYM%'. It seems that I could almost benefit from some kind of
searching/scoring routine, but that might be overkill. Does anyone have some
creative ideas on how to approach this?
An example of something I would like to catch would be:
AGENCY_ID: 1
BUREAU_ID: 33
TITLE: "IRAQ TELECOMMUNICATIONS SUPPORT"
TITLE ACRONYM: "ITS"
AGENCY_ID: 1
BUREAU_ID:
TITLE: "TELECOM SUPPORT IN IRAQ"
TITLE_ACRONYM: "IT SUPPORT"
Notice that the first entry the user knew the bureau yet in the second they
did not... Which leads me to think that maybe I should only concern myself
with TITLE and TITLE_ACRONYM.
Once I figure out the best way to select potential duplicates, I will
present them to the user to either choose one from to edit, or continue on
adding the one they initially were attempting to insert.
Thoughts? Thanks!
Mike T
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
