Uses of Interface
net.pricefx.formulaengine.scripting.queryapi.Tables.Columns

Packages that use Tables.Columns

Package	Description
net.pricefx.formulaengine.scripting.queryapi	The Query API, the unified Groovy API for reading data from Pricefx.
net.pricefx.formulaengine.scripting.queryapi.tables	Typed table descriptors of the Query API.

Uses of Tables.Columns in net.pricefx.formulaengine.scripting.queryapi

Subinterfaces of Tables.Columns in net.pricefx.formulaengine.scripting.queryapi

Modifier and Type	Interface	Description
static interface	Tables.Table	A concrete domain table

Methods in net.pricefx.formulaengine.scripting.queryapi with parameters of type Tables.Columns

Modifier and Type	Method	Description
Expression	Exprs.fromDataSlice(Tables.Columns columns, DatamartContext.DataSlice dataSlice)	Translates a PA DatamartContext.DataSlice into a query api Expression.

Method parameters in net.pricefx.formulaengine.scripting.queryapi with type arguments of type Tables.Columns

Modifier and Type	Method	Description
PipelineStage	PipelineStage.addColumns(Function<Tables.Columns,Collection<? extends Selectable>> expressions)	Adds a stage that adds columns to this stage output.
PipelineStage	PipelineStage.aggregate(Function<Tables.Columns,Collection<? extends Selectable>> selectables)	Adds a stage that aggregates all this stage output rows.
PipelineStage	PipelineStage.aggregateBy(Function<Tables.Columns,Collection<? extends Expression>> by, Function<Tables.Columns,Collection<? extends Selectable>> selectables)	Adds a stage that aggregates the outputs of this stage by a given set of expressions.
PipelineStage	PipelineStage.aggregateByGroups(Function<Tables.Columns,Groups.GroupingSets> by, Function<Tables.Columns,Collection<? extends Selectable>> selectables)	Adds a stage that aggregates the outputs of this stage by a given list of groupings.
PipelineStage	PipelineStage.crossJoin(PipelineStage pipeline, BiFunction<Tables.Columns,Tables.Columns,Collection<? extends Selectable>> selectables)	Adds a crossJoin stage that joins to this PipelineStage another PipelineStage.
PipelineStage	PipelineStage.crossJoin(PipelineStage pipeline, BiFunction<Tables.Columns,Tables.Columns,Collection<? extends Selectable>> selectables)	Adds a crossJoin stage that joins to this PipelineStage another PipelineStage.
PipelineStage	PipelineStage.crossJoin(Tables.Table table, Function<Tables.Columns,Collection<? extends Selectable>> selectables)	Adds a crossJoin stage that joins to this PipelineStage another Tables.Table.
PipelineStage	PipelineStage.filter(Function<Tables.Columns,Expression> condition)	Adds a stage that only keeps this stage output rows which verify the given expression.
PipelineStage	PipelineStage.innerJoin(PipelineStage pipeline, BiFunction<Tables.Columns,Tables.Columns,Collection<? extends Selectable>> selectables, BiFunction<Tables.Columns,Tables.Columns,Expression> joinCriteria)	Adds an innerJoin stage that joins this PipelineStage to another PipelineStage.
PipelineStage	PipelineStage.innerJoin(PipelineStage pipeline, BiFunction<Tables.Columns,Tables.Columns,Collection<? extends Selectable>> selectables, BiFunction<Tables.Columns,Tables.Columns,Expression> joinCriteria)	Adds an innerJoin stage that joins this PipelineStage to another PipelineStage.
PipelineStage	PipelineStage.innerJoin(Tables.Table table, Function<Tables.Columns,Collection<? extends Selectable>> selectables, Function<Tables.Columns,Expression> joinCriteria)	Adds an innerJoin stage that joins this PipelineStage to another Tables.Table.
PipelineStage	PipelineStage.leftOuterJoin(PipelineStage pipeline, BiFunction<Tables.Columns,Tables.Columns,Collection<? extends Selectable>> selectables, BiFunction<Tables.Columns,Tables.Columns,Expression> joinCriteria)	Adds a leftOuterJoin stage that joins to this PipelineStage another PipelineStage.
PipelineStage	PipelineStage.leftOuterJoin(PipelineStage pipeline, BiFunction<Tables.Columns,Tables.Columns,Collection<? extends Selectable>> selectables, BiFunction<Tables.Columns,Tables.Columns,Expression> joinCriteria)	Adds a leftOuterJoin stage that joins to this PipelineStage another PipelineStage.
PipelineStage	PipelineStage.leftOuterJoin(Tables.Table table, Function<Tables.Columns,Collection<? extends Selectable>> selectables, Function<Tables.Columns,Expression> joinCriteria)	Adds a leftOuterJoin stage that joins to this PipelineStage another Tables.Table.
PipelineStage	PipelineStage.removeColumns(Function<Tables.Columns,Collection<? extends Selectable>> columns)	Adds a stage that remove the given columns from this stage output.
PipelineStage	PipelineStage.retainColumns(Function<Tables.Columns,Collection<? extends Selectable>> columns)	Deprecated. Use PipelineStage.selectColumns(Function) instead.
PipelineStage	PipelineStage.selectColumns(Function<Tables.Columns,Collection<? extends Selectable>> columns)	Adds a stage that keeps and adds the given columns from this stage output.
PipelineStage	PipelineStage.sortBy(Function<Tables.Columns,List<Orders.Order>> orders)	Adds a stage that sorts this stage output rows.

