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

Interface QapiProductReference

All Superinterfaces:
Map<String,SelectableExpression>, PersistedObjectColumns, Tables.Columns, Tables.Table
public interface QapiProductReference extends Tables.Table, PersistedObjectColumns
Table of the Product References. Each row links a product to a referenced product and says how they relate, for example that one product is the cross-sell product of another.

Example, the products referenced by one product: 


 def q = api.queryApi()
 def ref = q.tables().productReferences()

 return q.source(ref, [ref.targetSku(), ref.referenceType()], ref.sku().equal("MB-0001"))
         .stream { it.collect { it } }
Since:
15.3.16 - Southside, 16.2.1 - Black Cat
See Also:

  • Method Details

    • sku

      SelectableExpression sku()
      Returns the Stock Keeping Unit (SKU) of the product that the reference is created for.
      Returns:
      the sku column as a String expression
      See Also:

    • targetSku

      SelectableExpression targetSku()
      Returns the Stock Keeping Unit (SKU) of the referenced product.
      Returns:
      the targetSku column as a String expression
      See Also:

    • referenceType

      SelectableExpression referenceType()
      Returns how the two products relate, for example a parent or a cross-sell product. The value is free text defined by the project, and can be empty.
      Returns:
      the referenceType column as a String expression

    • infoDate

      SelectableExpression infoDate()
      Returns the information date of the reference.
      Returns:
      the infoDate column as a DateTime expression

    • internalReference

      SelectableExpression internalReference()
      Returns the internal reference flag. The application does not use it; the project can give it its own meaning.
      Returns:
      the internalReference column as a Boolean expression

    • additionalInfo1

      SelectableExpression additionalInfo1()
      Returns the first additional numeric information of the reference.
      Returns:
      the additionalInfo1 column as a Real expression

    • additionalInfo2

      SelectableExpression additionalInfo2()
      Returns the second additional numeric information of the reference.
      Returns:
      the additionalInfo2 column as a Real expression

    • additionalInfo3

      SelectableExpression additionalInfo3()
      Returns the first additional text information of the reference.
      Returns:
      the additionalInfo3 column as a String expression

    • additionalInfo4

      SelectableExpression additionalInfo4()
      Returns the second additional text information of the reference.
      Returns:
      the additionalInfo4 column as a String expression

    • comments

      SelectableExpression comments()
      Returns the comments on the reference.
      Returns:
      the comments column as a String expression