Package net.pricefx.formulaengine.scripting.queryapi.tables

Interface QapiCalculationGridLineItem

All Superinterfaces:
ApprovableColumns, CalculableObjectLineItemColumns, Map<String,SelectableExpression>, PersistedObjectColumns, Tables.Columns, Tables.Table
public interface QapiCalculationGridLineItem extends Tables.Table, PersistedObjectColumns, ApprovableColumns, CalculableObjectLineItemColumns
Table of the items of one Calculation Grid. Each row is one item, identified by its keys.

The keys identify what the item is about, for example the unique name of a business unit or a product group. The table only has the key columns that the Calculation Grid uses: calling a key method above the number of keys of the grid, for example key4() on a grid with 3 keys, fails with an error.

Example: 


 def q = api.queryApi()
 def t = q.tables().calculationGridLineItems(1234)

 return q.source(t, [t.key1(), t.key2(), t.label(), t.workflowStatus()], t.isCompleted().isTrue())
         .stream { it.collect { it } }
Since:
14.0 - Caribou Lou
See Also:

  • Method Details

    • key1

      SelectableExpression key1()
      Returns the first key of the item.
      Returns:
      the key1 column as an expression (its type will be taken from the corresponding attribute meta configuration if it exists)
      See Also:

    • key2

      SelectableExpression key2()
      Returns the second key of the item. Only available when the Calculation Grid has at least 2 keys.
      Returns:
      the key2 column as an expression (its type will be taken from the corresponding attribute meta configuration if it exists)
      See Also:

    • key3

      SelectableExpression key3()
      Returns the third key of the item. Only available when the Calculation Grid has at least 3 keys.
      Returns:
      the key3 column as an expression (its type will be taken from the corresponding attribute meta configuration if it exists)
      See Also:

    • key4

      SelectableExpression key4()
      Returns the fourth key of the item. Only available when the Calculation Grid has at least 4 keys.
      Returns:
      the key4 column as an expression (its type will be taken from the corresponding attribute meta configuration if it exists)
      See Also:

    • key5

      SelectableExpression key5()
      Returns the fifth key of the item. Only available when the Calculation Grid has at least 5 keys.
      Returns:
      the key5 column as an expression (its type will be taken from the corresponding attribute meta configuration if it exists)
      See Also:

    • key6

      SelectableExpression key6()
      Returns the sixth key of the item. Only available when the Calculation Grid has 6 keys.
      Returns:
      the key6 column as an expression (its type will be taken from the corresponding attribute meta configuration if it exists)
      See Also:

    • calculationGridId

      SelectableExpression calculationGridId()
      Returns the ID of the Calculation Grid that the item belongs to.
      Returns:
      the calculationGridId column as an Integer expression
      See Also:

    • manualEditVersion

      SelectableExpression manualEditVersion()
      Returns the number of times a user edited the item manually.

      The value starts at 0 and is increased by each manual edit.

      Returns:
      the manualEditVersion column as an Integer expression
      See Also:

    • manualEditUser

      SelectableExpression manualEditUser()
      Returns the ID of the user who last edited the item manually.
      Returns:
      the manualEditUser column as an Integer expression
      See Also:

    • approvalDate

      SelectableExpression approvalDate()
      Returns the date and time when the item was approved.
      Returns:
      the approvalDate column as a DateTime expression
      See Also:

    • denialDate

      SelectableExpression denialDate()
      Returns the date and time when the item was denied.
      Returns:
      the denialDate column as a DateTime expression
      See Also:

    • denialReason

      SelectableExpression denialReason()
      Returns the reason given when the item was denied.
      Returns:
      the denialReason column as a String expression
      See Also:

    • submitDate

      SelectableExpression submitDate()
      Returns the date and time when the item was submitted for approval.
      Returns:
      the submitDate column as a DateTime expression
      See Also:

    • isCompleted

      SelectableExpression isCompleted()
      Returns the flag that marks an item as successfully calculated.
      Returns:
      the isCompleted column as a Boolean expression