This stored procedure returns a single module type definition from the database. The input parameter is ModuleDefID, the primary key for the record. The return values include the type's friendly name as well as paths for the desktop and mobile versions of the module.
This stored procedure is used by the edit page for module type definitions.
Definition:CREATE PROCEDURE GetSingleModuleDefinition ( @ModuleDefID int ) AS SELECT FriendlyName, DesktopSrc, MobileSrc FROM ModuleDefinitions WHERE ModuleDefID = @ModuleDefIDDatabase Tables Used:
ModuleDefinitions: Each record in the ModuleDefinitions table defines a different type of modules that may be used in the selected portal. Individual modules reference this definition via the ModuleDefID, the primary key for this table. All modules must define a Desktop module version; optionally they may also define a Mobile version.