I have simple query in my apex class. It works 100% in all the developer orgs we tested.
List<Account> allAcc = new List<Account>([SELECT Id FROM Account WHERE Primary_Adviser__c =:FINALID]);
It works well in the Production's developer console and returns a value but it doesn't return any values on the managed package itself.
The Debug Log only shows fews lines:
33.0APEX_CODE,DEBUG;APEX_PROFILING,INFO;CALLOUT,INFO;DB,INFO;SYSTEM,DEBUG;VALIDATION,INFO;VISUALFORCE,INFO;WORKFLOW,INFO 21:58:43.606 (606337311)|ENTERING_MANAGED_PKG|ASFF 21:58:43.609 (609746129)|SOQL_EXECUTE_BEGIN||Aggregations:0|SELECT Id FROM Account WHERE Primary_Adviser__c = :tmpVar1 21:58:43.614 (614850395)|SOQL_EXECUTE_END||Rows:0
I already tried changing the code and everything with it and still no progress. Can anyone please share your ideas/experiences/solutions for this scenario? Thanks!