Searchproblem

Andre_Sovde

I'm having some trouble retrieving documents based upon creation date. I've uploaded a document which i'm able to retrieve using search when i set the ResultSetSpec to where1=documentname, but when i try to search for the document using a daterange the search won't retrieve it. Here's the code:

               SearchService.SingleSearchRequest query = new SearchService.SingleSearchRequest();
                query.DataCollectionSpec = "'LES Documents'";         // use the Enterprise search slice
                query.QueryLanguage = "Livelink Search API V1";         // use the Search API for queries
                query.FirstResultToRetrieve = 1;                        // start retrieving results at Result #1
                query.NumResultsToRetrieve = 7;                         // retrieve up to 5 search results
                query.ResultOrderSpec = "sortByRegion=OTCreatedBy";     // sort by the OTCreatedBy region
                //query.ResultSetSpec = "where1=" + whereClause;        // set the where clause of the query
                query.ResultSetSpec = "where1=\"<OTObjectDate>\"range\"20070713~2007071\"&lookfor1=otstarts";

                query.ResultTransformationSpec = new string[] { "Score", "OTName", "OTLocation", "OTObjectDate" };      // set the displayed/retrieved regions for each result

                // Execute the search
                SearchService.SingleSearchResponse results = ss.Search(ssOTAuth, query, "");

I've made sure that the processes which converts the documents so that they're indexed has finished running.

Does anyone have a suggestion to what might be wrong?

sgrasley

Hi, Andre.

Do you get an exception when trying to perform the search?

I notice that the second date in your range is malformed.  Perhaps adjusting that would resolve the problem.  If not, would using this query format instead?

query.ResultSetSpec = "where1=[region \"OTObjectDate\"] range \"20070713~20070715\"&lookfor1=otstarts";

Thanks,

Scott