Timeout when searching by OTEmailReceivedDate

Jonathon_Riley

Hi,

I'm doing a search through livelink, but the search keeps timing out. I know that the search result set should be less then 4, and the search works when I don't filter by OTEmailDate. Here's an example of the search query:

lookfor1=complexquery&where1=Attr_31142945_2: *My Project* AND OTSubTypeName:E-Mail AND-NOT OTLocation:1987248 AND OTEmailReceivedDate < 20100517

Is there something wrong with that query? OTEmailReceivedDate is definitely marked as searchable, and like I said searching on other OTEmail properties works. I increased the timeout period to 3 minutes to no effect.

 Also one further question, what's the best way to specify a date range? just an OTEmaiLReceivedDate > startDate and OTEmailReceivedDate < endDate? I saw the range keyworld but that was for a different livelink query language.

 

Thanks in advance

Kyle_Swidrovich

Hi Jonathon,

 

The timeout you’re getting willprobably occur through a standard browser-based search as well.

For this reason, you probably want to takethis to an alternate forum.

 

However, I’ll just mention here thata left+right truncation (*My Project*) will be expensive to execute.

The additional OTEmailReceivedDate clauseis probably just pushing it over the edge.

For a detailed analysis of why thatparticular query is timing out, I’d recommend contacting Open TextCustomer Support.

They’ll need both Search Federatorand Search Engine logs at Info level.

 

Regards,

Kyle