Package com.persequor.extension.statistics

Interface ITrackingStatisticsQuery

public interface ITrackingStatisticsQuery

Method Summary

Modifier and Type	Method	Description
ITrackingStatisticsResult	executeByDay()
ITrackingStatisticsResult	executeByMonth()
ITrackingStatisticsResult	executeByWeek()	Week will be represented as {YYYY}W{WW}
ITrackingStatisticsResult	executeRaw()
ITrackingStatisticsQuery	filterByAggregationLevels(String... aggregationLevel)
ITrackingStatisticsQuery	filterByBatchNumbers(String... batchNumber)
ITrackingStatisticsQuery	filterByBizLocations(String... bizLocation)
ITrackingStatisticsQuery	filterByBizSteps(String... bizStep)
ITrackingStatisticsQuery	filterByDate(LocalDate from, LocalDate to)
ITrackingStatisticsQuery	filterByDispositions(String... disposition)
ITrackingStatisticsQuery	filterByFactoryLocations(String... factoryLocation)
ITrackingStatisticsQuery	filterByMarkets(String... market)
ITrackingStatisticsQuery	filterByProducts(String... product)
ITrackingStatisticsQuery	filterByReadPoints(String... readPoint)
ITrackingStatisticsQuery	filterByShippedFrom(String... shippedFrom)
ITrackingStatisticsQuery	filterByShippedTo(String... shippedTo)
ITrackingStatisticsQuery	filterBySoldBy(String... soldBy)
ITrackingStatisticsQuery	filterBySoldTo(String... soldTo)
ITrackingStatisticsQuery	filterByUnits(String... unit)
ITrackingStatisticsQuery	groupByAggregationLevel()
ITrackingStatisticsQuery	groupByBatchNumber()
ITrackingStatisticsQuery	groupByBizLocation()
ITrackingStatisticsQuery	groupByDisposition()
ITrackingStatisticsQuery	groupByFactoryLocation()
ITrackingStatisticsQuery	groupByMarket()
ITrackingStatisticsQuery	groupByProduct()
ITrackingStatisticsQuery	groupByReadPoint()
ITrackingStatisticsQuery	groupByShippedFrom()
ITrackingStatisticsQuery	groupByShippedTo()
ITrackingStatisticsQuery	groupBySoldBy()
ITrackingStatisticsQuery	groupBySoldTo()
ITrackingStatisticsQuery	limit(int start, int count)	By default, results will be limited to 10000 rows
ITrackingStatisticsQuery	sortByAggregationLevel(boolean ascending)
ITrackingStatisticsQuery	sortByBatchNumber(boolean ascending)
ITrackingStatisticsQuery	sortByBizLocation(boolean ascending)
ITrackingStatisticsQuery	sortByBizStep(boolean ascending)
ITrackingStatisticsQuery	sortByDisposition(boolean ascending)
ITrackingStatisticsQuery	sortByFactoryLocation(boolean ascending)
ITrackingStatisticsQuery	sortByMarket(boolean ascending)
ITrackingStatisticsQuery	sortByProduct(boolean ascending)
ITrackingStatisticsQuery	sortByReadPoint(boolean ascending)
ITrackingStatisticsQuery	sortByShippedFrom(boolean ascending)
ITrackingStatisticsQuery	sortByShippedTo(boolean ascending)
ITrackingStatisticsQuery	sortBySoldBy(boolean ascending)
ITrackingStatisticsQuery	sortBySoldTo(boolean ascending)
ITrackingStatisticsQuery	sortByUnit(boolean ascending)

Method Details

filterByDate

ITrackingStatisticsQuery filterByDate(@Nullable
 LocalDate from,
 @Nullable
 LocalDate to)

filterByBizLocations

ITrackingStatisticsQuery filterByBizLocations(@Nonnull
 String... bizLocation)

filterByDispositions

ITrackingStatisticsQuery filterByDispositions(@Nonnull
 String... disposition)

filterByBizSteps

ITrackingStatisticsQuery filterByBizSteps(@Nonnull
 String... bizStep)

filterByProducts

ITrackingStatisticsQuery filterByProducts(@Nonnull
 String... product)

filterByReadPoints

