Hi, I'm currently working on creating a module in EPESI. I've run into a little roadblock with permissions, unfortunately.
I'm using the RecordBrowser to store and return records. However, I only want certain people to view or act upon certain records; more specifically, a particular field in this table lists the user's internal company ID number as part of the record, and I need to match that to a custom field of the contacts app which holds that number.
So, I've discerned from the wiki that I should be using Utils_RecordBrowser::add_access($tablename, $access_type, $clearance, $criteria) to do that. But I don't know how to word the $criteria array to filter results based on [internal company ID as stored in the contacts module]=[internal company ID as stored in this table].
So, what is the syntax of the criteria array which will allow me to check a particular field of one table against a particular field in a different recordset? (This table, by the way, is being filled in with information from a different database, one used by a different app within the company, which would explain why I'm having this discrepancy with ID's in the first place.)
Thanks!