Oregon Records Management Solution

Search Clause Searching Can Sort Sorting
Type
Basic Metadata Only Selects Records based on a value for Basic Metadata Only. False
Record Class Selects Records based on a value for Record Class. True Sorts the results by Record Class. Append a '-' if you wish to sort from highest to lowest, eg. class-.
Record Type Selects Records based on a value for Record Type. True Sorts the results by Record Type. Append a '-' if you wish to sort from highest to lowest, eg. type-.
Text
Any Word Selects Records based on the word index for Any Word. False
Attached thesaurus term Selects Records that have the specified thesaurus term attached. False
Document Content Selects Records that have a document with contents matching the content index search clause supplied. False
IDOL Query Selects Records that match the specified IDOL query string. False
Notes Word Selects Records based on the word index for Record Notes. False
Title Word Selects Records based on the word index for Record Titles. False
Linked
All Containers Of Selects Records that are in the container hierarchy for the specified records False
All parts Of Selects Records that have in the same part series as the specified record False
All records With Relationship To Selects Records that have any relationship with the specified record (excludes parts, versions, series, alt container and SharePoint relationship types) False
All Versions Selects Records that have in the same version series as the specified record False
Alternatively Contains Selects Records that have the alternatively within relationship with the specified record False
Attached To Selects Records that have the attached to relationship with the specified record False
Container Selects Records based on a value for Container. True Sorts the results by Container. Append a '-' if you wish to sort from highest to lowest, eg. container-.
Container (Including Alternate) Selects Records that are contained within or are alternatively contained within the specified record False
Contains Selects Records that are a container for the specified records False
Contains (Including Alternate) Selects Records that are either a container or an alternative container for the specified records False
Content Block In Selects Records that have the is a document content block within relationship with the specified record False
Copy Of Selects Records that have the copy of relationship with the specified record False
Current Version of Selects Records that are the most recently finalized version of the specified record False
Derived From Selects Records that have the derived from relationship with the specified record False
First part Of Selects Records that have the first part of relationship with the specified record False
First Version Of Selects Records that have the first version of relationship with the specified record False
Has Alternative Container Selects Records that have the alternatively contains relationship with the specified record False
Has Attachment Selects Records that have the has attachment relationship with the specified record False
Has Content Block Selects Records that have the contains document content block relationship with the specified record False
Has Derivation Selects Records that have the derivations relationship with the specified record False
Has First part Selects Records that have the has first part of relationship with the specified record False
Has First Version Selects Records that have the has first version of relationship with the specified record False
Has Redaction Selects Records that have the was redacted to relationship with the specified record False
Has Reply Of Selects Records that have the has reply relationship with the specified record False
Has Same Client As Selects Records that share the same client as the specified record False
Has Same Contact As Selects Records that share the same contact as the specified record False
In Reply To Selects Records that have the reply to relationship with the specified record False
Is superseded by Selects Records that have the is superseded by relationship with the specified record False
Latest part Of Selects Records that are the latest part of the specified record False
Latest Version Of Selects Records that are the latest version of the specified record False
Matter Of Selects Records that are the Matter record of the specified records False
Original Of Selects Records that have the original of relationship with the specified record False
Redaction Of Selects Records that have the redaction of relationship with the specified record False
Related To Selects Records that have the related to relationship with the specified record False
Same Message Conversation As Selects Records that are in the same email message conversation as the specified record False
Series record For Selects Records that are a series record of the specified record False
Supersedes Selects Records that have the supersedes relationship with the specified record False
With Relationship To Selects Records that have the specified relationship with the specified records False
With Reverse Relationship To Selects Records that have the specified reverse record relationship with the specified records False
Within Series Selects Records that are in the specified series record False
Tray
Checked Out Documents Selects Records that you you have currently checked out for editing False
Content Blocks Selects Records that are in your favorite content blocks tray. False
Document Templates Selects Records that are in your favorite document templates tray. False
Favourite Selects favourite Records. False
Recent Containers Selects Records that are in your recently used containers tray. False
Recent Documents Selects Records that are in your recently accessed documents tray. False
Records Due Selects Records that you or your position have a current action or document review task to be completed. False
Records In Selects Records that you or your position are the current assignee of. False
Records In or Due Selects Records that you or your position are the current assignee of or have a current action or document review task to be completed. False
Records Work Tray Selects Records that are in your working records tray. False
With Label Selects Records with a specified User Label. False
Reference
Accession Number Selects Records based on a value for Accession Number. True Sorts the results by Accession Number. Append a '-' if you wish to sort from highest to lowest, eg. accession-.
Barcode Selects Records by barcode. False
Classification Selects Records based on a value for Classification. True Sorts the results by Classification. Append a '-' if you wish to sort from highest to lowest, eg. classification-.
Default Selects all Records based on a generic interpretation of a string value (usually by matching the name property). False
Expanded Number Selects Records based on a value for Expanded Number. True Sorts the results by Expanded Number. Append a '-' if you wish to sort from highest to lowest, eg. numberx-.
External ID Selects Records based on a value for External ID. True Sorts the results by External ID. Append a '-' if you wish to sort from highest to lowest, eg. external-.
Foreign Barcode Selects Records by foreign barcode. False
Record Number Selects Records based on a value for Record Number. True Sorts the results by Record Number. Append a '-' if you wish to sort from highest to lowest, eg. number-.
Unique Identifier Selects Records based on a unique identifier value. True Sorts the results by Unique Identifier. Append a '-' if you wish to sort from highest to lowest, eg. uri-.
Document
Checked In By Selects Records based on a value for Checked In By. True Sorts the results by Checked In By. Append a '-' if you wish to sort from highest to lowest, eg. checkedInBy-.
Checked In On Selects Records based on a value for Checked In On. True Sorts the results by Checked In On. Append a '-' if you wish to sort from highest to lowest, eg. checkedInOn-.
Checked Out On Selects Records based on a value for Checked Out On. True Sorts the results by Checked Out On. Append a '-' if you wish to sort from highest to lowest, eg. lockedOn-.
Checked Out To Selects Records based on a value for Checked Out To. True Sorts the results by Checked Out To. Append a '-' if you wish to sort from highest to lowest, eg. checkedOutBy-.
Date Modified Selects Records based on a value for Date Modified. True Sorts the results by Date Modified. Append a '-' if you wish to sort from highest to lowest, eg. editedOn-.
Document Is Missing Selects Records based on a value for Document Is Missing. False
Document Last Accessed Date Selects Records based on a value for Document Last Accessed Date. False
Document Store Selects Records based on a value for Document Store. True Sorts the results by Document Store. Append a '-' if you wish to sort from highest to lowest, eg. store-.
Edit Status Selects Records based on a value for Edit Status. False
Email Conversation ID Selects Records based on a value for Email Conversation ID. True Sorts the results by Email Conversation ID. Append a '-' if you wish to sort from highest to lowest, eg. conversationId-.
Email Message ID Selects Records based on a value for Email Message ID. True Sorts the results by Email Message ID. Append a '-' if you wish to sort from highest to lowest, eg. messageId-.
Extension Selects Records based on a value for Extension. True Sorts the results by Extension. Append a '-' if you wish to sort from highest to lowest, eg. extension-.
External Editing Complete Selects Records based on a value for External Editing Complete. False
External Editing Completed By Selects Records based on a value for External Editing Completed By. False
External Editor Id Selects Records based on a value for External Editor Id. False
From check in style Selects Records that are used by the specified check in style False
Has Email Attachments Selects Records based on a value for Has Email Attachments. False
Internet Media Type Selects Records based on a value for Internet Media Type. True Sorts the results by Internet Media Type. Append a '-' if you wish to sort from highest to lowest, eg. mime-.
Is Electronic Selects Records based on a value for Is Electronic. False
Offline Record Selects Records that are associated with the specified offline records False
Revision Details Selects Records with an associated Revision having selected property values. False
Revision Number Selects Records based on a value for Revision Number. True Sorts the results by Revision Number. Append a '-' if you wish to sort from highest to lowest, eg. revision-.
Size Selects Records based on a value for Size. True Sorts the results by Size. Append a '-' if you wish to sort from highest to lowest, eg. documentSize-.
View Counter Selects Records based on a value for View Counter. True Sorts the results by View Counter. Append a '-' if you wish to sort from highest to lowest, eg. views-.
Date
Date Closed Selects Records based on a value for Date Closed. True Sorts the results by Date Closed. Append a '-' if you wish to sort from highest to lowest, eg. closedOn-.
Date Created Selects Records based on a value for Date Created. True Sorts the results by Date Created. Append a '-' if you wish to sort from highest to lowest, eg. createdOn-.
Date Declared As Final Selects Records based on a value for Date Declared As Final. True Sorts the results by Date Declared As Final. Append a '-' if you wish to sort from highest to lowest, eg. finalisedOn-.
Date Imported Selects Records based on a value for Date Imported. True Sorts the results by Date Imported. Append a '-' if you wish to sort from highest to lowest, eg. imported-.
Date Last Updated Selects Records based on when they were last updated. True Sorts the results by Date Last Updated. Append a '-' if you wish to sort from highest to lowest, eg. updated-.
Date Published Selects Records based on a value for Date Published. True Sorts the results by Date Published. Append a '-' if you wish to sort from highest to lowest, eg. publishedOn-.
Date Received Selects Records based on a value for Date Received. True Sorts the results by Date Received. Append a '-' if you wish to sort from highest to lowest, eg. receivedOn-.
Date Registered Selects Records based on a value for Date Registered. True Sorts the results by Date Registered. Append a '-' if you wish to sort from highest to lowest, eg. registeredOn-.
Date Superseded Selects Records based on a value for Date Superseded. True Sorts the results by Date Superseded. Append a '-' if you wish to sort from highest to lowest, eg. supersededOn-.
Last Action Date Selects Records based on a value for Last Action Date. True Sorts the results by Last Action Date. Append a '-' if you wish to sort from highest to lowest, eg. actionedOn-.
Retention
Consignment Number Selects Records based on a value for Consignment Number. True Sorts the results by Consignment Number. Append a '-' if you wish to sort from highest to lowest, eg. consignmentNumber-.
Date archived (custody transferred) Selects Records that had disposition changed to archived (custody transferred) on the specified date. True Sorts the results by Date archived (custody transferred). Append a '-' if you wish to sort from highest to lowest, eg. transferredOn-.
Date archived (keep forever) Selects Records that had disposition changed to archived (keep forever) on the specified date. True Sorts the results by Date archived (keep forever). Append a '-' if you wish to sort from highest to lowest, eg. archivedOn-.
Date destroyed Selects Records that had disposition changed to destroyed on the specified date. True Sorts the results by Date destroyed. Append a '-' if you wish to sort from highest to lowest, eg. destroyedOn-.
Date Inactive Selects Records based on a value for Date Inactive. True Sorts the results by Date Inactive. Append a '-' if you wish to sort from highest to lowest, eg. inactiveOn-.
Date To archive (keep forever) Selects Records that are due to have a disposition change to archived (keep forever) on the specified date. True Sorts the results by Date To archive (keep forever). Append a '-' if you wish to sort from highest to lowest, eg. archiveOn-.
Date To archive (transfer custody) Selects Records that are due to have a disposition change to archived (custody transferred) on the specified date. True Sorts the results by Date To archive (transfer custody). Append a '-' if you wish to sort from highest to lowest, eg. transferOn-.
Date To destroy Selects Records that are due to have a disposition change to destroyed on the specified date. True Sorts the results by Date To destroy. Append a '-' if you wish to sort from highest to lowest, eg. destroyOn-.
Date To destroy (no holds) Selects Records that are due to have a disposition change to destroyed on the specified date (and are not on hold). True Sorts the results by Date To destroy (no holds). Append a '-' if you wish to sort from highest to lowest, eg. destroyOnNoHold-.
Date To make inactive Selects Records that are due to have a disposition change to inactive on the specified date. True Sorts the results by Date To make inactive. Append a '-' if you wish to sort from highest to lowest, eg. makeInactiveOn-.
Disposition Selects Records based on a value for Disposition. True Sorts the results by Disposition. Append a '-' if you wish to sort from highest to lowest, eg. disposition-.
Has Hold Attached Selects Records based on a value for Has Hold Attached. True Sorts the results by Has Hold Attached. Append a '-' if you wish to sort from highest to lowest, eg. hasHold-.
Hold Selects Records that are associated with the specified hold False
Jurisdiction Selects Records that have the specified jurisdiction. False
Retention Review Date Selects Records based on a value for Retention Review Date. True Sorts the results by Retention Review Date. Append a '-' if you wish to sort from highest to lowest, eg. review-.
Retention schedule Selects Records based on a value for Retention schedule. True Sorts the results by Retention schedule. Append a '-' if you wish to sort from highest to lowest, eg. schedule-.
Review Status Selects Records that have a review date set indicating the desired review status False
Scheduled Disposal Status Selects Records based on a value for Scheduled Disposal Status. True Sorts the results by Scheduled Disposal Status. Append a '-' if you wish to sort from highest to lowest, eg. scheduleStatus-.
Location
Addressee Selects Records that have an addressee of the specified location True Sorts the results by Addressee. Append a '-' if you wish to sort from highest to lowest, eg. addressee-.
Assignee Selects Records based on a value for Assignee. True Sorts the results by Assignee. Append a '-' if you wish to sort from highest to lowest, eg. assignee-.
Assignee Details Selects Records with an associated assignee having selected property values False
At Home Selects Records that are at home (i.e. assignee is same as home) False
Author Selects Records that have an author of the specified location True Sorts the results by Author. Append a '-' if you wish to sort from highest to lowest, eg. author-.
Authorizer Selects Records that have an authorizer of the specified location True Sorts the results by Authorizer. Append a '-' if you wish to sort from highest to lowest, eg. authorizer-.
Blind Copied Selects Records that have the specified location in the bcc contacts list True Sorts the results by Blind Copied. Append a '-' if you wish to sort from highest to lowest, eg. bcc-.
Client Selects Records that have a client contact of the specified location True Sorts the results by Client. Append a '-' if you wish to sort from highest to lowest, eg. client-.
Contact Details Selects Records with an associated Contact having selected property values. False
Contact location Selects Records that have a contact attached matching the location details specified. True Sorts the results by Contact location. Append a '-' if you wish to sort from highest to lowest, eg. contact-.
Copied Selects Records that have the specified location in the cc contacts list True Sorts the results by Copied. Append a '-' if you wish to sort from highest to lowest, eg. cc-.
Creator Selects Records based on a value for Creator. True Sorts the results by Creator. Append a '-' if you wish to sort from highest to lowest, eg. creator-.
Editor Selects Records that have an editor of the specified location True Sorts the results by Editor. Append a '-' if you wish to sort from highest to lowest, eg. editor-.
GPS Location Selects Records based on a value for GPS Location. True Sorts the results by GPS Location. Append a '-' if you wish to sort from highest to lowest, eg. gps-.
Home Selects Records based on a value for Home. True Sorts the results by Home. Append a '-' if you wish to sort from highest to lowest, eg. home-.
Home Details Selects Records with an associated home having selected property values False
In Holding Bay Selects Records based on a value for In Holding Bay. False
In space Selects Records based on a value for In space. True Sorts the results by In space. Append a '-' if you wish to sort from highest to lowest, eg. space-.
In space Or Holding Bay Selects Records based on a value for In space Or Holding Bay. False
Last Updated By Selects Records based on who they were last updated by. True Sorts the results by Last Updated By. Append a '-' if you wish to sort from highest to lowest, eg. updatedBy-.
Other contact Selects Records that have an other type of contact of the specified location False
Owner Selects Records based on a value for Owner. True Sorts the results by Owner. Append a '-' if you wish to sort from highest to lowest, eg. owner-.
Record Location Details Selects Records with an associated record location having selected property values False
Representative Selects Records that have a representative of the specified location True Sorts the results by Representative. Append a '-' if you wish to sort from highest to lowest, eg. representative-.
Reviewer Selects Records that have a reviewer of the specified location True Sorts the results by Reviewer. Append a '-' if you wish to sort from highest to lowest, eg. reviewer-.
Process
Activity Selects Records that are associated with the specified activity False
Date Due Selects Records based on a value for Date Due. True Sorts the results by Date Due. Append a '-' if you wish to sort from highest to lowest, eg. dueOn-.
Document Review State Selects Records based on a value for Document Review State. True Sorts the results by Document Review State. Append a '-' if you wish to sort from highest to lowest, eg. reviewState-.
External Workflow Case Selects Records that are cases for the specified external workflows False
External Workflow Initiated Selects Records that are initiating records for the specified external workflows False
Priority Selects Records based on a value for Priority. True Sorts the results by Priority. Append a '-' if you wish to sort from highest to lowest, eg. priority-.
Record Action Selects Records that have the specified action(s) attached False
Scheduled Task Selects Records that have the specified vital review task(s) attached False
To Do Item Selects Records referenced by the specificed to do item. False
Workflow Selects Records that are associated with the specified workflow False
Rm
Attached thesaurus term Details Selects Records with an associated Attached thesaurus term having selected property values. False
Automated Part Rule Selects Records based on a value for Automated Part Rule. True Sorts the results by Automated Part Rule. Append a '-' if you wish to sort from highest to lowest, eg. partRule-.
Communication Selects Records that were associated with the specified communication False
Due for Return On Selects Records due for return by a specified date. True Sorts the results by Due for Return On. Append a '-' if you wish to sort from highest to lowest, eg. returnOn-.
Enclosed Selects Records that have a container and are enclosed in that container False
Folder Origin Selects Records based on a value for Folder Origin. True Sorts the results by Folder Origin. Append a '-' if you wish to sort from highest to lowest, eg. folderOrigin-.
Has Contents Selects Records based on a value for Has Contents. True Sorts the results by Has Contents. Append a '-' if you wish to sort from highest to lowest, eg. hasContents-.
Media Type Selects Records based on a value for Media Type. True Sorts the results by Media Type. Append a '-' if you wish to sort from highest to lowest, eg. media-.
Missing Selects Records that have an unknown assignee False
Request Selects Records that are associated with the specified request False
Requested By Selects Records that have been requested by the specified location False
Requested On Selects Records that have been requested on the specified date/time False
Security
Access Control Selects Records having selected locations in a particular access control. False
Access From Container Selects Records that have the specified access control(s) set as 'Same as Container' False
Active Audit Event Selects Records that are involved with the specified Active Audit Event. False
Can Use Classification Selects Records based on a value for Can Use Classification. False
Classified By Selects Records that have classified security that has been classified by the specified person False
Classifying Agency Selects Records that have classified security that has been classified by the specified agency False
CS Declassified By Selects Records that have classified security that was declassified by the specified locations False
CS Declassified On Selects Records that have classified security that was declassified in a specified date range False
CS Declassify Event Selects Records that have classified security that needs to be declassified according the specified event text False
CS Downgrade Event Selects Records that have classified security that needs to be downgraded according the specified event text False
CS Downgraded By Selects Records that have classified security that was downgraded by the specified locations False
CS Downgraded On Selects Records that have classified security that was downgraded in a specified date range False
CS Latest Security Change Type Selects Records that have classified security that was upgraded by the specified locations True Sorts the results by CS Latest Security Change Type. Append a '-' if you wish to sort from highest to lowest, eg. CS_changeType-.
CS Upgraded By Selects Records that have classified security that was upgraded by the specified locations False
CS Upgraded On Selects Records that have classified security that was upgraded in a specified date range False
CS: Declassify On Selects Records based on a value for CS: Declassify On. False
CS: Downgrade On Selects Records based on a value for CS: Downgrade On. False
CS: Security At Registration Selects Records based on a value for CS: Security At Registration. False
Derived From Selects Records that have classified security derived from a particular source False
Downgrade Instructions Selects Records that have classified security with the specified downgrade instructions False
Locations Excluded Selects Records having selected locations in the exclusions list. False
Reason(s) for Classification Selects Records that have classified security with a particular reason False
Reason(s) for Update Selects Records that have classified security that was updated for the specified reason False
Security Caveat Selects Records that have the specified security caveat False
Security Guide Entry Selects Records that have security set up from the specified security guide entry entry False
Security Last Updated By Selects Records that have classified security that has been updated by the specified location False
Security Last Updated Date Selects Records that have classified security that has been updated on the specified date False
Security Level Selects Records that have the specified security level False
Security Level At Registration Selects Records that have classified security with the nominated security level at registration False
Security Reviewed By Selects Records that have classified security that has been reviewed by the specified location False
Security Reviewed Date Selects Records that have classified security that has been reviewed on the specified date False
SharePoint
Has SharePoint Site Selects Records that have the contains sharepoint list or site relationship with the specified record False
In SharePoint List Selects Records that represent SharePoint list items within the nominated SharePoint list. False
SharePoint GUID Selects Records based on a value for SharePoint GUID. True Sorts the results by SharePoint GUID. Append a '-' if you wish to sort from highest to lowest, eg. spGUID-.
SharePoint List Selects Records that represent the SharePoint List for the specified SharePoint items False
SharePoint List Item ID Selects Records that represent a SharePoint List Item with the nominated ID. False
SharePoint List URL Selects Records that represent a SharePoint List Item with the nominated URL. False
SharePoint Object Type Selects Records that are the specified type of SharePoint object. False
SharePoint Record Selects Records that manage the specified SharePoint items False
SharePoint Server Farm ID Selects Records based on a value for SharePoint Server Farm ID. True Sorts the results by SharePoint Server Farm ID. Append a '-' if you wish to sort from highest to lowest, eg. spFarmGUID-.
SharePoint Site Collection ID Selects Records that represent a SharePoint Site within the nominated site collection. True Sorts the results by SharePoint Site Collection ID. Append a '-' if you wish to sort from highest to lowest, eg. spSiteCollectionGUID-.
SharePoint URL Selects Records based on a value for SharePoint URL. True Sorts the results by SharePoint URL. Append a '-' if you wish to sort from highest to lowest, eg. spURL-.
Within SharePoint Site Selects Records that have the within sharepoint site relationship with the specified record False
Other
All Selects all Records within this dataset. False
Batch Number Selects Records by calculating a batch number based on the unique row identifier of the object. Requires a batch number and a number of batches parameters. False
Final Selects Records that have been finalized. False
Full Title Selects Records based on a value for Full Title. True Sorts the results by Full Title. Append a '-' if you wish to sort from highest to lowest, eg. combinedTitle-.
Meeting Selects Records associated with the specified meeting. False
None Selects no Records. False
Originated From Selects Records based on a value for Originated From. False
Originated From Run Selects Records based on a value for Originated From Run. True Sorts the results by Originated From Run. Append a '-' if you wish to sort from highest to lowest, eg. originRun-.
Saved Search Selects Records that satisfy a specified saved search. False
SDM Environment ID Selects Records based on a value for SDM Environment ID. False
SDM File Name Selects Records based on a value for SDM File Name. False
SDM Folder Name Selects Records based on a value for SDM Folder Name. False
SDM Run ID Selects Records based on a value for SDM Run ID. False
Title (Free Text Part) Selects Records based on a value for Title (Free Text Part). True Sorts the results by Title (Free Text Part). Append a '-' if you wish to sort from highest to lowest, eg. typedTitle-.
Title (Structured Part) Selects Records based on a value for Title (Structured Part). True Sorts the results by Title (Structured Part). Append a '-' if you wish to sort from highest to lowest, eg. generatedTitle-.
ClientMatter
Client Of Selects Records that are the Client record of the specified records False
Client record Selects Records based on a value for Client record. True Sorts the results by Client record. Append a '-' if you wish to sort from highest to lowest, eg. clientRecord-.
Client/Matter Party Selects Records that have the specified location attached as an interested party. False
Client/Matter Party Details Selects Records with an associated Client/Matter Party having selected property values. False
Client/Matter Role Selects Records that have the specified location attached as playing a role for the client. False
Client/Matter Role Details Selects Records with an associated Client/Matter Role having selected property values. False
Matter record Selects Records based on a value for Matter record. True Sorts the results by Matter record. Append a '-' if you wish to sort from highest to lowest, eg. matterRecord-.