The University of the West Indies (UWI), at Cave Hill, Barbados

The University of the West Indies

at Cave Hill, Barbados

Faculty of Medical Sciences


 
 
          OVERVIEW          

             

The Faculty of Medical Sciences participates in clinical, non-clinical and translational research to inform medical practice and healthcare systems locally, regionally and internationally.  Research in both clinical and non-clinical aspects of the medical disciplines are structured into faculty, undergraduate and postgraduate research activities.  Faculty members’ research are pursued based on areas of expertise and specific interests aligned with the resources and research themes in the faculty.

Undergraduate research is supported and facilitated by the academic department as a part of the undergraduate curricula in the medical and health science programmes. Postgraduate research is undertaken in research based and taught based graduate programmes. Research based programmes (e.g. Doctorate of Philosophy and Masters programmes) exist in disciplines of Medical Microbiology, Immunology, Pharmacology, Public Health and Epidemiology. Clinical based postgraduate research often involves research projects which are part fulfilment of the Doctor of Medicine programmes.

Non-clinical research may involve the ethno-pharmacological evaluation of medicinal plants and their interaction with conventional drugs, factors adjudicating wound healing, exercise physiology and histological research. Clinical research includes case studies, observational and experimental trials in the clinical setting.  Clinical research is bolstered by access to public clinical facilities in Barbados and a memorandum of understanding between the Ministry of Health, Barbados and The University of the West Indies which facilitates the sharing of resources for the betterment of healthcare provision in Barbados. The Faculty of Medical Sciences also shares a formal relationship with the George Alleyne – Chronic Disease Research Centre (GA-CDRC) which ensures collaboration on research and teaching to build capacity in research and healthcare provision and policy. 

Click here» GA CDRC website.

The FMS has bolstered its resources over the existence of the full faculty (since 2008) to facilitate research at its various geographical sites.  There is a research laboratory at the Cave Hill site, which is approximately 2000 sq ft of generalised and specialised laboratory space.  The laboratory is outfitted with vital core equipment that can lead to bench research in various basic medical science disciplines. Resources in the clinical research arena are bolstered by the FMS access to polyclinics and the island’s main public hospital, Queen Elizabeth Hospital.  There is an institutionalised ethics board which is operated by The University of the West Indies and the Ministry of Health.  It reviews all projects which involves the use of human and animal participants/subjects and data collected from such across the island. The faculty has a research and postgraduate committee which is chaired by the Deputy Dean – Graduate Studies and Research.  This committee assesses research training needs and infrastructure to facilitate faculty, undergraduate and postgraduate research.

The research findings from FMS projects have been presented at regional and international conferences, to expand the knowledge base of Caribbean-based research; to inform local and regional health policies, and has led to many international research collaborations.


 
 
 OVERVIEW OF RESEARCH OPPORTUNITIES 



The research themes in the FMS are aligned with the category and specific research interests of staff.  There are opportunities to facilitate structured undergraduate research projects which are aligned with level 2 and 3 health science related courses and levels 3 and 4 clinical research courses for medical sciences.  These courses are MDSC2008 – Health Science Research, MDSC3900 - Practical Research for Health and Medical Students and MDSC3200 - Understanding Research which span both programmes. Most of the practical elements of the undergraduate research opportunities are aligned with research expertise and themes within the FMS.  Postgraduate students (both research based and taught masters) are encouraged to pursue research within the confined time of the programme and within the research foci of the faculty.

Non-clinical research areas are primarily in the basic medical sciences.  These include but are not limited to:
  •  Validation of medicinal herbs
  •  Wound healing
  • Exercise Physiology
  • Microbial resistance and typing
  • Acute and chronic inflammation 
 
The clinical and translational research areas are undertaken by staff in the clinical phase and public health unit.  Our broad research areas based on faculty expertise include:
  • Chronic non-communicable diseases
  • Policy evaluation
  • Wound healing and diabetes
  • Healthcare systems and economics of health
  • Clinical audits of disease management
  • Social determinants of health
  • Antenatal health
 
 
     RESEARCH IN PROGRESS     

                     
         » CLICK HERE TO VIEW

 
Contact the Faculty of Medical Sciences
Telephone: (246) 417- 4694/4703/4264 Fax: (246) 438-9170 Email: fms@cavehill.uwi.edu

