ReportMagic Macros

List Macros (20)

	Name	Description	Restriction	Compatibility
	[List.Add:]	Adds an item to a list. Adds an item to the list in the storeAs variable. If the storeAs refers to an unset variable, the list becomes just the new variable. The 'mode' parameter defaults to 'legacy' but will show a warning on the output. In this case, all variables are stored as strings. When set to 'normal', the variables will be stored as a List of objects, at full precision.
	[List.Analysis:]	Adds a List Analysis tab to the XLSX output document.
	[List.Complement:]	Determines items present in one list (list 2), but not in another (list 1).
	[List.Count:]UPDATED	Counts items in a list.
	[List.Dequeue:]	Retrieves the first item in a queue. Retrieves the first item in a queue. Outputs a JValue.Use unsetWhenEmpty=true to completely unset the variable if the resulting queue is empty.
	[List.Duplicates:]	Returns a list of duplicate items (duplicated at least once) from a source list. Returns a list of (distinct by default) duplicate items (duplicated at least once) from a source list.
	[List.First:]	Retrieves the first item from a list that matches a condition. If no item is found, null is returned.
	[List.Graph:]	Displays list data in chart form.
	[List.GroupBy:]UPDATED	Groups a List. Groups a List.In Legacy Mode, if a table of values is provided, e.g. A^B^2021-03-12;A^B^2021-03-11;A^B^2021-03-09;A^C^2021-03-12;A^C^2021-03-11, then specify the columns you wish to group by with groupByColumnIndices, zero-indexed and the output columns you want with outputColumns. In Normal Mode, you must provide a JArray (in 'values' and the properties you want to group by.
	[List.IndicesOf:]	Returns a list of index positions (starting at 0) of items in a list that match the specified string.
	[List.Intersection:]	Determines items present in both of two lists.
	[List.Item:]	Retrieves the Nth item from a list.
	[List.Range:]	Provides a list of integers.
	[List.Select:]	Selects only items in a list that meet a set of criteria.
	[List.SelectColumns:]	Selects one or more columns from a list.
	[List.Sort:]	Sorts a list. Sorts a List.If a table of values is provided, e.g. DeviceA^10^20;DeviceZ^5^30;DeviceDead^30^90;DeviceW^10^90, then specify the columns you wish to sort on with orderByColumns, zero-indexed.
	[List.SummaryValue:]	Summarises a numeric list. This is used to calculate a single summary value based on the contents of a numeric list. All values should be numbers.
	[List.Table:]	Insert a list as a table. Insert a list as a table. For row and cell thresholds (warning, error, critical, fatal), see Using Variable Parameters
	[List.Union:]	Determines items present in either of two lists.
	[List.Where:]UPDATED	Selects only items in a list that meet a set of criteria. Selects only items in a list that meet a set of criteria. The keyword 'value' should be used (and NOT in curly braces) to represent the list item being compared.

List Macros (20)

Search