Ooyala Flex Query Language

The Ooyala Flex Query Language enables you to carry out complex structured searches in Ooyala Flex. In the context of the Publish module, you can use the Query Language to search for image assets, media assets, and group assets.

Syntax

In Ooyala Flex, you can carry out simple text based searches by simply entering a word or phrase. You can also use the Query Language to help you carry out more complex searches. The syntax that can be used is as follows:

Table 1. FQL Syntax
  Operators Description
Logical Operators AND OR ! Logical operators are used to search for multiple terms simultaneously. Examples:
  • You can search for two different terms using the OR operator such as: movie OR  film.
  • You can search for multiple terms using the AND operator such as: movie AND film.
Quotes "" Quotes are used to search for an exact word or phrase. You wrap the word or phrase in quotation marks. Example: description="city".
Comparison Operators >= <= < > Equal or greater, equal or lesser, lesser and greater operators are supported.
Boosting ^ You can boost a term using a caret (cursor) symbol. Example: description^5=city. In this example all the assets which have the word city in the description field will be more relevant in the search.
Brackets () Example: description=(European City) This searches the for the specific terms "European" and "City" within any description fields.
Free text search   This is when you enter a word or phrase without applying any of the above syntax. Example: you could simply search work for the word city.
Table 2. Examples
ID Brand Title Description Version Price
10 Apple Iphone 6S Iphone 6s commercial 64 700
15 Samsung Samsung S7 S7 advertisement 64 600
20 Motorola Moto G4 Motorola G4 advertisement 16 300
25 LG LG G6 LG G6 commercial 32 500
30 30 Motorola Moto G3 8 150

Searching for assets by brand

brand = Apple
Table 3.
ID Brand Title Description Version Price
10 Apple Iphone 6S Iphone 6s commercial 64 700

Search assets with commercial on description

description = commercial
Table 4.
ID Brand Title Description Version Price
10 Apple Iphone 6S Iphone 6s commercial 64 700
25 LG LG G6 LG G6 commercial 32 500

Searching assets with the version equal or greater than 32, and with a price below 700

version >= 32 AND price < 700
Table 5.
ID Brand Title Description Version Price
15 Samsung Samsung S7 S7 advertisement 64 600
25 LG LG G6 LG G6 commercial 32 500

Searching by brand (Motorola) but also boosting a description containing G3

brand = Motorola OR description^5 = G3

In this particular example, you would expect to get all assets which fall under the Motorola brand. However, the asset ID (30) is going to appear first in the search results, because the description which contains G3 has been boosted.

Table 6.
ID Brand Title Description Version Price
30 Motorola Moto G3 G3 advertisement 8 150
20 Motorola Moto G4 Motorola G4 advertisement 16 300

Searching using an exact match

description = "Iphone 6s commercial"

This example shows the assets with the exact match on the description.

Table 7.
ID Brand Title Description Version Price
10 Apple Iphone 6S Iphone 6s commercial 64 700

Was this article helpful?