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

Interface QapiDataSource

All Superinterfaces:
Map<String,SelectableExpression>, Tables.Columns, Tables.Table
public interface QapiDataSource extends Tables.Table
Table of the rows of one Analytics Data Source. A Data Source stores structured master or transactional data, for example the Product and Customer master data or invoice lines. Its rows are loaded by flushing its Data Feed, and several Data Sources can be joined into a Datamart.

Obtain it with api.queryApi().tables().dataSource(String), passing the unique name of the Data Source. An unknown name fails with an error. Besides the columns below, the fields of the Data Source are accessed as properties by their field name, for example ds.Country.

Example: 


 def q = api.queryApi()
 def ds = q.tables().dataSource("Gapminder")

 return q.source(ds, [ds.Country, ds.Population, ds.Year], ds.Country.equal("Canada"))
         .stream { it.collect { it } }
Since:
15.0 - Southside
See Also:

  • Method Details

    • isDeleted

      SelectableExpression isDeleted()
      Returns whether the row is flagged as deleted.
      Returns:
      the isDeleted column as a Boolean expression

    • lastUpdateDate

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