Admin viewer to access all users
How do I get at all records from accounts for admin only reporting reporting? Does the Website Membership limit to only the owner's records?
Id like to Left Join two tables and do something like this on a webpage that loops through and formats the results if user is admin:
FROM cmsb_accounts LEFT JOIN cmsb_dataform ON cmsb_accounts.createdByUserNum = cmsb_dataform.createdByUserNum
WHERE NOT cmsb_accounts.isAdmin OR cmsb_dataform.Biennium ="2019-2021"
ORDER BY cmsb_dataform.RecordStatus DESC,