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