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

Interface QapiPriceGrid

All Superinterfaces:
CalculableObjectColumns, Map<String,SelectableExpression>, PersistedObjectColumns, Tables.Columns, Tables.Table
public interface QapiPriceGrid extends Tables.Table, PersistedObjectColumns, CalculableObjectColumns
Table of Live Price Grid headers. Each row is one Live Price Grid, not one of its items.

Example: 


 def q = api.queryApi()
 def t = q.tables().priceGrids()

 return q.source(t, [t.id(), t.label(), t.priceGridType(), t.approvalState(), t.numberOfOpenItems()],
         t.label().like("%EU%"))
         .stream { it.collect { it } }
Since:
14.3 - Caribou Lou
See Also:

  • Method Details

    • nodeId

      SelectableExpression nodeId()
      Returns the node ID of the Live Price Grid.
      Returns:
      the nodeId column as an Integer expression

    • approvalState

      SelectableExpression approvalState()
      Returns the approval state of the Live Price Grid, derived from the approval of its items: NOT_APPROVED, PARTIALLY_APPROVED (some items are approved) or APPROVED.
      Returns:
      the approvalState column as an Enum expression
      See Also:

    • description

      SelectableExpression description()
      Returns the description of the Live Price Grid.
      Returns:
      the description column as a String expression

    • relativeTargetDateDays

      SelectableExpression relativeTargetDateDays()
      Returns the relative target date of the Live Price Grid, as a number of days from the current date. It is used when no fixed target date is set.
      Returns:
      the relativeTargetDateDays column as an Integer expression
      See Also:

    • numberOfApprovedItems

      SelectableExpression numberOfApprovedItems()
      Returns the number of approved items of the Live Price Grid.
      Returns:
      the numberOfApprovedItems column as an Integer expression

    • numberOfOpenItems

      SelectableExpression numberOfOpenItems()
      Returns the number of open items of the Live Price Grid.
      Returns:
      the numberOfOpenItems column as an Integer expression

    • numberOfDeniedItems

      SelectableExpression numberOfDeniedItems()
      Returns the number of denied items of the Live Price Grid.
      Returns:
      the numberOfDeniedItems column as an Integer expression

    • numberOfSubmittedItems

      SelectableExpression numberOfSubmittedItems()
      Returns the number of items of the Live Price Grid that are submitted for approval.
      Returns:
      the numberOfSubmittedItems column as an Integer expression

    • numberOfAutoApprovedItems

      SelectableExpression numberOfAutoApprovedItems()
      Returns the number of automatically approved items of the Live Price Grid.
      Returns:
      the numberOfAutoApprovedItems column as an Integer expression

    • integrationStatus

      SelectableExpression integrationStatus()
      Returns the integration status of the Live Price Grid.
      Returns:
      the integrationStatus column as a String expression

    • partialCalculationDate

      SelectableExpression partialCalculationDate()
      Returns the date and time when only part of the items of the Live Price Grid were last recalculated.

      A full recalculation updates calculationDate() instead.

      Returns:
      the partialCalculationDate column as a DateTime expression
      See Also:

    • priceGridType

      SelectableExpression priceGridType()
      Returns whether the items of the Live Price Grid have one key, the Stock Keeping Unit (SKU), or two keys, the SKU and key2: SIMPLE or MATRIX.
      Returns:
      the priceGridType column as an Enum expression

    • headerTypeUniqueName

      SelectableExpression headerTypeUniqueName()
      Returns the unique name of the Live Price Grid type that the grid was created from.
      Returns:
      the headerTypeUniqueName column as a String expression

    • createdByName

      SelectableExpression createdByName()
      Returns the name of the user who created the Live Price Grid.
      Returns:
      the createdByName column as a String expression
      See Also:

    • lastUpdateByName

      SelectableExpression lastUpdateByName()
      Returns the name of the user who last updated the Live Price Grid.
      Returns:
      the lastUpdateByName column as a String expression
      See Also:

    • userGroupEdit

      SelectableExpression userGroupEdit()
      Returns the user group whose members can edit the Live Price Grid.
      Returns:
      the userGroupEdit column as a String expression
      Since:
      15.3.15 - Southside, 16.1.1 - Black Cat
      See Also:

    • userGroupViewDetails

      SelectableExpression userGroupViewDetails()
      Returns the user group whose members can view the details of the Live Price Grid.
      Returns:
      the userGroupViewDetails column as a String expression
      Since:
      15.3.15 - Southside, 16.1.1 - Black Cat
      See Also: