select top 1 status
from tbl_EAI_InboundBatches with (nolock)
where ownerId =
and ownerType =
and fileFormat = '$OperatorAnalyzerETL'
and batchTime >=
and batchTime <= getDate()
order by batchTime desc
select format( purchasingMonth, 'MM/dd/yyyy' ) purchasingMonth, format( purchasingMonth, 'MMMM yyyy' ) as purchasingMonthDisplay, purchasingMonth as purchasingMonthRaw
from tbl_DW_PurchasingMonths#_tableSuffix# with (nolock)
where ownerId =
and ownerType =
and purchasingMonth <= getDate()
and 1 = 2
order by purchasingMonthRaw desc
for json auto
select top 1 purchasingMonth
from tbl_DW_PurchasingMonths#_tableSuffix# with (nolock)
where ownerId =
and ownerType =
and purchasingMonth <= getDate()
and 1 = 2
order by purchasingMonth desc
select distinct m.fspro_userId
from tbl_SEC_Groups g with (nolock)
inner join tbl_SEC_MemGrpLink mgl with (nolock)
on mgl.groupId = g.groupId
inner join tbl_Fspro_members m with (nolock)
on m.ownerId = g.ownerId
and m.fsl_tablecode = g.fsl_tablecode
and m.fspro_userId = mgl.fspro_userId
where g.groupLeaderId =
and g.ownerId =
and g.fsl_tablecode =
select distinct businessOwnerUserId
from tbl_DW_OperatorAgreements#_tableSuffix# with (nolock)
where ownerId =
and ownerType =
and businessOwnerUserId > 0
and (
businessOwnerUserId =
or businessOwnerUserId in ( )
)
{ "filters" :
{ "by" : "OPERATOR",
"operatorType" : "",
"territoryId" : 0,
"classificationId" : 0,
"segmentId" : 0,
"skuId" : 0,
"prodId" : 0,
"categoryId" : 0,
"prodline_Id" : 0,
"lastPurchasingMonth" : "#lsdateformat( qmd_lastPurchasingMonth.purchasingMonth, 'MM/DD/YYYY')#""01/01/1970",
"windowMonths" : "12",
"productHierarchy" : "",
"agreementOwners" : "yes",
"inferredPurchasers" : "no",
"sourceOfData" : "agreementOwners",
"choId" : 0,
"detailsBy" : "OPERATOR",
"distributorKeyId" : "",
"agreementOwnerChoId" : 0,
"businessOwnerUserId" : 0,
"budgetCategoryId" : 0,
"perspective" : "AgreementOwner",
"analyzerView" : "Summary",
"valueType" : "#_valueTypes[1]#",
"xchosenColumns": "operatortype,operatorName",
"chosenColumns": "agreementOwnerName" },
"analyzerViews" : [ "Summary", "ByMonth", "MonthOverMonth" , "WhiteSpace" ],
"purchasingMonths" : #qmd_purchasingMonths[listFirst( qmd_purchasingMonths.columnList)][currentRow]#[],
"analyzerReady" : truefalse,
"valueTypes" : #serializeJSON( _valueTypes )#,
"listManagementEnabled" : truefalse,
"whiteSpaceEnabled" : truefalse,
"selectedOperators" : [#client.operatorAnalyzerList#]
,
"analyzerFilters" : { "businessOwnerUserId" : #_businessOwnerUserId# }
}