Thursday, April 01, 2004

Logical groupings for confidence-based search

Leon's interpretation is almost correct. 2 different types of queries
are fired based on the confidence level. For a 100 % confidence fields
within a logical group are ANDed (I believe that's the technical term).
The sub queries are then once again ANDed to each other.

For the < 100 % search, a sub query is created for every single query
parameter. The sub queries are then UNIONed with each other.

All provider queries use this exact same logic.

However, on the problem with the WL PC versus Address PC, each sub query
in the case of the WL fields, i.e Postal Code, City, etc. (for all
confidence levels), should also use the 'WL_ID IS NOT NULL' clause and
for Address fields, should use the 'WL_ID' IS NULL' clause.

Logical groupings


And one more question: since Telecommunication Numbers and Electronic
Addresses can also be associated with a work location, but do not have
separate fields on the search form, I wanted to confirm that the
searches
for these objects will be across the work locations and non work
location
objects.

Yes, the Telecommunication Numbers and Electronic Address criteria are
used to search across work location and non work location objects.

Rajeev Ayer




One question re. the < 100% confidence search. Can you please confirm that the sub query is taking the confidence level into account, i.e. that this version of the search is working the same way it did in 2.05? Thank you.
Yes it does.

Comments: Post a Comment



<< Home

This page is powered by Blogger. Isn't yours?