USP_DATAFORMTEMPLATE_VIEW_QUERY_ODATAFEED

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@QUERYTYPE	tinyint	INOUT
@QUERYNAME	nvarchar(255)	INOUT
@ODATAURI	nvarchar(255)	INOUT
@ODATAHELPTEXT	nvarchar(4000)	INOUT
@ODATAURITEXT	nvarchar(2000)	INOUT

Definition

Copy


CREATE procedure dbo.[USP_DATAFORMTEMPLATE_VIEW_QUERY_ODATAFEED]
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @QUERYTYPE tinyint = null output,
  @QUERYNAME nvarchar(255) = null output,
  @ODATAURI nvarchar(255) = null output,
  @ODATAHELPTEXT nvarchar(4000) = null output,
  @ODATAURITEXT nvarchar(2000) = null output
)
as
    set nocount on;

    set @DATALOADED = 0;

  if exists (select 1 from dbo.[SMARTQUERYINSTANCE] where [ID] = @ID)

    begin

      select 
        @DATALOADED = 1,
            @QUERYTYPE = 1,
        @QUERYNAME = [NAME]
      from dbo.[SMARTQUERYINSTANCE]
      where [ID] = @ID;

    end

  else

    begin

      select 
        @DATALOADED = 1,
            @QUERYTYPE = 0,
        @QUERYNAME = [NAME]
      from dbo.[ADHOCQUERY]
      where [ID] = @ID;

    end

    return 0;