0 Replies Latest reply on Jun 14, 2016 12:19 AM by kaman

    Difference records displayed in FM Pro 15 & webdirect

    kaman

      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.