Uses of Interface
net.pricefx.formulaengine.scripting.queryapi.SelectableExpression
Packages that use SelectableExpression
Package
Description
The Query API, the unified Groovy API for reading data from Pricefx.
-
Uses of SelectableExpression in net.pricefx.formulaengine.scripting.queryapi
Methods in net.pricefx.formulaengine.scripting.queryapi that return SelectableExpressionModifier and TypeMethodDescriptionBuilds aSelectableExpressionhaving the same value as this expression and named after the given alias. -
Uses of SelectableExpression in net.pricefx.formulaengine.scripting.queryapi.tables
Methods in net.pricefx.formulaengine.scripting.queryapi.tables that return SelectableExpressionModifier and TypeMethodDescriptionQapiActionItem.actionItemTypeUniqueName()QapiPriceGridLineItem.activeCalculationResult(String elementName) QapiPriceGridLineItem.activeCalculationResults()QapiPriceGridLineItem.activePrice()QapiPriceGridLineItem.activePriceDate()QapiProductBillOfMaterial.additionalInfo1()QapiProductCompetition.additionalInfo1()QapiProductReference.additionalInfo1()QapiProductBillOfMaterial.additionalInfo2()QapiProductCompetition.additionalInfo2()QapiProductReference.additionalInfo2()QapiProductBillOfMaterial.additionalInfo3()QapiProductCompetition.additionalInfo3()QapiProductReference.additionalInfo3()QapiProductBillOfMaterial.additionalInfo4()QapiProductCompetition.additionalInfo4()QapiProductReference.additionalInfo4()QapiRebateRecord.agreementStatus()QapiCompensationRecord.agreementTermsJson()QapiRebateRecord.agreementTermsJson()CalculableObjectLineItemColumns.alerts()CalculableObjectLineItemColumns.allowedOverrides()QapiCalculationGridLineItem.approvalDate()QapiCompensationRecord.approvalDate()QapiPriceGridLineItem.approvalDate()QapiPriceList.approvalDate()QapiRebateRecord.approvalDate()QapiCompensationRecord.approvalState()QapiPriceGrid.approvalState()QapiPriceGridLineItem.approvalState()QapiPriceList.approvalState()QapiRebateRecord.approvalState()ApprovableColumns.approvedByName()QapiActionItem.assignedTo()QapiActionItem.assignedToGroup()QapiActionItem.assignedToName()PriceCalculableObjectLineItemColumns.calculatedResultPrice()QapiCompensationLineItem.calculationBaseJson()QapiCompensationRecord.calculationBaseJson()QapiContractLineItem.calculationBaseJson()QapiRebateLineItem.calculationBaseJson()QapiRebateRecord.calculationBaseJson()CalculableObjectColumns.calculationDate()QapiClaim.calculationDate()QapiCompensationRecord.calculationDate()QapiRebateRecord.calculationDate()QapiCalculationGridLineItem.calculationGridId()CalculableObjectColumns.calculationMessages()QapiClaim.calculationMessages()CalculableObjectLineItemColumns.calculationResult(String elementName) CalculableObjectColumns.calculationStartDate()QapiClaim.calculationStartDate()CalculableLineItemColumns.calculationStatus()QapiClaimLineItem.calculationStatus()QapiCompensationRecord.calculationStatus()QapiRebateRecord.calculationStatus()QapiJobStatusTracker.cancelRequested()QapiProductBillOfMaterial.category()QapiClaim.claimRecordUniqueName()QapiClaim.claimStatus()QapiClaim.claimTypeUniqueName()CalculableObjectLineItemColumns.comments()QapiProductBillOfMaterial.comments()QapiProductCompetition.comments()QapiProductReference.comments()QapiCompensationLineItem.compensationConditionTypeLabel()QapiCompensationLineItem.compensationConditionTypeUniqueName()QapiCompensationRecord.compensationConditionTypeUniqueName()QapiCompensationRecord.compensationHeaderTypeUniqueName()QapiCompensationRecord.compensationRecordSetLabel()QapiCompensationRecord.compensationStatus()QapiProductCompetition.competitionType()QapiProductCompetition.competitor()QapiProductCompetition.competitorSku()CalculableObjectLineItemColumns.completeCalculationResults()QapiActionItem.completedBy()QapiActionItem.completedByName()QapiActionItem.completedDate()CalculableObjectLineItemColumns.completeResultsAvailable()QapiJobStatusTracker.concurrencyKey()QapiConditionRecord.conditionValue()QapiHistoricalConditionRecord.conditionValue()QapiContractLineItem.contractTermTypeLabel()QapiContractLineItem.contractTermTypeUniqueName()QapiClaimLineItem.contractUniqueName()QapiProductCompetition.country()PersistedObjectColumns.createDate()PersistedObjectColumns.createdBy()QapiActionItem.createdByName()QapiCalculationGrid.createdByName()QapiCompanyParameterRow.createdByName()QapiCompensationRecord.createdByName()QapiPriceGrid.createdByName()QapiPriceList.createdByName()QapiRebateRecord.createdByName()QapiConditionRecord.createdByObj()QapiHistoricalConditionRecord.createdByObj()PriceCalculableObjectLineItemColumns.currency()QapiConditionRecord.currency()QapiHistoricalConditionRecord.currency()QapiProduct.currency()QapiProductCompetition.currency()QapiCompensationLineItem.customerGroup()QapiCompensationRecord.customerGroup()QapiContractLineItem.customerGroup()QapiRebateLineItem.customerGroup()QapiRebateRecord.customerGroup()QapiClaim.customerId()QapiCustomer.customerId()QapiCustomerExtensionRow.customerId()QapiClaim.customerName()QapiCalculationGridLineItem.denialDate()QapiPriceGridLineItem.denialDate()QapiCalculationGridLineItem.denialReason()QapiPriceGridLineItem.denialReason()ApprovableColumns.deniedByName()QapiActionItem.description()QapiCompensationRecord.description()QapiPriceGrid.description()QapiPriceList.description()QapiRebateRecord.description()CalculableLineItemColumns.dirty()CalculableObjectLineItemColumns.dirty()QapiActionItem.dueDate()QapiActionItem.dueDatePassedNotificationSent()CalculableLineItemColumns.editabilityStatus()QapiClaimLineItem.endCustomerId()QapiCompensationLineItem.endDate()QapiCompensationRecord.endDate()QapiContractLineItem.endDate()QapiRebateLineItem.endDate()QapiRebateRecord.endDate()QapiPriceList.expiryDate()QapiPriceList.exportDate()QapiClaim.externalRef()QapiRebateRecord.externalRef()QapiConditionRecord.extraData()QapiHistoricalConditionRecord.extraData()QapiClaim.fileName()QapiCustomForm.formStatus()QapiCompensationRecord.formulaName()QapiProduct.formulaName()QapiRebateRecord.formulaName()QapiPriceListLineItem.hasCriticalAlert()QapiJobStatusTracker.hasWarning()QapiRebateRecord.headerRebateTypeUniqueName()QapiPriceGrid.headerTypeUniqueName()PersistedObjectColumns.id()QapiProduct.image()QapiProductCompetition.infoDate()QapiProductReference.infoDate()QapiCompensationRecord.inputsJson()QapiRebateRecord.inputsJson()QapiConditionRecord.integrationStatus()QapiHistoricalConditionRecord.integrationStatus()QapiPriceGrid.integrationStatus()QapiPriceList.integrationStatus()QapiProductCompetition.integrationToken()QapiProductReference.internalReference()QapiCompensationRecord.intgStatus()QapiRebateRecord.intgStatus()QapiCompensationRecord.intgStatusDetails()QapiRebateRecord.intgStatusDetails()QapiCompensationRecord.intgStatusErpReference()QapiRebateRecord.intgStatusErpReference()QapiCalculationGridLineItem.isCompleted()QapiDataFeed.isDeleted()QapiDatamart.isDeleted()QapiDataSource.isDeleted()QapiCompensationRecord.isManual()QapiRebateRecord.isManual()OutputsColumns.OutputColumns.isOverridden()QapiCustomer.isParent()CalculableObjectLineItemColumns.itemExtensions()QapiJobStatusTracker.jobName()QapiCalculationGridLineItem.key1()QapiCompanyParameterRow.key1()QapiConditionRecord.key1()QapiHistoricalConditionRecord.key1()QapiConditionRecord.key10()QapiHistoricalConditionRecord.key10()QapiConditionRecord.key11()QapiHistoricalConditionRecord.key11()QapiConditionRecord.key12()QapiHistoricalConditionRecord.key12()QapiCalculationGridLineItem.key2()QapiCompanyParameterRow.key2()QapiConditionRecord.key2()QapiHistoricalConditionRecord.key2()QapiPriceGridLineItem.key2()QapiPriceListLineItem.key2()QapiCalculationGridLineItem.key3()QapiCompanyParameterRow.key3()QapiConditionRecord.key3()QapiHistoricalConditionRecord.key3()QapiCalculationGridLineItem.key4()QapiCompanyParameterRow.key4()QapiConditionRecord.key4()QapiHistoricalConditionRecord.key4()QapiCalculationGridLineItem.key5()QapiCompanyParameterRow.key5()QapiConditionRecord.key5()QapiHistoricalConditionRecord.key5()QapiCalculationGridLineItem.key6()QapiCompanyParameterRow.key6()QapiConditionRecord.key6()QapiHistoricalConditionRecord.key6()QapiConditionRecord.key7()QapiHistoricalConditionRecord.key7()QapiConditionRecord.key8()QapiHistoricalConditionRecord.key8()QapiConditionRecord.key9()QapiHistoricalConditionRecord.key9()QapiCalculationGrid.keySize()CalculableLineItemColumns.label()CalculableObjectColumns.label()CalculableObjectLineItemColumns.label()QapiClaim.label()QapiCompanyParameterTable.label()QapiCustomForm.label()QapiProduct.label()QapiProductCompetition.label()PersistedObjectColumns.lastUpdateBy()QapiActionItem.lastUpdateByName()QapiCalculationGrid.lastUpdateByName()QapiCompanyParameterRow.lastUpdateByName()QapiCompensationRecord.lastUpdateByName()QapiPriceGrid.lastUpdateByName()QapiPriceList.lastUpdateByName()QapiRebateRecord.lastUpdateByName()PersistedObjectColumns.lastUpdateDate()QapiDataFeed.lastUpdateDate()QapiDatamart.lastUpdateDate()QapiDataSource.lastUpdateDate()QapiConditionRecord.lastUpdatedByObj()QapiHistoricalConditionRecord.lastUpdatedByObj()QapiJobStatusTracker.lightweight()CalculableLineItemColumns.lineId()QapiCompensationRecord.lineId()QapiRebateRecord.lineId()QapiClaim.locale()QapiCompensationRecord.locked()QapiRebateRecord.locked()QapiCompanyParameterRow.lowerBound()QapiCalculationGridLineItem.manualEditUser()QapiPriceGridLineItem.manualEditUser()QapiCalculationGridLineItem.manualEditVersion()QapiPriceGridLineItem.manualEditVersion()CalculableObjectLineItemColumns.manualOverrides()QapiPriceGridLineItem.manualPriceDate()QapiPriceGridLineItem.manualPriceExpired()PriceCalculableObjectLineItemColumns.manualResultPrice()QapiCompensationRecord.name()QapiCustomer.name()QapiRebateRecord.name()QapiSeller.name()QapiCalculationGrid.nodeId()QapiPriceGrid.nodeId()QapiPriceList.nodeId()QapiCalculationGrid.numberOfApprovedItems()QapiPriceGrid.numberOfApprovedItems()QapiCalculationGrid.numberOfAutoApprovedItems()QapiPriceGrid.numberOfAutoApprovedItems()QapiCalculationGrid.numberOfDeniedItems()QapiPriceGrid.numberOfDeniedItems()CalculableObjectColumns.numberOfItems()QapiCalculationGrid.numberOfOpenItems()QapiPriceGrid.numberOfOpenItems()QapiCalculationGrid.numberOfSubmittedItems()QapiPriceGrid.numberOfSubmittedItems()QapiActionItem.originatorLabel()QapiActionItem.originatorTypedId()QapiHistoricalConditionRecord.originToken()CalculableLineItemColumns.parentId()QapiCustomer.parentId()QapiActionItem.parentLabel()QapiActionItem.parentTabName()QapiActionItem.parentTypedId()QapiCalculationGrid.partialCalculationDate()QapiPriceGrid.partialCalculationDate()QapiCompensationLineItem.payoutDate()QapiCompensationRecord.payoutDate()QapiRebateLineItem.payoutDate()QapiRebateRecord.payoutDate()QapiConditionRecord.preciseConditionValue()QapiHistoricalConditionRecord.preciseConditionValue()QapiPriceGridLineItem.previousCalculationResult(String elementName) QapiPriceGridLineItem.previousCalculationResults()PriceCalculableObjectLineItemColumns.previousPrice()QapiPriceGridLineItem.previousPriceDate()QapiPriceList.previousPricelistId()QapiProductCompetition.price()QapiProductCompetition.priceAPIRecord()PriceCalculableObjectLineItemColumns.priceChange()QapiPriceGridLineItem.priceChange_ActivePrev()PriceCalculableObjectLineItemColumns.priceChangePct()QapiPriceGridLineItem.priceChangePct_ActivePrev()QapiPriceGrid.priceGridType()QapiPriceList.pricelistPricegridTypeUniqueName()QapiPriceList.pricelistType()QapiContractLineItem.priceRecordId()QapiQuoteLineItem.priceRecordId()QapiProductCompetition.priceType()QapiConditionRecord.priceUnit()QapiHistoricalConditionRecord.priceUnit()QapiProductCompetition.priceUnit()QapiProductCompetition.priority()QapiJobStatusTracker.processingEnd()QapiJobStatusTracker.processingNode()QapiJobStatusTracker.processingStart()QapiCompensationLineItem.productGroup()QapiCompensationRecord.productGroup()QapiContractLineItem.productGroup()QapiRebateLineItem.productGroup()QapiRebateRecord.productGroup()QapiClaim.progress()QapiJobStatusTracker.progress()QapiClaimLineItem.quantity()QapiProductBillOfMaterial.quantity()QapiClaimLineItem.quoteUniqueName()QapiCompensationRecord.rank()QapiRebateRecord.rank()QapiProductBillOfMaterial.rawMaterial()QapiRebateRecord.rebateRecordGroupUniqueName()QapiRebateRecord.rebateRecordSetLabel()QapiRebateLineItem.rebateTypeLabel()QapiRebateRecord.rebateTypeUN()QapiRebateLineItem.rebateTypeUniqueName()QapiProductReference.referenceType()QapiCalculationGrid.relativeTargetDateDays()QapiPriceGrid.relativeTargetDateDays()QapiSeller.reportsTo()OutputsColumns.OutputColumns.result()PriceCalculableObjectLineItemColumns.resultPrice()QapiCustomForm.rootUniqueName()QapiCompensationRecord.seller()QapiRebateRecord.seller()QapiSeller.sellerId()QapiSellerExtensionRow.sellerId()QapiCompensationLineItem.simulationType()QapiRebateLineItem.simulationType()PriceCalculableObjectLineItemColumns.sku()QapiClaimLineItem.sku()QapiProduct.sku()QapiProductBillOfMaterial.sku()QapiProductCompetition.sku()QapiProductExtensionRow.sku()QapiProductReference.sku()QapiQuoteLineItem.sku()QapiProductCompetition.source()QapiClaim.sourceContractUniqueName()QapiCompensationRecord.sourceId()QapiRebateRecord.sourceId()QapiCompensationRecord.sourceIdNoRev()QapiRebateRecord.sourceIdNoRev()QapiClaim.sourceQuoteUniqueName()QapiCompensationLineItem.startDate()QapiCompensationRecord.startDate()QapiContractLineItem.startDate()QapiRebateLineItem.startDate()QapiRebateRecord.startDate()CalculableObjectColumns.status()QapiActionItem.status()QapiClaim.status()QapiCompensationRecord.status()QapiHistoricalConditionRecord.status()QapiJobStatusTracker.status()QapiRebateRecord.status()QapiProductBillOfMaterial.subComponentSku()QapiCalculationGridLineItem.submitDate()QapiClaim.submitDate()QapiCustomForm.submitDate()QapiPriceGridLineItem.submitDate()QapiPriceList.submitDate()ApprovableColumns.submittedByName()QapiActionItem.summary()CalculableObjectLineItemColumns.tainted()CalculableObjectColumns.targetDate()QapiClaim.targetDate()QapiJobStatusTracker.targetObject()QapiProductReference.targetSku()QapiJobStatusTracker.threadUUID()QapiClaimLineItem.totalAmount()QapiJobStatusTracker.trackerType()QapiProductBillOfMaterial.type()QapiActionItem.uniqueName()QapiClaim.uniqueName()QapiCompanyParameterTable.uniqueName()QapiCompensationRecord.uniqueName()QapiCustomForm.uniqueName()QapiRebateRecord.uniqueName()PriceCalculableObjectLineItemColumns.unitOfMeasure()QapiConditionRecord.unitOfMeasure()QapiHistoricalConditionRecord.unitOfMeasure()QapiProduct.unitOfMeasure()QapiProductCompetition.unitOfMeasure()QapiCompanyParameterRow.upperBound()OutputsColumns.OutputColumns.userGroup()QapiCalculationGrid.userGroupEdit()QapiCompanyParameterTable.userGroupEdit()QapiCompensationRecord.userGroupEdit()QapiCustomer.userGroupEdit()QapiCustomForm.userGroupEdit()QapiPriceGrid.userGroupEdit()QapiPriceList.userGroupEdit()QapiProduct.userGroupEdit()QapiRebateRecord.userGroupEdit()QapiSeller.userGroupEdit()QapiCalculationGrid.userGroupViewDetails()QapiCompanyParameterTable.userGroupViewDetails()QapiCompensationRecord.userGroupViewDetails()QapiCustomer.userGroupViewDetails()QapiCustomForm.userGroupViewDetails()QapiPriceGrid.userGroupViewDetails()QapiPriceList.userGroupViewDetails()QapiProduct.userGroupViewDetails()QapiRebateRecord.userGroupViewDetails()QapiSeller.userGroupViewDetails()QapiClaimLineItem.validationState()QapiConditionRecord.validFrom()QapiHistoricalConditionRecord.validFrom()QapiConditionRecord.validTo()QapiHistoricalConditionRecord.validTo()InputsColumns.InputColumns.value()QapiCompanyParameterRow.value()PersistedObjectColumns.version()CalculableObjectLineItemColumns.warnings()ApprovableColumns.workflowStatus()CalculableObjectLineItemColumns.workStatus()