Event handlers called by this request / thread:
 NameContext
1 RequestEvents.Begin.Execute ApplicationModule.BeginRequest
> HelpersHandlers.BeginRequest
> LicenseHandlers.CheckApplicationValidityAndLicense
> URLRewritingHandlers.BeginRequest
> WebDAVHandlers.PropFindEndRequest
> WIFIntegrationHandlers.ProcessRequest
2 RequestEvents.Authenticate.Execute ApplicationModule.AuthenticateRequest
> MembershipHandlers.HandleAutomaticSignIn
3 RequestEvents.Authorize.Execute ApplicationModule.AuthorizeRequest
> URLRewritingHandlers.AuthorizeRequest
4 RequestEvents.PostAuthorize.Execute ApplicationModule.PostAuthorizeRequest
> HelpersHandlers.HandleClickjacking
5 RequestEvents.PostResolveRequestCache.Execute ApplicationModule.PostResolveRequestCache
> URLRewritingHandlers.RewriteUrl
6 >> DocumentEvents.GetData ApplicationModule.PostResolveRequestCache
7 >>> TypeInfo(cms.document).Events.GetData ApplicationModule.PostResolveRequestCache
8 >> URLRewritingEvents.ProcessABTest.Execute ApplicationModule.PostResolveRequestCache
>>> ABHandlers.ProcessABTest
9 >> URLRewritingEvents.ProcessRewritingResult ApplicationModule.PostResolveRequestCache
10 RequestEvents.PostMapRequestHandler.Execute ApplicationModule.PostMapRequestHandler
> CsrfProtection.OnPostMapRequestHandlerExecute
> WebAnalyticsHandlers.LogCampaign
> URLRewritingHandlers.PostMapRequestHandler
> ABHandlers.ExcludeVisitorFromAB
11 ApplicationEvents.SessionStart.Execute CMSHttpApplication.Session_Start
> MembershipHandlers.SessionStart
12 >> SessionEvents.UpdateSession CMSHttpApplication.Session_Start
>>> SessionEvents.UpdateSession.Before
>>>> PortalHandlers.UpdateSession_Before
13 RequestEvents.AcquireRequestState.Execute ApplicationModule.AcquireRequestState
> HelpersHandlers.InitSessionTimeout
> URLRewritingHandlers.CheckSecurity
> StrandsRecommenderHandlers.BindStrandsToPagePreRender
14 RequestEvents.PostAcquireRequestState.Execute ApplicationModule.PostAcquireRequestState
> MembershipHandlers.UpdateSession
15 >> SessionEvents.UpdateSession ApplicationModule.PostAcquireRequestState
>>> SessionEvents.UpdateSession.Before
>>>> PortalHandlers.UpdateSession_Before
> OutputFilterHandlers.EndRequestByOutputFilter
> WebAnalyticsHandlers.b__0
> WebAnalyticsHandlers.LogPageViewConversion
> WebAnalyticsHandlers.LogUTMParametersAndCampaignConversions
16 >> DocumentEvents.GetData ApplicationModule.PostAcquireRequestState
17 >>> TypeInfo(cms.document).Events.GetData ApplicationModule.PostAcquireRequestState
18 >>>> TypeInfo(cms.versionhistory).Events.GetData ApplicationModule.PostAcquireRequestState
19 >> TypeInfo(om.abvariant).Events.GetData ApplicationModule.PostAcquireRequestState
20 >>> TypeInfo(om.abvariant).Events.GetData ApplicationModule.PostAcquireRequestState
> WebAnalyticsServiceScriptsRenderer.b__0
> ABHandlers.LogABVisit
21 PortalEngineEvents.MVTVariantsEnabled.Execute PageContext.CurrentPage_InitComplete
> MVTHandlers.MVTVariantsEnabled
22 PageInfoEvents.CombinePageTemplateInstance PageContext.CurrentPage_InitComplete
> PageInfoEvents.CombinePageTemplateInstance.After
>> OnlineMarketingHandlers.CombinePageTemplateInstance_After
23 PageInfoEvents.CombinePageTemplateInstance PageContext.CurrentPage_InitComplete
> PageInfoEvents.CombinePageTemplateInstance.After
>> OnlineMarketingHandlers.CombinePageTemplateInstance_After
24 DocumentEvents.GetData PageContext.CurrentPage_InitComplete
25 TypeInfo(cms.document.slider.cameraitem).Events.GetData PageContext.CurrentPage_InitComplete
26 DocumentEvents.GetData CMSAbstractMenuProperties.OnLoad
27 TypeInfo(cms.document).Events.GetData CMSAbstractMenuProperties.OnLoad
28 TypeInfo(cms.acl).Events.GetData CMSAbstractMenuProperties.OnLoad
   
