I want to create a report to put up on the Requests tab that shows all of the issues that have been submitted by the person who is logged in's company. When the person logs in, regardless if they've submitted any issues, they would be able to see all of the issues that people in their company have submitted.
I thought it would have been as simple as creating the filter for the Primary Contact's companyID to equal the USER.companyID but that didn't work for people who hadn't put any issues in. The report was coming up blank.
Typically the filter would just be companyID = $$ USER.companyID but that doesn't work because its not a direct relation in the database.
Any ideas? Something I missed?