ITrackingStatisticsQuery filterByReadPoints(@Nonnull
 String... readPoint)

filterByShippedTo

ITrackingStatisticsQuery filterByShippedTo(@Nonnull
 String... shippedTo)

filterByShippedFrom

ITrackingStatisticsQuery filterByShippedFrom(@Nonnull
 String... shippedFrom)

filterBySoldBy

ITrackingStatisticsQuery filterBySoldBy(@Nonnull
 String... soldBy)

filterBySoldTo

ITrackingStatisticsQuery filterBySoldTo(@Nonnull
 String... soldTo)

filterByFactoryLocations

ITrackingStatisticsQuery filterByFactoryLocations(@Nonnull
 String... factoryLocation)

filterByMarkets

ITrackingStatisticsQuery filterByMarkets(@Nonnull
 String... market)

filterByUnits

ITrackingStatisticsQuery filterByUnits(@Nonnull
 String... unit)

filterByBatchNumbers

ITrackingStatisticsQuery filterByBatchNumbers(@Nonnull
 String... batchNumber)

filterByAggregationLevels

ITrackingStatisticsQuery filterByAggregationLevels(@Nonnull
 String... aggregationLevel)

limit

ITrackingStatisticsQuery limit(int start,
 int count)

By default, results will be limited to 10000 rows

Parameters:

start - offset

count - the maximum number of rows

Returns:

this query with limit imposed

groupByBizLocation

ITrackingStatisticsQuery groupByBizLocation()

groupByDisposition

ITrackingStatisticsQuery groupByDisposition()

groupByProduct

ITrackingStatisticsQuery groupByProduct()

groupByReadPoint

ITrackingStatisticsQuery groupByReadPoint()

groupByShippedTo

ITrackingStatisticsQuery groupByShippedTo()

groupByShippedFrom

ITrackingStatisticsQuery groupByShippedFrom()

groupBySoldBy

ITrackingStatisticsQuery groupBySoldBy()

groupBySoldTo

ITrackingStatisticsQuery groupBySoldTo()

groupByFactoryLocation

ITrackingStatisticsQuery groupByFactoryLocation()

groupByMarket

ITrackingStatisticsQuery groupByMarket()

groupByBatchNumber

ITrackingStatisticsQuery groupByBatchNumber()

groupByAggregationLevel

ITrackingStatisticsQuery groupByAggregationLevel()

sortByBizLocation

ITrackingStatisticsQuery sortByBizLocation(boolean ascending)

sortByDisposition

ITrackingStatisticsQuery sortByDisposition(boolean ascending)

sortByBizStep

ITrackingStatisticsQuery sortByBizStep(boolean ascending)

sortByProduct

ITrackingStatisticsQuery sortByProduct(boolean ascending)

sortByReadPoint

ITrackingStatisticsQuery sortByReadPoint(boolean ascending)

sortByShippedTo

ITrackingStatisticsQuery sortByShippedTo(boolean ascending)

sortByShippedFrom

ITrackingStatisticsQuery sortByShippedFrom(boolean ascending)

sortBySoldBy

ITrackingStatisticsQuery sortBySoldBy(boolean ascending)

sortBySoldTo

ITrackingStatisticsQuery sortBySoldTo(boolean ascending)

sortByFactoryLocation

ITrackingStatisticsQuery sortByFactoryLocation(boolean ascending)

sortByMarket

ITrackingStatisticsQuery sortByMarket(boolean ascending)

sortByUnit

ITrackingStatisticsQuery sortByUnit(boolean ascending)

sortByBatchNumber

ITrackingStatisticsQuery sortByBatchNumber(boolean ascending)

sortByAggregationLevel

ITrackingStatisticsQuery sortByAggregationLevel(boolean ascending)

executeByMonth

ITrackingStatisticsResult executeByMonth()

Returns:

result rows grouped by Month and Unit

executeByWeek

ITrackingStatisticsResult executeByWeek()

Week will be represented as {YYYY}W{WW}

Returns:

result rows grouped by Week and Unit

executeByDay

ITrackingStatisticsResult executeByDay()

Returns:

result rows grouped by Day and Unit

executeRaw

ITrackingStatisticsResult executeRaw()

Returns:

result rows without grouping