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 = 3663206
Type (Data Object Type)
_type like 'VideoAssetMaster'
Inventory Key (Asset Type)
inventoryKey like 'video'
inventoryKey = 'video'
Inventory Type Name (Asset Type)
inventoryTypeName like 'video'
inventoryTypeName = 'video'
Name (Asset Name)
name like 'VideoName' ← Full Name of Asset
name like 'deoNa' ← Partial Search against Name of Asset
System Keywords (Combination of Name and Inventory Type Name)
systemKeywords = 'MBS23224.mp4 Video '
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 = 445256
Metadata Set ID (Find the Asset Associated to a Metadata Set by ID)
metadata_id = 1033069956
Live Event (Denotes Wether or not this Video is Currently a Live Event)
liveEvent = true
liveEvent = false
RQL Queries for Video Technical Metadata
Container Type (Denotes the File Type of the Video)
containerType like 'MPEG' ← Represents MPEG-4
containerType like 'MXF'
containerType like 'BDAV'
File Size (Identifies the File Size of the Source File in Bytes)
fileSize = 1254629376
fileSize gt 1254629376
fileSize lt 1254629376
Channel Count (Denotes the Audio Channel count of the Video)
channelCount = 2
channelCount in ('2','4')
Height (Height of the Source Video)
height = 1920
height gt 1920
height lt 1920
Width (Width of the Source Video)
width = 1080
width gt 1080
width lt 1080
Aspect Ratio (Denotes the Aspect Ratio of the Source Video)
aspectRatio like '16' ← Represents 16:9
aspectRatio like '4' ← Represents 4:3
Codec (Denotes the Codec of the Source Video)
codec like 'avc1'
codec like '27'
Timecode Format (Denotes the Timecode Format of the Source Video)
timecodeFormat like 'Drop Frame'
timecodeFormat like 'Non' ← Represents 'Non-Drop Frame'
Start Timecode (Denotes the Starting Point of the Video in the Player)
startTimecode = '01:00:00:00'
End Timecode (Denotes the Ending Point of the Video in the Player)
endTimecode = '01:00:14:09'
Duration HMSF (Full Duration of the Video in Hours/Minutes/Seconds/Frames)
durationhhmmssff like '00:00:14:09'
Duration (Duration in seconds.milliseconds)
duration = 247.4438
Sample Depth
sampleDepth = 16
Sample Rate
sampleRate = 48000
Bitrate (Denotes the Bitrate of the Source Video)
bitrate like '2.1339612E7'
Frame Rate (Denotes the Frame Rate of the Source Video)
frameRate = 25.0
Comments
0 comments
Please sign in to leave a comment.