File operations performed by this request / thread:
 Action (file access, file mode)
Size (number of accesses)
Size chart
File pathProviderContext
1 EXISTS
~/App_Data/Persistent/Cache/FMS/outputdata/006F/776092151.cache Local ApplicationModule.AuthorizeRequest
2 DIREXISTS
~/App_Themes/FMS_CSS Local ContentPage.OnPreInit
3 EXISTS
~/CMSControls/960_cave_footer.ascx Local DbPathProvider.GetFileHash
4 EXISTS
~/CMSControls/cave_footer.ascx.cs Local
5 EXISTS
~/CMSControls/fms/960_cave_header.ascx Local
6 EXISTS
~/CMSControls/fms/960_cave_header.ascx.cs Local
7 EXISTS
~/CMSWebParts/navigation/cmsbreadcrumbs.ascx Local
8 EXISTS
~/CMSWebParts/Navigation/cmsbreadcrumbs.ascx.cs Local
9 EXISTS
~/App_Themes/Design/Debug.css Local CMSAdminControls_Debug_HandlersLog.OnPreRender
10 EXISTS
~/App_Themes/Design/Debug.css Local CMSAdminControls_Debug_HandlersLog.OnPreRender
11 EXISTS
~/App_Themes/Design/Debug.css Local CMSAdminControls_Debug_FilesLog.OnPreRender
12 EXISTS
~/App_Themes/Design/Debug.css Local CMSAdminControls_Debug_FilesLog.OnPreRender
     
Security checks called by this request / thread:
 UserOperationResultResource / Class / IDPermission / UI element / ValueSite / DomainContext
1 public FilterDataSetByPermissions DataSet: DataSet: Table (1 [37], 198 B) read FMS CMSAbstractMenuProperties.OnLoad
IsGlobalAdministrator False CMSAbstractMenuProperties.OnLoad
IsGlobalAdministrator False CMSAbstractMenuProperties.OnLoad
IsGlobalAdministrator False
CheckPrivilegeLevel False GlobalAdmin CMSAbstractMenuProperties.OnLoad
        
Cache items accessed by this request / thread:
 AccessCache key
Dependencies
Data
Context
1 ADD pageinfo|fms|/research|en-gb|/research|true
template|235
nodeid|5543
pageinfo
ApplicationModule.PostResolveRequestCache
2 ADD pageinfobyurl|fms|https://www.cavehill.uwi.edu/fms/research.aspx|en-gb||true|true
template|235
nodeid|5543
pageinfo
ApplicationModule.PostResolveRequestCache
3 GET cms.searchengine|cachedids|crawlers ApplicationModule.PostAcquireRequestState
4 GET pageinfo|fms|/|en-gb||false PageContext.CurrentPage_InitComplete
5 GET siteresourcerolespermissions|51|cms.content CMSAbstractMenuProperties.OnLoad
6 ADD breadcrumbs|fms|/5515|en-gb|false|cms.menuitem;cms.office||true|
node|fms|/5515|childnodes
CMSAbstractMenuProperties.OnLoad
7 GET cmsmenudatasource||en-gb|fms|/%|en-gb|false|cms.menuitem|||2|true||false|false CMSListMenu.OnLoad
8 GET scriptfile|dialogs/modaldialog.js CMSAdminControls_Debug_CacheLog.OnPreRender
    
Request trace:
 MethodAdditional infoFrom firstDuration
1 RewriteURL /research.aspx 0.000
0.141
 
2 PathRewritten ~/CMSPages/PortalTemplate.aspx 0.141
0.250
 
3 > OnPreInit 0.391
0.000
 
4 > OnInit 0.391
0.078
 
5 > OnLoad 0.469
0.141
 
