Hi everyone,
I have been trying to view the Opportunities Grid under my Account Entity, on Infor Web CRM, though I am having issues when I'm not logged in as Administrator.
I ran the SLXProfiler against the app and this is the query when I am logged in as Admin,
---------- Client SQL ---------
SELECT count(*) as y0_ FROM OPPORTUNITY this_ left outer join ACCOUNT a1_ on this_.ACCOUNTID=a1_.ACCOUNTID WHERE a1_.ACCOUNTID = [DBTYPE_WSTR,"A6UJ9A000001"]
---------- Executed SQL ----------
SELECT count(*) as y0_ FROM OPPORTUNITY this_ left outer join ACCOUNT a1_ on this_.ACCOUNTID=a1_.ACCOUNTID WHERE a1_.ACCOUNTID = ?
This is the query when I am logged in as a user that is NOT Admin,
---------- Client SQL ---------
SELECT count(*) as y0_ FROM OPPORTUNITY this_ left outer join ACCOUNT a1_ on this_.ACCOUNTID=a1_.ACCOUNTID WHERE a1_.ACCOUNTID = [DBTYPE_WSTR,"A6UJ9A000001"]
---------- Executed SQL ----------
SELECT count(*) as y0_ FROM OPPORTUNITY this_ --INNER JOIN SECRIGHTS S_AA ON (S_AA.ACCESSID = 'U6UJ9A000009' AND THIS_.SECCODEID = S_AA.SECCODEID )
left outer join ACCOUNT_ a1_ on this_.ACCOUNTID=a1_.ACCOUNTID AND a1_.ACCESSID_='U6UJ9A000009' WHERE a1_.ACCOUNTID = ?
The issue I'm facing is that Infor appears to be querying data from the table ACCOUNT_ when not Admin, however I am unable to get any records if I query this database.
I'm not sure if there is something I'm missing to have these tables populated to resolve my issue.
I'm facing the same issues with Contacts as well.
I know it is not a SQL connection issue as I am able to see all this data. The user query is based on their security access on entities and seccodeids.
I am using Infor Web CRM 8.4
Can anyone please assist?
Thank you!
