Issue:
Notes that are imported on jobs from WeSuite have a default access level. If this needs to be changed, the setup table will need to be updated.
select * from SY_WeSuite_Setup
Resolution:
The settings need to be changed in the SY_WeSuite_Setup table in the SedonaOffice company.
The scripts below can be used to change this value in the Company.
--- Backup table ---
select * into SY_WeSuite_Setup_Backup from SY_WeSuite_Setup
--- Check the current value. ---
select * from SY_WeSuite_Setup
--- Update the value. can be 1, 2, or 3.---
Update SY_WeSuite_Setup
Set Default_Note_Access_Level = 2
Where Setup_Id =1