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

Interface PersistedObjectColumns

All Known Subinterfaces:
QapiActionItem, QapiCalculationGrid, QapiCalculationGridLineItem, QapiClaim, QapiClaimLineItem, QapiCompanyParameterRow, QapiCompanyParameterTable, QapiCompensationLineItem, QapiCompensationRecord, QapiConditionRecord, QapiContractLineItem, QapiCustomer, QapiCustomerExtensionRow, QapiCustomForm, QapiHistoricalConditionRecord, QapiJobStatusTracker, QapiPriceGrid, QapiPriceGridLineItem, QapiPriceList, QapiPriceListLineItem, QapiProduct, QapiProductBillOfMaterial, QapiProductCompetition, QapiProductExtensionRow, QapiProductReference, QapiQuoteLineItem, QapiRebateLineItem, QapiRebateRecord, QapiSeller, QapiSellerExtensionRow, QapiUser
public interface PersistedObjectColumns
Columns that every row of a Pricefx table has: its ID, its version and its audit information (who created and last updated it, and when).

Example: 


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

 return q.source(t, [t.id(), t.sku(), t.lastUpdateDate(), t.lastUpdateBy()],
         t.lastUpdateDate().greaterOrEqual(api.targetDate()))
         .stream { it.collect { it } }
Since:
13.1 - Rampur
See Also:

  • Method Details

    • id

      SelectableExpression id()
      Returns the ID of the row.

      The ID is generated by the system and is unique within the table. Some table accessors take an ID, for example priceListLineItems(long) takes the ID of a price list.

      Returns:
      the id column expression as an Integer

    • version

      SelectableExpression version()
      Returns the version of the row.

      The version is increased each time the row is updated. It is used to detect concurrent updates.

      Returns:
      the version column expression as an Integer

    • createDate

      SelectableExpression createDate()
      Returns the date and time when the row was created.
      Returns:
      the createDate column expression as a DateTime
      See Also:

    • createdBy

      SelectableExpression createdBy()
      Returns the ID of the user who created the row.

      Since 16.3.16 and 17.0.7, you can join the table returned by users() on its id() to get user details such as loginName().

      Returns:
      the createdBy (user id) column expression as an Integer
      See Also:

    • lastUpdateDate

      SelectableExpression lastUpdateDate()
      Returns the date and time when the row was last updated.
      Returns:
      the lastUpdateDate column expression as a DateTime
      See Also:

    • lastUpdateBy

      SelectableExpression lastUpdateBy()
      Returns the ID of the user who last updated the row.
      Returns:
      the lastUpdateBy (user id) column expression as an Integer
      See Also: