Imagen Query Language - Related Records View ⚡

The Related Records area on a system page presents the user with other records in your system which may be of interest

Overview

Record relation is not informed by a user’s viewing history, rather the metadata attached to media on your system. The syntax here includes a match for a categories field, this will be particularly useful when presenting other records of the same category, filtered by newest first:

WHERE Category = %Category% ORDER BY Date DESC

We could also add a security clause that will ensure only successfully imported records are displayed:

WHERE Category = %Category% AND media.State = 'Archived' 

Any field in your database can be used as a related records clause

WHERE Colour = %Colour% 


Examples:

WHERE Field_Name = %Field_Name%


This will return records where the specified field matches those of other records

WHERE Colour = %Colour% 

This will return all records where the colour field matches the colour on this record

WHERE Category = %Category% ORDER BY Date DESC

This will return all records where the Category field matches other  records, sorted by newest (date) first (DESC)

WHERE Category = %Category% AND media.State = 'Archived' 

This will return all records with a matching category in addition to adding a clause (AND media.State = 'Archived' ) which means where media has correctly ingested without issue. The inverse would be (media.State = 'Failed')