Uses of Tables.Columns in net.pricefx.formulaengine.scripting.queryapi.tables

Subinterfaces of Tables.Columns in net.pricefx.formulaengine.scripting.queryapi.tables

Modifier and Type	Interface	Description
static interface	ClicColumns.InputColumns	Deprecated. Use InputsColumns.InputColumns instead.
static interface	ClicColumns.OutputColumns	Deprecated. Use OutputsColumns.OutputColumns instead.
static interface	InputsColumns.InputColumns	The columns of one input of a row, as returned by InputsColumns.input(String).
static interface	OutputsColumns.OutputColumns	The columns of one output of a row, as returned by OutputsColumns.output(String).
interface	QapiActionItem	Table of Action Items, the actions that users are expected to perform, such as creating a quote or checking some prices.
interface	QapiCalculationGrid	Table of Calculation Grid headers.
interface	QapiCalculationGridLineItem	Table of the items of one Calculation Grid.
interface	QapiClaim	Table of Claim headers.
interface	QapiClaimLineItem	Table of the lines of one Claim.
interface	QapiCompanyParameterRow	Table of the rows of one Company Parameter table.
interface	QapiCompanyParameterTable	Table of Company Parameter table headers.
interface	QapiCompensationLineItem	Table of the line items of one Compensation Plan.
interface	QapiCompensationRecord	Table of the Compensation Records of one Compensation Record Set.
interface	QapiConditionRecord	Table of the Condition Records of one Condition Record Set.
interface	QapiContractLineItem	Table of the line items of one Agreement or Promotion (contract).
interface	QapiCustomer	Table of the Customer master data.
interface	QapiCustomerExtensionRow	Table of the rows of one Customer Extension (CX) table.
interface	QapiCustomForm	Table of the Custom Forms of one Custom Form Type.
interface	QapiDataFeed	Table of the rows of one Analytics Data Feed.
interface	QapiDatamart	Table of the rows of one Analytics Datamart.
interface	QapiDataSource	Table of the rows of one Analytics Data Source.
interface	QapiHistoricalConditionRecord	Table of the history of the Condition Records of one Condition Record Set.
interface	QapiJobStatusTracker	Table of the job status trackers of the partition.
interface	QapiModelTable	Table of the rows of one table owned by a Model Object.
interface	QapiPriceGrid	Table of Live Price Grid headers.
interface	QapiPriceGridLineItem	Table of the items of one Live Price Grid.
interface	QapiPriceList	Table of Price List headers.
interface	QapiPriceListLineItem	Table of the items of one Price List.
interface	QapiProduct	Table of the Product master data.
interface	QapiProductBillOfMaterial	Table of the Bill of Materials (BoM) data.
interface	QapiProductCompetition	Table of the Competition Data.
interface	QapiProductExtensionRow	Table of the rows of one Product Extension (PX) table.
interface	QapiProductReference	Table of the Product References.
interface	QapiQuoteLineItem	Table of the line items of one Quote.
interface	QapiRebateLineItem	Table of the line items of one Rebate Agreement.
interface	QapiRebateRecord	Table of the Rebate Records of one Rebate Record Set.
interface	QapiRollup	Table of the rows of one Analytics Rollup.
interface	QapiSeller	Table of the Seller master data.
interface	QapiSellerExtensionRow	Table of the rows of one Seller Extension (SX) table.
interface	QapiUser