Custom Form Permissions

[SBarnes]

If you have added a custom maintenance form to Jiwa what tables would you need to add data to make it possible for it to appear in the permissions tab in user group maintenance?

[Mike.Sheen]

If you have added a custom maintenance form to Jiwa what tables would you need to add data to make it possible for it to appear in the permissions tab in user group maintenance?

That would be the SY_FormsAbstractPermissions - two entries are required, one for 'Load' and one for 'Edit'.

The POS plugin that is in demo data has a SQL Script attached for deployment which you can use as a template:

Code: Select all

IF NOT EXISTS(SELECT TOP 1 * FROM SY_Forms WHERE ClassName = 'JiwaFinancials.Jiwa.JiwaPOSUI.POSForm')
   INSERT INTO SY_Forms(ClassName, Description, FormType, HelpFileName, HelpPageName, AssemblyFullName)
   SELECT 'JiwaFinancials.Jiwa.JiwaPOSUI.POSForm', 'POS', 2, '', 'https://wiki.jiwa.com.au/index.php/POS_Plugin',
   (SELECT TOP 1 RecID FROM SY_Plugin WHERE Name = 'POS')
GO

IF NOT EXISTS(SELECT TOP 1 * FROM SY_FormsAbstractPermissions WHERE SY_Forms_ClassName = 'JiwaFinancials.Jiwa.JiwaPOSUI.POSForm' AND Name = 'Load')
   INSERT INTO SY_FormsAbstractPermissions(RecID, SY_Forms_ClassName, Name, Description, ItemNo)
   SELECT NEWID(), 'JiwaFinancials.Jiwa.JiwaPOSUI.POSForm', 'Load', 'Load of the form', (SELECT COALESCE(MAX(ItemNo), 0) + 1 FROM SY_FormsAbstractPermissions WHERE SY_Forms_ClassName = 'JiwaFinancials.Jiwa.JiwaPOSUI.POSForm')
GO

IF NOT EXISTS(SELECT TOP 1 * FROM SY_FormsAbstractPermissions WHERE SY_Forms_ClassName = 'JiwaFinancials.Jiwa.JiwaPOSUI.POSForm' AND Name = 'Edit')
   INSERT INTO SY_FormsAbstractPermissions(RecID, SY_Forms_ClassName, Name, Description, ItemNo)
   SELECT NEWID(), 'JiwaFinancials.Jiwa.JiwaPOSUI.POSForm', 'Edit', 'Edit of the form', (SELECT COALESCE(MAX(ItemNo), 0) + 1 FROM SY_FormsAbstractPermissions WHERE SY_Forms_ClassName = 'JiwaFinancials.Jiwa.JiwaPOSUI.POSForm')
GO

[SBarnes]

Thanks Mike.