Clarification on AccessOverride Value Mapping Between API and Database

Hi team,

I'm trying to understand how the value of AccessOverride is mapped between the API response and the database. When I send a GET request for the ID 9a756736-2f04-11f0-adbd-1f5fed2e0445, I receive multiple AccessOverride values in the Postman response. However, when I query the same ID in DBeaver, I see only a single value, which is 0.

Can someone help clarify how this mapping is implemented between the API response and the database query?

Below are screenshots for your reference

0 Andre Serrazina 1 month ago
Hello dhruti vachhani ,

Thanks for bringing up this question!

If you want to verify the exact SQL query SugarCRM is executing to generate the results you see in Postman, you can use the sugarcrm.log file to trace it.

Here’s how you can do it:

Go to Admin > System Settings.

Increase the log level to debug.

Use the mark point feature to set a reference in the log.

Perform your Postman API call again.

Refresh the log viewer from the mark point onward.

This process will print the SQL query SugarCRM is running against the database, allowing you to see where the AccessOverride values are being pulled from.

For reference, AccessOverride values are typically linked to entries in the acl_roles_actions table in the database.

Hope this helps clarify things!

Cheers,

Andre