Jump to content

Difference records displayed in FM Pro Advanced 15 & webdirect


This topic is 2866 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

Hi everyone,

The problem I met is about record set is difference between the FM Pro 15 and it behaves at webdirect.

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 found out that no Salesperson info. could be read / related to the contract layout, when the privilege set is [manager].
I would appreciated it if anyone could help.

Link to comment
Share on other sites

This topic is 2866 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.