How to construct SQL Filter for export task?

You can use the filter to limit items to be exported. Filter can be applied by clicking "Edit Filter" in additional tasks, or by specifying it in command line.

Filter syntax is similar to SQL query WHERE part. Filter example - LastName = 'Smith' and LastModificationTime

Here is a complete list of properties that can be specified:

  • ActualWork
  • AllDayEvent
  • AlternateRecipientAllowed
  • Anniversary
  • AssistantName
  • AssistantTelephoneNumber
  • Attachments
  • AutoForwarded
  • BCC
  • BillingInformation
  • Birthday
  • Body
  • Business2TelephoneNumber
  • BusinessAddress
  • BusinessAddressCity
  • BusinessAddressCountry
  • BusinessAddressPostalCode
  • BusinessAddressPostOfficeBox
  • BusinessAddressState
  • BusinessAddressStreet
  • BusinessFaxNumber
  • BusinessHomePage
  • BusinessTelephoneNumber
  • BusyStatus
  • CallbackTelephoneNumber
  • CardData
  • CarTelephoneNumber
  • Categories
  • CC
  • CheckSum
  • Children
  • Color
  • Companies
  • CompanyMainTelephoneNumber
  • CompanyName
  • Complete
  • ComputerNetworkName
  • ConferenceServerAllowExternal
  • ConferenceServerPassword
  • ContactAccount
  • ContactNames
  • ConversationIndex
  • ConversationTopic
  • CreationTime
  • CustomerID
  • DateCompleted
  • DeferredDeliveryTime
  • DelegationState
  • Delegator
  • DeleteAfterSubmit
  • Department
  • DLName
  • DueDate
  • Duration
  • Email1Address
  • Email1AddressType
  • Email1DisplayName
  • Email1EntryID
  • Email2Address
  • Email2AddressType
  • Email2DisplayName
  • Email2EntryID
  • Email3Address
  • Email3AddressType
  • Email3DisplayName
  • Email3EntryID
  • End
  • EndInEndTimeZone
  • EndUTC
  • EntryID
  • ExpiryTime
  • FileAs
  • FirstName
  • FlagDueBy
  • FlagIcon
  • FlagRequest
  • FlagStatus
  • FTPSite
  • FullName
  • Gender
  • GlobalAppointmentID
  • GovernmentIDNumber
  • HasPicture
  • Height
  • HidePaperClip
  • Hobby
  • Home2TelephoneNumber
  • HomeAddress
  • HomeAddressCity
  • HomeAddressCountry
  • HomeAddressPostalCode
  • HomeAddressPostOfficeBox
  • HomeAddressState
  • HomeAddressStreet
  • HomeFaxNumber
  • HomeTelephoneNumber
  • IMAddress
  • Importance
  • Initials
  • InternetCodepage
  • InternetFreeBusyAddress
  • ISDNNumber
  • IsOnlineMeeting
  • IsRecurring
  • IsRecurring
  • JobTitle
  • Journal
  • Language
  • LastModificationTime
  • LastName
  • Left
  • Location
  • MailingAddress
  • MailingAddressCity
  • MailingAddressCountry
  • MailingAddressPostalCode
  • MailingAddressPostOfficeBox
  • MailingAddressState
  • MailingAddressStreet
  • ManagerName
  • MeetingStatus
  • MeetingWorkspaceURL
  • MessageClass
  • MiddleName
  • Mileage
  • MobileTelephoneNumber
  • NetMeetingAutoStart
  • NetMeetingDocPathName
  • NetMeetingOrganizerAlias
  • NetMeetingServer
  • NetMeetingType
  • NetShowURL
  • NickName
  • NoAging
  • OfficeLocation
  • OptionalAttendees
  • Ordinal
  • OrganizationalIDNumber
  • Organizer
  • OriginatorDeliveryReportRequested
  • OtherAddress
  • OtherAddressCity
  • OtherAddressCountry
  • OtherAddressPostalCode
  • OtherAddressPostOfficeBox
  • OtherAddressState
  • OtherAddressStreet
  • OtherFaxNumber
  • OtherTelephoneNumber
  • OutlookInternalVersion
  • OutlookVersion
  • Owner
  • Ownership
  • PagerNumber
  • PersonalHomePage
  • PrimaryTelephoneNumber
  • Profession
  • RadioTelephoneNumber
  • ReadReceiptRequested
  • ReceivedByEntryID
  • ReceivedByName
  • ReceivedOnBehalfOfEntryID
  • ReceivedOnBehalfOfName
  • ReceivedTime
  • RecipientReassignmentProhibited
  • Recipients
  • ReferredBy
  • ReminderMinutesBeforeStart
  • ReminderOverrideDefault
  • ReminderPlaySound
  • ReminderSet
  • ReminderSoundFile
  • ReminderTime
  • ReplyRecipientNames
  • ReplyTime
  • RequiredAttendees
  • Resources
  • ResponseRequested
  • ResponseStatus
  • Role
  • SaveSentMessageFolder
  • SchedulePlusPriority
  • SelectedMailingAddress
  • SenderEmailAddress
  • SenderEmailType
  • SenderEntryID
  • SenderName
  • Sensitivity
  • Sent
  • SentOn
  • SentOnBehalfOfEmailAddress
  • SentOnBehalfOfEmailType
  • SentOnBehalfOfEntryID
  • SentOnBehalfOfName
  • Size
  • Spouse
  • Start
  • StartDate
  • StartInStartTimeZone
  • StartUTC
  • Status
  • StatusOnCompletionRecipients
  • StatusUpdateRecipients
  • Subject
  • Submitted
  • Suffix
  • TeamTask
  • TelexNumber
  • Title
  • To
  • Top
  • TotalWork
  • TTYTDDTelephoneNumber
  • UnRead
  • User1
  • User2
  • User3
  • User4
  • VotingResponse
  • WebPage
  • Width
  • YomiCompanyName
  • YomiFirstName
  • YomiLastName