6 > OnPreRender 0.609
N/A
    0.609  
Request cookies:
 NameValue
1 CMSPreferredCultureen-GB
2 CMSCsrfCookieqSRKVBJKiVdCAEBsu2swG7fCkxiDkNv23aheKpkp
3 ASP.NET_SessionIdllqyut0wnbtujk5l53hadxog
4 Campaign 
5 Source 
6 CMSCurrentThemeFMS_CSS
Response cookies:
 NameValueExpires
1 CMSPreferredCultureen-GB24/04/2020 10:30:48
2 CMSCsrfCookieqSRKVBJKiVdCAEBsu2swG7fCkxiDkNv23aheKpkp 
3 ASP.NET_SessionIdllqyut0wnbtujk5l53hadxog 
4 Campaign 24/04/2018 10:30:48
5 Source 24/04/2018 10:30:48
6 CMSCurrentThemeFMS_CSS25/04/2019 10:30:48
Request information:
 NameValue
1 HttpMethodGET
2 UrlReferrer 
3 UserAgentCCBot/2.0 (https://commoncrawl.org/faq/)
4 UserHostAddress54.90.86.231
5 UserLanguagesen-US;en;q=0.5
6 UserName 
7 SessionIDllqyut0wnbtujk5l53hadxog
8 ServerNameARES1_fms
SQL queries called by this request / thread:
 (Query name)
Query text
Parameters: @name (value)
Results: tablename (rows [columns], size)
ContextDuration
new SqlConnection()
ApplicationModule.PostResolveRequestCache N/A
OpenConnection()
ApplicationModule.PostResolveRequestCache N/A
1
(.generalselect)
DECLARE @NodeSiteID int = 51;
DECLARE @DocumentUrlPath nvarchar(max) = N'/research';
DECLARE @NodeAliasPath nvarchar(max) = N'/research';
DECLARE @DocumentCulture nvarchar(max) = N'en-GB';
DECLARE @Now datetime2 = '4/24/2019 10:30:48 AM';

SELECT TOP 1 [ClassName], [NodeID], [NodeAliasPath], [NodeName], [NodeAlias], [NodeClassID], [NodeParentID], [NodeLevel], [NodeACLID], [NodeSiteID], [NodeGUID], [NodeOrder], [NodeLinkedNodeSiteID], [IsSecuredNode], [NodeCacheMinutes], [NodeSKUID], [NodeDocType], [NodeHeadTags], [NodeInheritPageLevels], [NodeHasChildren], [NodeBodyElementAttributes], [RequiresSSL], [NodeLinkedNodeID], [NodeOwner], [NodeTemplateForAllCultures], [NodeInheritPageTemplate], [NodeAllowCacheInFileSystem], [NodeTemplateID], [NodeGroupID], [DocumentMenuClass], [DocumentMenuItemInactive], [DocumentMenuStyle], [DocumentMenuItemHideInNavigation], [DocumentContent], [DocumentStylesheetID], [DocumentInheritsStylesheet], [DocumentID], [DocumentName], [DocumentNamePath], [DocumentPublishFrom], [DocumentPublishTo], [DocumentUrlPath], [DocumentCulture], [DocumentPageTitle], [DocumentPageKeyWords], [DocumentPageDescription], [DocumentMenuCaption], [DocumentPageTemplateID], [DocumentMenuRedirectUrl], [DocumentMenuJavascript], [DocumentCheckedOutVersionHistoryID], [DocumentPublishedVersionHistoryID], [DocumentWorkflowStepID], [DocumentExtensions], [DocumentWebParts], [DocumentGroupWebParts], [DocumentTrackConversionName], [DocumentConversionValue], [DocumentWorkflowCycleGUID], [DocumentGUID], [DocumentSearchExcluded], [DocumentLogVisitActivity], [DocumentMenuRedirectToFirstChild], CASE WHEN [DocumentCulture] = N'en-GB' THEN 2 ELSE 0 END + CASE WHEN [DocumentUrlPath] = N'/research' THEN 4 ELSE 0 END + CASE WHEN [NodeLinkedNodeID] IS NULL THEN 8 ELSE 0 END AS [CMS_P]
FROM (
SELECT [ClassName], [NodeID], [NodeAliasPath], [NodeName], [NodeAlias], [NodeClassID], [NodeParentID], [NodeLevel], [NodeACLID], [NodeSiteID], [NodeGUID], [NodeOrder], [NodeLinkedNodeSiteID], [IsSecuredNode], [NodeCacheMinutes], [NodeSKUID], [NodeDocType], [NodeHeadTags], [NodeInheritPageLevels], [NodeHasChildren], [NodeBodyElementAttributes], [RequiresSSL], [NodeLinkedNodeID], [NodeOwner], [NodeTemplateForAllCultures], [NodeInheritPageTemplate], [NodeAllowCacheInFileSystem], [NodeTemplateID], [NodeGroupID], [DocumentMenuClass], [DocumentMenuItemInactive], [DocumentMenuStyle], [DocumentMenuItemHideInNavigation], [DocumentContent], [DocumentStylesheetID], [DocumentInheritsStylesheet], [DocumentID], [DocumentName], [DocumentNamePath], [DocumentPublishFrom], [DocumentPublishTo], [DocumentUrlPath], [DocumentCulture], [DocumentPageTitle], [DocumentPageKeyWords], [DocumentPageDescription], [DocumentMenuCaption], [DocumentPageTemplateID], [DocumentMenuRedirectUrl], [DocumentMenuJavascript], [DocumentCheckedOutVersionHistoryID], [DocumentPublishedVersionHistoryID], [DocumentWorkflowStepID], [DocumentExtensions], [DocumentWebParts], [DocumentGroupWebParts], [DocumentTrackConversionName], [DocumentConversionValue], [DocumentWorkflowCycleGUID], [DocumentGUID], [DocumentSearchExcluded], [DocumentLogVisitActivity], [DocumentMenuRedirectToFirstChild]
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON V.NodeSKUID = S.SKUID
WHERE ([NodeSiteID] = @NodeSiteID AND (([DocumentUrlPath] = @DocumentUrlPath AND ([DocumentUrlPath] <> [NodeAliasPath])) OR ([NodeAliasPath] = @NodeAliasPath AND [DocumentCulture] = @DocumentCulture))) AND ([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now))
) AS SubData
ORDER BY CMS_P DESC
3.6 kB
 
Table (1 [64], 10.2 kB)
 
ApplicationModule.PostResolveRequestCache 0.109
 
CloseConnection()
ApplicationModule.PostResolveRequestCache N/A
OpenConnection()
ApplicationModule.PostResolveRequestCache N/A
2
(cms.document.generalselect)
DECLARE @NodeSiteID int = 51;
DECLARE @DocumentCulture nvarchar(max) = N'en-GB';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON V.NodeSKUID = S.SKUID
WHERE [NodeSiteID] = @NodeSiteID AND (NodeAliasPath = N'/') AND [DocumentCulture] = @DocumentCulture
ORDER BY NodeLevel DESC
Table (1 [157], 721 B)
 
ApplicationModule.PostResolveRequestCache 0.031
 
CloseConnection()
ApplicationModule.PostResolveRequestCache N/A
OpenConnection()
ApplicationModule.PostAcquireRequestState N/A
3
(cms.document.generalselect)
DECLARE @NodeSiteID int = 51;
DECLARE @NodeGUID uniqueidentifier = '8b8579c1-8644-41cb-ae4c-9b9d28d9aea0';
DECLARE @Now datetime2 = '4/24/2019 10:30:48 AM';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON V.NodeSKUID = S.SKUID
WHERE [NodeSiteID] = @NodeSiteID AND [NodeGUID] = @NodeGUID AND ([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now))
524 B
 
Table (1 [157], 10.6 kB)
 
ApplicationModule.PostAcquireRequestState 0.031
 
CloseConnection()
ApplicationModule.PostAcquireRequestState N/A
OpenConnection()
ApplicationModule.PostAcquireRequestState N/A
4
(cms.versionhistory.generalselect)
SELECT *
FROM CMS_VersionHistory
WHERE [VersionHistoryID] = 31856
Table (1 [23], 14.2 kB)
 
ApplicationModule.PostAcquireRequestState 0.156
 
CloseConnection()
ApplicationModule.PostAcquireRequestState N/A
OpenConnection()
ApplicationModule.PostAcquireRequestState N/A
5
(om.abvariant.generalselect)
DECLARE @ABVariantPath nvarchar(max) = N'/5515';
DECLARE @ABVariantSiteID int = 51;

SELECT *
FROM OM_ABVariant
WHERE [ABVariantPath] = @ABVariantPath AND [ABVariantSiteID] = @ABVariantSiteID
ApplicationModule.PostAcquireRequestState 0.016
 
CloseConnection()
ApplicationModule.PostAcquireRequestState N/A
OpenConnection()
PageContext.CurrentPage_InitComplete N/A
6
(cms.personalization.selectall)
SELECT TOP 1 *
FROM CMS_Personalization
WHERE PersonalizationUserID = 65 AND PersonalizationDocumentID = 5515
PageContext.CurrentPage_InitComplete 0.031
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
PageContext.CurrentPage_InitComplete N/A
7
(slider.cameraitem.generalselect)
DECLARE @NodeSiteID int = 51;
DECLARE @Now datetime2 = '4/24/2019 10:30:49 AM';
DECLARE @NodeAliasPath nvarchar(max) = N'/images/Rotator%';
DECLARE @DocumentCulture nvarchar(max) = N'en-GB';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN slider_cameraitem AS C WITH (NOLOCK) ON V.DocumentForeignKeyValue = C.CameraitemID AND V.ClassName = N'slider.cameraitem' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON V.NodeSKUID = S.SKUID
WHERE [NodeSiteID] = @NodeSiteID AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [NodeAliasPath] LIKE @NodeAliasPath AND [DocumentCulture] = @DocumentCulture)
ORDER BY NodeOrder
768 B
 
