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