Project Asset Queries

Please refer to the examples below to search for assets using specific criteria with the Reach Query Language (RQL). As you read through them, log in and search for assets using these examples to guide your search.

For additional Metadata query guidance, refer to the Querying for Reach Engine Metadata fields section.

ID (Reach Asset ID)

_id = 4347

Type (Data Object Type)

_type like 'Project'

Inventory Key (Asset Type)

inventoryKey like 'project'
inventoryKey = 'project'

Inventory Type Name (Asset Type)

inventoryTypeName like 'project'
inventoryTypeName = 'project'

Name (Asset Name)

name like 'ProjectName' ← Full Name of Asset
name like 'jectNa' ← Partial Search against Name of Asset

System Keywords (Asset Name)

systemKeywords = 'Project Asset Name'

Date Created (Date of Asset Ingest)

dateCreated gt '2019-01-01'
dateCreated lt '2019-01-01'
dateCreated gte '2019-01-01'
dateCreated lte '2019-01-01'
dateCreated between '2019-01-01' and '2019-04-04'

Date Updated (Date the Asset last had Metadata Updated)

dateUpdated gt '2019-01-01'
dateUpdated lt '2019-01-01'
dateUpdated gte '2019-01-01'
dateUpdated lte '2019-01-01'
dateUpdated between '2019-01-01' and '2019-04-04'

Status (Is the Project Available? Or in a Locked state)

status = 'AVAILABLE'
status = 'LOCKED'

Source File Path (Location of the Source File on the File System)

sourceFilePath like '/mezzanines/2019/09/20/01/'

Collection Memberships (Denotes the Assets Association to a Collection by Collection ID)

collectionMemberships = '24901'
collectionMemberships != '24901'
collectionMemberships in ('24901','24902')
collectionMemberships not in ('24901','24902')

UUID (UUID Created during Ingest Process)

uuid = '41a419c0-3eb6-4c2d-bc75-d1b4c949f487'

Metadata Set ID (Find the Asset Associated to a Metadata Set by ID)

metadata_id = 1033038847

Locked (Denotes if the Project is Currently Locked by Another User)

Project.locked = true
Project.locked = false

Locked By (Denotes the User Information for the User that has the Project Locked)

Example of fully stored data in ES:

"lockedBy":{"middleName":null,"id":921,"lastName":"Rinagl","username":"grinagl","emailAddress":"Guenther.Rinagl@redbull.com","firstName":"Guenther"}

You cannot RQL against any of the information in that JSON. However, you can determine if it's null or not null:

Project.lockedBy is null
Project.lockedBy is not null

Contents Archived Flag (Denotes whether ALL the Assets within a Project are Archived)

Project.contentsArchivedFlag = false
Project.contentsArchivedFlag = true

NLE Type (Non-Linear Editor that the Project was Created From)

nleType = 'PREMIERE'