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 = 460
Type (Data Object Type)
_type like 'VideoClip'
Inventory Key (Asset Type)
inventoryKey like 'video_clip'
inventoryKey = 'video_clip'
Inventory Type Name (Asset Type)
inventoryTypeName like 'video_clip'
inventoryTypeName = 'video_clip'
Asset Clip Type String (Denotes the Type of Clip)
assetClipTypeStr = 'VIDEO_CLIP'
Name (Asset Name)
name like 'VideoClipName' ← Full Name of Asset
name like 'oClipNa' ← Partial Search against Name of Asset
System Keywords (Clip Name and Parent Video Name and Parent Inventory Type Name)
systemKeywords = 'Test Clip boston.mov Video'
Date Created (Date of Clip Creation)
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 based on the Parent Video)
truncatedFlag = true
truncatedFlag = false
Source File Path (Location of the Source File on the File System)
sourceFilePath like '/mezzanines/2019/09/20/01/' ← Note that this will be for the parent video asset of the clip
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 = 'f89edbd1-39ee-499d-a2e8-f0921d6a1e27'
Checksum (Calculated Checksum of the Parent Video)
checksum = 445256
Metadata Set ID (Find the Asset Associated to a Metadata Set by ID)
metadata_id = 1033069959
Is Being Deleted
isBeingDeleted = false
isBeingDeleted = true
Video ID (Denotes the Asset ID of the Parent Video to the Clip)
videoId = 3663206
RQL Queries for Video Clip Technical Metadata
Start Timecode (Denotes the Starting Point of the Video Clip in the Player)
startTimecode = '01:00:02:05'
End Timecode (Denotes the Ending Point of the Video Clip in the Player)
endTimecode = '01:00:04:11'
Duration (Duration in seconds.milliseconds)
duration = 2.4333333333333336
Duration HMSF (Full Duration of the Video Clip in Hours/Minutes/Seconds/Frames)
durationhhmmssff like '00:00:02:07'
Timecode Duration (Duration of Video Clip in Timecode Format)
timecodeDuration = '00:00:02:07'
Asset Clip Start Offset (Denotes the Starting Point of the Clip within the Parent Video)
assetClipStartOffset = '2.3333333333333335'
Thumbnail Offset (Denotes the Time in Seconds for the Thumbnail of the Video Clip)
thumbnailOffset = '2.0'
Container Type (Denotes the File Type of the Parent Video)
containerType like 'MPEG' ← Represents MPEG-4
containerType like 'MXF'
containerType like 'BDAV'
Channel Count (Denotes the Audio Channel count of the Parent Video)
channelCount = 2
channelCount in ('2','4')
Height (Height of the Parent Video)
height = 1920
height gt 1920
height lt 1920
Width (Width of the Parent Video)
width = 1080
width gt 1080
width lt 1080
Aspect Ratio (Denotes the Aspect Ratio of the Parent Video)
aspectRatio like '16' ← Represents 16:9
aspectRatio like '4' ← Represents 4:3
Codec (Denotes the Codec of the Parent Video)
codec like 'avc1'
Timecode Format (Denotes the Timecode Format of the Parent Video)
timecodeFormat like 'Drop Frame'
timecodeFormat like 'Non' ← Represents 'Non-Drop Frame'
Bitrate (Denotes the Bitrate of the Video Clip)
bitrate like '224761.0'
Frame Rate (Denotes the Frame Rate of the Video Clip)
frameRate = 15.0
Comments
0 comments
Please sign in to leave a comment.