Kbase P37224: Cannot define CONTAINS clause for a lookup against a word in
Autor |
  Progress Software Corporation - Progress |
Acesso |
  Público |
Publicação |
  14/08/2003 |
|
Status: Unverified
SYMPTOM(s):
Cannot define CONTAINS clause for a lookup against a word indexed displayed field
CAUSE:
With Dynamic Lookups a property is needed to determine the operator for the
lookup. Now for character fields, only "BEGINS" is possible (this is hard-coded). It should also be possible to select e.g. "CONTAINS".
This would be very useful when the display field can hold multiple words such as FirstName + LastName.
Replacing the BEGINS by a CONTAINS in the source code works just fine. So it would then be rather easy to just implement a new property at the Dynamic Lookup Master/Instance level. This property has to be used by adm2/lookup.p and ry/obj/rylookupbv.w.
CAUSE:
Bug# 20030814-024
FIX:
This has been logged as an enhancement request.