Table (3 [166], 2.5 kB)
 
PageContext.CurrentPage_InitComplete 0.031
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
CMSAbstractMenuProperties.OnLoad N/A
8
(cms.document.generalselect)
DECLARE @NodeSiteID int = 51;
DECLARE @Now datetime2 = '4/24/2019 10:30:49 AM';
DECLARE @NodeLevel int = 1;
DECLARE @DocumentCulture nvarchar(max) = N'en-GB';

SELECT [ClassName], [DocumentCulture], [DocumentGUID], [DocumentModifiedWhen], [DocumentMenuCaption], [DocumentMenuClass], [DocumentMenuClassHighLighted], [DocumentShowInSiteMap], [DocumentMenuItemHideInNavigation], [DocumentMenuItemImage], [DocumentMenuItemImageHighlighted], [DocumentMenuItemInactive], [DocumentMenuItemLeftImage], [DocumentMenuItemLeftImageHighlighted], [DocumentMenuItemRightImage], [DocumentMenuItemRightImageHighlighted], [DocumentMenuJavascript], [DocumentMenuRedirectUrl], [DocumentMenuRedirectToFirstChild], [DocumentMenuStyle], [DocumentMenuStyleHighlighted], [DocumentName], [DocumentUrlPath], [NodeAliasPath], [NodeID], [NodeHasChildren], [NodeClassID], [NodeLevel], [NodeLinkedNodeID], [NodeParentID], [NodeSiteID], [NodeACLID], [NodeOwner], [NodeOrder], [NodeName], [DocumentSitemapSettings], [DocumentID]
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON V.NodeSKUID = S.SKUID
WHERE ([NodeSiteID] = @NodeSiteID AND (NodeAliasPath IN (N'/5515', N'/'))) AND ([ClassName] IN (N'CMS.MenuItem', N'cms.office')) AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [NodeLevel] <= @NodeLevel AND [DocumentCulture] = @DocumentCulture)
ORDER BY NodeAliasPath DESC
1.5 kB
 
