Sunday, February 26, 2012

EZ Notes Search Modifiers/Filters

Our EZ Notes Search product enables the user to search their local IBM Lotus Notes databases using Microsoft Windows Search.   

The Advanced Query Syntax is documented in the Windows Search help on your system.  To find the syntax:
  • Windows XP - Click on the magnifying glass in the system tray, then Help and then Advanced Query Syntax
  • Windows 7 - Click on the Start Button, then Help and Support.  In the search box, type: "Advanced Tips for Searching in Windows" and then select the "Advanced Tips for Searching in Windows" topic
  •  Windows 8 - Open File Explorer, then click in the Search box.  A new tab, "Search Tools" appears which gives you access to some filters.  The filters documented below also appear to work.
Windows Search gives you some great features including the ability to provide multiple search filters to narrow down your search.  For example you can search for messages from Tom by using the from filter: from:Tom.  Also you can find emails from last week by typing received:last week or find appointments for today by using startdate:today.  If you want to find a document that's an attachment use isattachment:Yes.  There are other filters available, see the table below.

Of course, the user can simply type in the text they are looking for and Windows Search will look for that text in files on the file system, messages, calendar entries,  in their mail files and mail archives (including the message body), and their attachments (if they have needed filters which often come with the application that produced the file). 

There is a free trial of EZ Notes Search available here.

If you want to also search your contacts, journal notebook, discussion databases, document libraries or team rooms, we have a version which let you do that as well: EZ Notes Search: Mail, Archives and Applications.

The search filtering is done through the use of the Microsoft Windows property definitions.  EZ Notes Search maps Notes document items to the corresponding Windows properties.  This article documents which properties EZ Notes Search provides and an example for how that information might be used to filter search results.  The following table is for the EZ Notes Search: Mail and Archives version of our product.


Windows Property
Example(s)
Description
Note Source Item
System.Subject
subject:Sockets
Subject or title of the mail message, document or attachment
Subject (if empty, puts “no subject”
System.Message.HasAttachments
hasattachment:No
Indicates if this message or document has an attachment
Yes if the document has attachments, No otherwise
System.IsAttachment
isattachment:Yes
Finds documents which are attachments
Yes for attachments, No otherwise
System.Search.Store
store:ezn

Will find only messages, documents and attachments added by EZ Notes Search
Is always the protocol name: EZN for documents we add to the index
System.Startdate
startdate:today
startdate:tomorrow

Finds calendar items that start on a particular day
StartDateTime or EndDateTime
System.EndDate
enddate:tomorrow
Finds calendar items that end on a particular day
EndDateTime
System.ItemNameDisplay
name:party
Finds documents based on the displayed name field
Same as Subject
System.ItemType
type:EZN/Message
Used to find documents by their type
Depending on the Form Item is one of: EZN/Message, EZN/Appointment, EZN/Meeting, EZN/ToDo,
EZN/Attachment
System.Kind
kind:document
Allows you to filter on the kind of document
Depending on the Form item is one of “email”, “calendar” or “task”.  For attachments it is “document”
System.Size
size:small
Allows you to filter based on the size of the document, message, attachment or file
The size of the Note Document
System.DateModified
datemodified:yesterday
This is used to find the most appropriate date to display
Is either “DeliveredDate”, “PostedDate” or the modification date of the note when it was last indexed
System.FromName
from:Dieter
The author of the mail message or calendar item.
From
System.Author
author:Dieter
The author of the mail message or calendar item.
Same as System.From
System.FileName
filename:myattach.txt
The original filename of the attachment.
Only set on Attachments to the original filename.  Extracted from the Rich Text Field which references it.  If not found in a Rich Text field, the $File value is used.
System.ItemPathDisplay
title:welcome
This is the default Title property displayed on Windows XP in the search results window (different from Windows 7)
On Windows XP this is set to the same value as System.Subject
System.ParsingName
parsingname:8888
Can be used to find a note by its ID
Note ID of the document or NoteId#AttNum for Attachments
System.Calendar.Location
location:teleconference
The location of a meeting
Location
System.Message.DateReceived
received:last week
The date a message was delivered to your mail file
DeliveredDate
System.Message.DateSent
sent:earlier this month
The date a message was posted for mailing
PostedDate
System.Message.ToName
to:Tom
The recipient names
SendTo
System.Message.ToAddress
toaddress:company.com
The smtp recipient addresses
InetSendTo
System.Message.CcName
cc:Mary
The cc’ed names
CopyTo
System.Message.CcAddress
ccaddress:company.com
The smtp cc addresses
InetCopyTo

No comments:

Post a Comment