Issue
User would like to view all unarchived Results for a certain Results table and wants to use the $raw table.
Environment
Insights
Cause
The $raw tables contain both unarchived and archived items. If you want to use the $raw table and do not want to see archived items, you must filter them out in your SQL query.
Resolution steps
Add the following statement to the end of your SQL query, and replace [table] with the name of your table:
WHERE [table].archived$ = false
This works when querying anything that can be archived: results, containers, entities, etc., just change out the table name to suit your needs!