Table (1 [37], 198 B)
 
CMSAbstractMenuProperties.OnLoad 0.047
 
CloseConnection()
CMSAbstractMenuProperties.OnLoad N/A
OpenConnection()
CMSAbstractMenuProperties.OnLoad N/A
9
(cms.acl.generalselect)
DECLARE @ACLID int = 57;

SELECT *
FROM CMS_ACL
WHERE [ACLID] = @ACLID
Table (1 [5], 52 B)
 
CMSAbstractMenuProperties.OnLoad 0.031
 
CloseConnection()
CMSAbstractMenuProperties.OnLoad N/A
OpenConnection()
CMSAbstractMenuProperties.OnLoad N/A
10
(cms.aclitem.selectaclitemsbyaclidanduserid)
DECLARE @UserID int = 65;
DECLARE @SiteID int = 51;
DECLARE @Date datetime2 = '4/24/2019 10:30:49 AM';

SELECT DISTINCT X.Allowed,X.Denied,X.ValidTo,X.ACLID
FROM (
SELECT CMS_ACLItem.Allowed,CMS_ACLItem.Denied, null AS 'ValidTo',CMS_ACL.ACLID
FROM CMS_ACL INNER JOIN CMS_ACLItem ON CMS_ACLItem.ACLID = CMS_ACL.ACLID
WHERE
--User
(CMS_ACLItem.UserID IN (SELECT CMS_User.UserID FROM CMS_User JOIN CMS_UserSite ON CMS_User.UserID = CMS_UserSite.UserID
WHERE CMS_User.UserID = @UserID AND CMS_UserSite.SiteID = @SiteID )
-- Specific roles
OR CMS_ACLItem.RoleID IN (SELECT RoleID FROM CMS_Role WHERE RoleName IN ('_everyone_','_notauthenticated_'))
)
-- Membership
UNION ALL
SELECT DISTINCT CMS_ACLItem.Allowed,CMS_ACLItem.Denied, UserRole.ValidTo, CMS_ACL.ACLID
FROM CMS_ACL INNER JOIN CMS_ACLItem ON CMS_ACLItem.ACLID = CMS_ACL.ACLID
INNER JOIN [View_CMS_UserRoleMembershipRole] AS UserRole ON UserRole.RoleID = CMS_ACLItem.RoleID
WHERE (UserRole.ValidTo > @Date OR UserRole.ValidTo IS NULL)
AND (UserRole.SiteID = @SiteID OR UserRole.SiteID IS NULL)
AND UserRole.UserID = @UserID
) AS X
WHERE ACLID IN (57)

