USP_DATAFORMTEMPLATE_VIEW_EVENTSWORKCENTERPAGEEXPRESSION
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CURRENTAPPUSERID | uniqueidentifier | IN | |
| @DATALOADED | bit | INOUT | |
| @HASACCESSTOSEARCH | bit | INOUT |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_EVENTSWORKCENTERPAGEEXPRESSION
(
@CURRENTAPPUSERID uniqueidentifier,
@DATALOADED bit = 0 output,
@HASACCESSTOSEARCH bit = null output
)
as
set nocount on;
set @DATALOADED = 1;
if (select [APPUSER].[ISSYSADMIN] from dbo.APPUSER where [APPUSER].[ID] = @CURRENTAPPUSERID) = 1 or
dbo.UFN_SECURITY_APPUSER_GRANTED_SEARCHLIST_IN_SYSTEMROLE(@CURRENTAPPUSERID, 'ba7498f1-8a0e-4324-bf92-25f725c23b06') = 1
set @HASACCESSTOSEARCH = 1;
return 0;