Audio Asset Master 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 = 3658796

Type (Data Object Type)

_type like 'AudioAssetMaster'

Inventory Key (Asset Type)

inventoryKey like 'audio'
inventoryKey = 'audio'

Inventory Type Name (Asset Type)

inventoryTypeName like 'audio'
inventoryTypeName = 'audio'

Asset Type (Asset Type)

assetType = 'Audio'

Name (Asset Name)

name like 'AudioName' ← Full Name of Asset
name like 'dioNa' ← Partial Search against Name of Asset

System Keywords (Combination of Name and Inventory Type Name)

systemKeywords = 'SORBW002661_SOLIDLIGHT_IAmBack_1568901761.wav Audio'

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'

Truncated Flag (Archived Flag)

truncatedFlag = true
truncatedFlag = false

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

status = 'AVAILABLE'
status != 'AVAILABLE'

Restore Key (Restore Key Location for the Archived Asset)

restoreKey is null
restoreKey is not null
restoreKey like '/mnt/archive/some/path/to/file.mov'

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')

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

timelineMemberships = '241'
timelineMemberships != '241'
timelineMemberships in ('241','242')
timelineMemberships not in ('241','242')

UUID (UUID Created during Ingest Process)

uuid = '7191a54e-62dc-428e-865e-ef261a5916e1'

Checksum (Calculated Checksum during Ingest Process)

checksum = 51100328

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

metadata_id = 1033069956

RQL Queries for Audio Technical Metadata

File Extension (Denotes File Extension of the Source File)

fileExtension like 'wav'
fileExtension like 'mp3'
fileExtension not like 'flac'

File Size (Denotes the File Size of the Source File in Bytes)

fileSize = 51100328
fileSize gt 51100328
fileSize lt 51100328

Sample Rate

sampleRate = 48000

Sample Depth

sampleDepth = 24

Duration (Duration in seconds.milliseconds)

duration = 247.4438

Channel Count (Denotes the Audio Channel count of the Audio Asset)

channelCount = 2
channelCount in ('2','4')

Bitrate (Denotes the Bitrate of the Source Audio File)

bitrate like '2304000.0'

Codec (Denotes the Codec of the Source Audio File)

codec like '00001000-0000-0100-8000-00AA00389B71'