1.3 kB
 
CMSAbstractMenuProperties.OnLoad 0.016
 
CloseConnection()
CMSAbstractMenuProperties.OnLoad N/A
OpenConnection()
CMSAbstractMenuProperties.OnLoad N/A
11
(cms.class.selectrequiredroles)
DECLARE @ClassID int = 2214;
DECLARE @PermissionName nvarchar(max) = N'read';
DECLARE @SiteID int = 51;

SELECT * FROM CMS_Role WHERE RoleID IN (SELECT RoleID FROM CMS_RolePermission WHERE PermissionID IN (SELECT PermissionID FROM CMS_Permission WHERE ClassID=@ClassID AND PermissionName=@PermissionName)) AND (SiteID=@SiteID OR SiteID IS NULL)
CMSAbstractMenuProperties.OnLoad 0.031
 
CloseConnection()
CMSAbstractMenuProperties.OnLoad N/A
  11 queries, 8.7 kB write, 38 kB read   0.531
Macros resolved in the content of this page:
 ExpressionResultUserContextDuration
1 {% prefix %} The Faculty of Medical Sciences | The University of the West Indies at Cave Hill, Barbados ContentPage.OnLoad 0.000
 
> prefix The Faculty of Medical Sciences | The University of the West Indies at Cave Hill, Barbados 0.000
 
2 {% pagetitle_orelse_name %} Research 0.016
 
> pagetitle_orelse_name Research 0.000
 
      
ViewState used by the controls of this page:
 Control IDIs dirtyViewStateTotal size
1 form Yes
action = "/fms/research.aspx" (18 B)
18 B
 
2 p
pnlPage
Yes
CssClass = "PagePlaceholder" (15 B)
15 B
 
3 lt
cave_header1
DropDownList1
No
No
AutoPostBack = True
Width = 119px
0 B
 
4 lt
cave_header1
ImageButton1
No
No
No
Height = 33px
ImageUrl = "http://www.cavehill.uwi.edu/images/search_go_cavehill_off.png" (61 B)
Width = 33px
61 B
 
5 lt
partPlaceholder
pnlPage
Yes
CssClass = "PagePlaceholder" (15 B)
15 B
 
6 dbg
pnlDebugContainer
No
CssClass = "debug" (5 B)
5 B
 
     Total viewstate size: bytes