AnsweredAssumed Answered

Difference records displayed in FM Pro 15 & webdirect

Question asked by kaman on Jun 14, 2016

Hi everyone,

 

The problem I met is the record set is difference between the FM Pro 15 and at webdirect for the particular privilege set.

 

Here is the scenario :

Table :      Contract, Salesperson, User

Relationship

            User  <--[pk]----user_id----[fk]--> Salesperson

            Contract <-[fk]----sales_id----[pk]--> Salesperson

Privilege set :

            [Manager] - For record, table "Contract" (view) is limited to Salesperson::dept = $$DEPT

                                For layout, view access is allowed

           [Salesperson] - For record, table "Contract" (view) is limited to Salesperson::user_id = $$USER_ID

                                    For layout, view access is allowed

Flow:

  1) Once login-ed in, the script is triggered to load certain users' info. to global variables(e.g $$DEPT, $$USER_ID) by using the Get(Accountname) and table User

  2) After entering the layout which load the contract data, records showed should be limited according to privilege set

 

Problem is I could have the expected result at FM Pro 15 but not at webdirect with the same source.

E.g

With [manager] privilege set,

(FM15)  I could load the contract record within the whole department which assigned at table.

(WD) No matched record

With [salesperson] privilege set,

(FM15) & (WD) I could load the salesperson corresponding contract.

 

* I could only find out that no Salesperson info. could be read / related to the contract layout, when the privilege set is [manager]

Any ideas? I would appreciated it if anyone could help.

Outcomes