works on FM Pro 12 but not on Server - record security privilege calculated
I wanted Staff role to only able to see their own records in the Auditor Tasking layout, and in selected layouts allow them to view other Auditors. So, under Staff role in manage Security i added the below calculation to determine when to allow view of record.
$LayoutName = Get( LayoutName);
$PatternCount1 = PatternCount( $LayoutName; "Manpower");
$PatternCount2 = PatternCount( $LayoutName; "Auditor");
$PatternCount3 = PatternCount( $LayoutName; "Timesheet");
$PatternCountTotal = $PatternCount1 + $PatternCount2 + $PatternCount3;
$result = If ( ( $PatternCountTotal > 0 ) ; If ( Employee_Username = $$AccountName ; 1 ; 0 ) ; 1 )
]; $result )
Everything works fine when i test it hosted using FM Pro 12. But when i place it onto the FM Pro 12 Server, it worked on Auditor Tasking layout but not the rest of the layouts which are suppose to be able to display other auditors name apart of himself.
I am pluzzed that it worked on hosted FM Pro 12 and not on FM Pro12 Server. Can anyone enlighten me please? If i can't implement this, then other auditors will be able to view one another's confidential work.. and that is not good... ;(