A B C D E F G H I J K L M N O P Q R S T U V W X Y Z _

A

B

BatchUtils - Script in SharedLib.elements

buildCacheKey(String, String, String) - Method in MetadataUtils

C

CacheUtils - Script in SharedLib.elements

CHAR_EMPTY - Property in Stopwatch

CHAR_FILLED - Property in Stopwatch

CHAR_HAS_CHILD - Property in Stopwatch

CHAR_LAST - Property in Stopwatch

CHAR_SIBLING - Property in Stopwatch

closeStream(def, Closure) - Method in StreamUtils

Utility to close stream after processing

currentYear() - Method in DateUtils

Returns the current year as integer @return

D

DateUtils - Script in SharedLib.elements

daysInMonth(int, Integer) - Method in DateUtils

Returns the number of days within specified month of the year

DEFAULT_DECIMAL_DIGITS - Property in RoundingUtils

DETAULT_TEAMS_WEBHOOK_URL - Property in MicrosoftTeamsUtils

This is mandatory parameter!

E

F

findCAMAttributeId(String) - Method in MetadataUtils

findCXAM(String, String) - Method in MetadataUtils

findMLTVM(String, String) - Method in MetadataUtils

findPAMAttributeId(String) - Method in MetadataUtils

findPGIM(String, String) - Method in MetadataUtils

findPGIMBatched(String, List) - Method in MetadataUtils

findPLIM(String, String) - Method in MetadataUtils

findPLIMBatched(String, List) - Method in MetadataUtils

findPXAM(String, String) - Method in MetadataUtils

G

getAttributeIdFromLabel(String, String, String) - Method in MetadataUtils

Function used as dynamical way to call - getLTVAttributeId - getPXAttributeId - getPGIAttributeId - getPLIAttributeId - getPAttributeId

getCAttributeId(String) - Method in MetadataUtils

Function used for finding id of Customer column, based on label from metadata(name in GUI) Results use cache in api.global - api.retainGlobal() should improve performance

getComparePart(BigDecimal, BigDecimal) - Method in RoundingUtils

Get compare part of a number

getCurrentBatchSku() - Method in BatchUtils

Returns a set of SKUs of a current batch.

getCXAttributeId(String, String) - Method in MetadataUtils

Function used for finding id of a CX column, based on label from metadata (name in GUI).

getLTVAttributeId(String, String) - Method in MetadataUtils

Function used for finding id of a PP column, based on label from metadata (name in GUI).

getMedian(List<Number>) - Method in StatisticUtils

Get median from list of numbers

getOrSet(String, List, Closure, Boolean) - Method in CacheUtils

Uses getOrSetMap method passing api.global as default map

getOrSetGlobalAndShared(String, List, Closure, Boolean) - Method in CacheUtils

Cache objects in api.global and shared cache, run closure to fill

getOrSetMap(Map, String, List, Closure, Boolean) - Method in CacheUtils

Cache objects in provided map, run closure to fill

getOrSetShared(Integer, String, List, Closure) - Method in CacheUtils

Same as getOrSetShared, but with an enforced Max TTL before refresh is forced Does not guarantee Minimum TTL, or removal from cache Ironically uses cache to store TTL.

getPAttributeId(String) - Method in MetadataUtils

Function used for finding id of Product collum, based on label from metadata(name in GUI) Results use cache in api.global - api.retainGlobal() should improve performance

getPGIAttributeId(String, String) - Method in MetadataUtils

Function used for finding id of a PGI column, based on label from metadata (name in GUI).

getPGIAttributeIdBatched(String, List) - Method in MetadataUtils

Function used for finding ids of a PGI columns, based on labels from metadata (names in GUI).

getPLIAttributeId(String, String) - Method in MetadataUtils

Function used for finding id of a PLI column, based on label from metadata (name in GUI).

getPLIAttributeIdBatched(String, List) - Method in MetadataUtils

Function used for finding ids of a PLI columns, based on labels from metadata (names in GUI).

getPPIdFromName(String) - Method in MetadataUtils

To look through records of PP, it's ID is needed.

getPXAttributeId(String, String) - Method in MetadataUtils

Function used for finding id of a PX column, based on label from metadata (name in GUI).

getRoundedDownDecimal(BigDecimal, BigDecimal) - Method in RoundingUtils

Get the nearest number that less than the number to be rounded and have the suffix in decimal part

getRoundedDownWhole(BigDecimal, BigDecimal) - Method in RoundingUtils

Get the nearest number that less than the number to be rounded and have the suffix in whole number part

getRoundedNumber(BigDecimal, BigDecimal, BigDecimal, String) - Method in RoundingUtils

Round a number with specified end points

getRoundedUpDecimal(BigDecimal, BigDecimal) - Method in RoundingUtils

Get the nearest number that greater than the number to be rounded and have the suffix in decimal part

getRoundedUpWhole(BigDecimal, BigDecimal) - Method in RoundingUtils

Get the nearest number that greater than the number to be rounded and have the suffix in whole number part

getRoundingModeEnum(String) - Method in RoundingUtils

Get rounding mode in standard enum

getStop() - Method in Stopwatch

Groovy getter to enable the Stopwatch.stop syntax (without parentheses).

H

