Hello everyone, I am currently facing a pressing issue related to the v8 API in SuiteCRM. Specifically, I am developing an application using SuiteCRM’s API, but I’m puzzled as to why when I use two different accounts with separate data permissions, the API returns the same results for both accounts, and there is no apparent data segregation. I have extensively tested the API, and I suspect the issue may be within SuiteCRM itself. That’s why I’m posting this to seek assistance! Please, help me .
|$where = accounts.deleted = ‘0’.$wh.$sea.$myAccount;|
|$lead = new Account();|
|$query = $lead->create_new_list_query(accounts.date_entered DESC,$where,array());|
|$query = $query. order by accounts.date_entered DESC;|
|$queryCount = select count(accounts.id) as num from accounts inner join ($query) as account on accounts.id = account.id where accounts.deleted = ‘0’;|
|$resCount = $db->query($queryCount);|
|$rowCount = $db->fetchByAssoc($resCount);|