Incorrect search results being returned

Posted on 2003-03-14
Medium Priority
Last Modified: 2013-12-18
If a dynamically built FTSearch query in the following format (all UK date formats, dd/mm/yyyy, server is UK dates as well):

([DateToday_HD] >= 01/02/2003 or [Created] >= 01/02/2003 or [Date_Submitted] >= 01/02/2003) and [Brand] = "Smirnoff*"

This returns some records, but not all that I would expect. I can't see any difference between the records being returned and those that are not from a data type and content POV.

An example record that is not being returned has the following values:
DateToday_HD: 03/02/2003 (date field)
Created: 03/02/2003 12:45:40 (date field)
Date_Submitted: blank (date field)
Brand: Smirnoff Citrus Twist (text field)

I have had the FTIndex rebuilt, in case there was a corruption, but still no luck.

Any pointers gratefully received.

Question by:bjohns33
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3

Expert Comment

ID: 8135463
(([DateToday_HD] >= 01/02/2003) or ([Created] >= 01/02/2003) or ([Date_Submitted] >= 01/02/2003)) and [Brand] = "Smirnoff*"

this will return all those with the right date as long as the brand is Smirnoff*

It looks to me like its an order of operations specificity problem.  Try the above formula and see if it helps.

You can play with this in teh full text search bar until it works right before embeddeing it in your agent code.

Expert Comment

ID: 8135597
You might even try this:

((([DateToday_HD] >= 01/02/2003) or ([Created] >= 01/02/2003) or ([Date_Submitted] >= 01/02/2003))) and [Brand] = "Smirnoff*"
LVL 63

Accepted Solution

Zvonko earned 2000 total points
ID: 8138182
I can not improve Andrew's answer.

I have only one testing idea: create a view with similar view condition and look what exact documents you would get. There are often circumstances you did not take in account.

Give it a try.



Expert Comment

ID: 8154159
Did you need more help?

Please see this scale for grading, as recommended by the E.E. system (it is not intuitive).


How Do I Know What Grade to Give?

Although we use an A-D scale here at Experts Exchange, it works differently than, say, school grades. If one or more Experts' proposals are accepted as answers, they should usually be given an A or B grade, since they have taken the time to provide you with a working solution. If a possible solution is incomplete - ask for clarification or details before accepting the answer and grading it. People should not be given lower grades because of incorrect grammar or because you just accepted their answer or comment to close the question. Keep in mind, your question and any follow-up comments should be focused so that there can be a specific answer. The following is a good guideline to follow when grading:

A: The Expert(s) either provided you with a thorough answer or they provided you with a link to information that thoroughly answered your question. An "A" can also be given to any answer that you found informative or enlightening beyond the direct question that you asked.

B: The Expert(s) provided an acceptable solution, or a link to an acceptable solution, that you were able to use, although you may have needed a bit more information to complete the task.

C: Because Experts' reliability are often judged by their grading records, many Experts would like the opportunity to clarify if you have questions about their solutions. If you have given the Expert(s) ample time to respond to your clarification posts and you have responded to each of their posts providing requested information; or if the answers, after clarification, lack finality or do not completely address the issue presented, then a "C" grade is an option. You also have the option here of just asking Community Support to delete the question.

Remember, the Expert helping you today is probably going to be helping you next time you post a question. Give them a fair chance to earn an 'Excellent!' grade and they'll provide you with some amazing support.


Author Comment

ID: 8154347
Thanks Andrew and Zvonko.

The query was fine, Zvonko's answer pointed me in the right direction, which was bad target data - was trying to resolve this without the Notes client (accessing data from Excel, with no client access) which made it trickier to track down data issues.


Featured Post

Enroll in August's Course of the Month

August's CompTIA IT Fundamentals course includes 19 hours of basic computer principle modules and prepares you for the certification exam. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This is an old article, please see an updated version of this article, located here: http://www.experts-exchange.com/articles/23619/Notes-8-5x-Windows-7-Notes-info-and-tips.html
Article by: Rob
Notes 8.5 Archiving Steps and Tips This article covers setting up a Notes archive, and helps understand some of the menu choices making setting up and maintaining a Notes archive file easier.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
Suggested Courses

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question