HEADER - Property in Stopwatch

I

intersectingDays(Date, Date, Date, Date) - Method in DateUtils

Returns the number of days of overlap (intersect) within two provided date periods

isNewBatch() - Method in BatchUtils

Returns true whether a new batch of SKUs is being calculated.

J

javadoc() - Method in Stopwatch

The Stopwatch library can be used to measure performance of code blocks within a single formula element or across multiple elements.

K

L

lap(String) - Method in Stopwatch

Stops measuring the previous time block and starts a new one.

M

main(String) - Method in BatchUtils

Implicit main method for Groovy Scripts

main(String) - Method in CacheUtils

Implicit main method for Groovy Scripts

main(String) - Method in DateUtils

Implicit main method for Groovy Scripts

main(String) - Method in MetadataUtils

Implicit main method for Groovy Scripts

main(String) - Method in MicrosoftTeamsUtils

Implicit main method for Groovy Scripts

main(String) - Method in NumberUtils

Implicit main method for Groovy Scripts

main(String) - Method in ResultMatrixUtils

Implicit main method for Groovy Scripts

main(String) - Method in RoundingUtils

Implicit main method for Groovy Scripts

main(String) - Method in StatisticUtils

Implicit main method for Groovy Scripts

main(String) - Method in Stopwatch

Implicit main method for Groovy Scripts

main(String) - Method in StreamUtils

Implicit main method for Groovy Scripts

maxdate(Date, Date) - Method in DateUtils

Returns the greater of two provided dates

measure(String, Closure) - Method in Stopwatch

Starts measuring a time block with the given name.

MetadataUtils - Script in SharedLib.elements

MicrosoftTeamsUtils - Script in MonitoringLib.elements

mindate(Date, Date) - Method in DateUtils

Returns the lesser of two provided dates

N

NumberUtils - Script in SharedLib.elements

O

P

prepareBatch(String) - Method in BatchUtils

Prepares a set of SKUs of items being calculated in the current batch and internally caches this to api.global.currentBatch, api.local.isNewBatch and api.global.iterationNumber.

Q

R

resultMatrixFromList(List<Map>, Map, Closure<Map>) - Method in ResultMatrixUtils

Convert list of item to a resultMatrix

ResultMatrixUtils - Script in SharedLib.elements

round(BigDecimal, String, String) - Method in RoundingUtils

Transforms a number to have a specific suffix.

ROUNDING_MODES - Property in RoundingUtils

ROUNDING_RULES - Property in RoundingUtils

ROUNDING_TYPES - Property in RoundingUtils

RoundingUtils - Script in SharedLib.elements

roundPercent(BigDecimal) - Method in RoundingUtils

Round a percentage to 2 decimals or upon based on a rounding lookup table name if provided.

roundPrice(BigDecimal, int) - Method in RoundingUtils

Rounds a price to N decimals

roundUp(BigDecimal, int) - Method in RoundingUtils

A general function that rounds up a number to N decimals

S

sendMessage(String, List<Map>) - Method in MicrosoftTeamsUtils

Sends a message to the default Microsoft Teams channel defined by DETAULT_TEAMS_WEBHOOK_URL See more: https://docs.microsoft.com/en-us/microsoftteams/platform/concepts/connectors/connectors-using#creating-messages-through-office-365-connectors

SEPARATOR - Property in Stopwatch

start(String) - Method in Stopwatch

Starts measuring a time block with the given name.

StatisticUtils - Script in SharedLib.elements

stop() - Method in Stopwatch

Stops measuring the time of the time block started with start(String).

Stopwatch - Script in StopwatchLib.elements

stream(String, String, Map<String, String>, boolean, List<Filter>, Closure) - Method in StreamUtils

Self closable wrapper of api.stream(String typeCode, String sortBy, Map fields, boolean distinctValuesOnly, Filter... filters)

StreamUtils - Script in SharedLib.elements

T

TEAMS_ICON_URL - Property in MicrosoftTeamsUtils

Pricefx logo (link from Twitter)

THEME_COLOR - Property in MicrosoftTeamsUtils

Theme color of the teams message

toBigDecimal(Object, BigDecimal, boolean) - Method in NumberUtils

Cast Number to BigDecimal

toList(boolean, String) - Method in Stopwatch

Creates a time report and returns it in a List of Lists.

toPercentage(Object) - Method in NumberUtils

Calculate percentage by dividing to 100.

toResultMatrix(boolean, String) - Method in Stopwatch

Creates a time report and puts it into a ResultMatrix.

toString(boolean, String) - Method in Stopwatch

Creates a time report and returns it in a formatted String.

trace(boolean, String) - Method in Stopwatch

Creates a time report and prints it using api.trace.

trunc(BigDecimal) - Method in RoundingUtils

Remove decimal part of a BigDecimal

tryDecodeJSON(def) - Method in CacheUtils

An unfortunate hack I couldn't make more elegant...

U

V

W

X

Y

Z

_

_elementName(def) - Method in Stopwatch

!!!

_formatMs(def) - Method in Stopwatch

!!!

_formatPct(def, boolean) - Method in Stopwatch

!!!

_renderPct(def, def) - Method in Stopwatch

!!!

_stopwatch() - Method in Stopwatch

!!!