DECLARE @query nvarchar(max);
DECLARE @currentloginname nvarchar(42);
SET @query = N'
SELECT

  /*COLUMNS*/
WFD_ID,
CONVERT(varchar(20),WFD_ID) as WFD_ID_String,
WFD_Signature,
DEF_ID,
WFD_RowVersion,
ISNULL(TranslatesSteps.TRANS_Name,ISNULL(SecondaryTranslatesSteps.TRANS_Name,STP_Name)) as STP_Name,
STP_ID,
TaskData.DisplayName as AssignedPerson,
TaskData.LoginName as AssignedPerson_ID,
TaskData.FieldValue as AssignedPerson_BPS,
datediff(d,WFD_EnterToCurrentStepDate,dbo.GetDbDate()) as WFD_StepDuration,
dbo.ClearWFElemAdv(ISNULL(WFD_AttChoose1, '''')) as WFD_AttChoose1,
dbo.ClearWFElemIDAdv(ISNULL(WFD_AttChoose1, '''')) as WFD_AttChoose1_ID,
ISNULL(WFD_AttChoose1, '''') as WFD_AttChoose1_BPS,
ISNULL(WFD_AttText1, '''') as WFD_AttText1,
ISNULL(WFD_AttLong1, '''') as WFD_AttLong1,
dbo.ClearWFElemAdv(ISNULL(WFD_AttChoose2, '''')) as WFD_AttChoose2,
dbo.ClearWFElemIDAdv(ISNULL(WFD_AttChoose2, '''')) as WFD_AttChoose2_ID,
ISNULL(WFD_AttChoose2, '''') as WFD_AttChoose2_BPS
  /*COLUMNS_END*/
FROM V_WFElements as wfelems

    LEFT JOIN Translates AS TranslatesSteps ON (STP_ID = TranslatesSteps.TRANS_ELEMID AND TranslatesSteps.TRANS_OBJID = 5 AND TranslatesSteps.TRANS_LANID = 8)
LEFT JOIN Translates AS SecondaryTranslatesSteps ON (STP_ID = SecondaryTranslatesSteps.TRANS_ELEMID AND SecondaryTranslatesSteps.TRANS_OBJID = 5 AND SecondaryTranslatesSteps.TRANS_LANID = 0)

    /*TASKDETAILSJOIN*/
                    OUTER APPLY GetTaskForElement(WFD_ID, @currentloginname) as TaskData
                    /*TASKDETAILSJOIN_END*/


WHERE WFD_ID IN (
SELECT  WFD_ID
FROM WFElements
JOIN WFDocTypes ON WFD_DTYPEID = DTYPE_ID
JOIN WFSteps ON WFD_STPID = STP_ID


where WFD_STPID in (995,996,997,1073,1279) /*ADVANCEDINNERSEARCH*/   AND (1=1 )

)


/*ADVANCEDSEARCH*/


/*FILTERSWHERE*/
/*GROUPQUERY*/
/*URLQUERY*/
/*AGGREGATIONQUERY*/

  /*ORDERBYSCLAUSE*/ ORDER BY WFD_ID DESC /*ORDERBYSCLAUSE_END*/';

SET @currentloginname = N'';

exec sp_executesql @query, N'@currentloginname nvarchar(42)', @currentloginname