Items for a role, with their evidence label

Role ids: newcomer, developer, security-architect, infrastructure-operator, product, standards-policy, communications, investor, business-development, researcher.

Custom SQL query (hide) 

select r.date, r.name, r.type, r.level, r.evidence, r.url
from resource_roles rr join resources r on r.id = rr.resource_id
where rr.role = :role order by r.date desc

Query parameters

Edit SQL

0 results