If you are a SuiteCRM owner, you can provide users with field-level access in your CRM through SuiteCRM Field Level Access Control. Our plugin enables the admin to display only relevant field data to users who have been assigned roles.
#1771 - MS SQL Server 2012 support
I've just finished installation of the module and it was correct (100%) but when I enter to the Administration section I only see labels intead of module options and configurations. My SuiteCRM setup (version 7.10.9 ) runs on a MS SQL Server 2012 without any problems. But when I see suitecrm.log I see this error message:
Mon Feb 18 09:01:40 2019 [FATAL] Query Failed:IF NOT EXISTS (SELECT 1 FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[access_control_fields]') AND type in (N'U'))
CREATE TABLE IF NOT EXISTS access_control_fields ([id] varchar(36) NOT NULL ,[name] nvarchar(255) NULL ,
[date_entered] datetime NULL ,[date_modified] datetime NULL ,[modified_user_id] varchar(36) NULL ,
[created_by] varchar(36) NULL ,[description] nvarchar(max) NULL ,[deleted] bit DEFAULT '0' NULL ,
[category] nvarchar(100) NULL ,[aclaccess] int NULL ,[role_id] varchar(36) NULL );::: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Incorrect syntax near the keyword 'IF'.
[Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Incorrect syntax near 'access_control_fields'.
Other add-ons of interest
Analytic Reporting Tool Basic
Dynamic Reports and Interactive Charts.
Powerful tool for SuiteCRM report creation and data analytics. Includes a variety of chart types, detailed, summary and pivot tables. This Reporting Tool is for anyone, no need for technical knowledge or SQL. Comes with over a hundred prebuilt reports.