呆子獅的夢想世界

Example 1:

1 個value: 

  [QueryRangeFunctionAttribute()]
    public static str includedInventLocationIds()
    {
        return InventParameters::find().DGS_MainInventLocationId;

    }

Data Entity Add Range in DataEntityViewRange 而唔係係 datasource 度addrange!!

Example 2:

/// <summary>

/// Returns a string which can be used as range for <c>InventTrans</c> statusIssue statuses to select reserved transactions.

/// </summary>

[QueryRangeFunctionAttribute()]

public static str reservedStatusIssue()

{

// 2 個 values ("OR")

return queryRangeConcat(queryValue(StatusIssue::ReservOrdered), StatusIssue::ReservPhysical);

}

Example 3 :

/// <summary>
/// Retrieves a list of field IDs that are valid inventory dimensions parameters.
/// </summary>
/// <returns>String representing a list of field IDs.</returns>
[QueryRangeFunctionAttribute()]
public static str includedFieldIds()
{
    Set             validFieldIds   = InventInventoryDimensionsParametersEntityHelper::getValidInventoryDimensionsParametersFieldIds();
    SetEnumerator   enumerator      = validFieldIds.getEnumerator();
    str             value;

    while (enumerator.moveNext())
    {
        // queryRangeConcat 是加入 OR QUERY FILTER
        value = queryRangeConcat(value, enumerator.current());
    }

    return value;
}

====================================================

Exhaustive List

str SysQueryRangeUtilDMF.greaterThanLastActivityStartedDateTime()
str SysQueryRangeUtilDMF.greaterThanLastActivityCompletedDateTime()
str SysQueryRangeUtilDMF.greaterThanLastSuccessfulExecutionDateTime()
str SysQueryRangeUtilDMF.greaterThanLastExecutionDateTime()
str SysQueryRangeUtilDMF.notExportableUser()
RecId UserExternalQueryRangeFunction.currentUserExternalParty()
date SysQueryRangeUtil.currentDate()
str SysQueryRangeUtil.currentLanguageId()
str SysQueryRangeUtil.currentSessionDate()
str SysQueryRangeUtil.currentSessionDateTime()
str SysQueryRangeUtil.currentUserId()
str SysQueryRangeUtil.anyUserIdNotCurrent()
str SysQueryRangeUtil.currentUserLanguage()
str SysQueryRangeUtil.dateRange(date _startDate, date _endDate)
str SysQueryRangeUtil.day(int relativeDays = 0)
str SysQueryRangeUtil.dayRange(int relativeDaysFrom = 0, int relativeDaysTo = 0)
str SysQueryRangeUtil.greaterThanDate(int relativeDays = 0)
str SysQueryRangeUtil.greaterThanUtcDate(int relativeDays = 0)
str SysQueryRangeUtil.greaterThanUtcNow()
str SysQueryRangeUtil.lessThanDate(int relativeDays = 0)
str SysQueryRangeUtil.lessThanUtcDate(int relativeDays = 0)
str SysQueryRangeUtil.lessThanUtcNow()
str SysQueryRangeUtil.monthRange(int relativeMonthsFrom = 0, int relativeMonthsTo = 0)
str SysQueryRangeUtil.yearRange(int relativeYearsFrom = 0, int relativeYearsTo = 0)
str SysQueryRangeUtil.value(anytype a)
str SysQueryRangeUtil.valueEmptyString()
str SysQueryRangeUtil.valueUnlimited()
SelectableDataArea SysQueryRangeUtil.currentCompany()
utcdatetime SysQueryRangeUtil.getCurrentSessionDateTime()
str SysQueryRangeUtil.literalFilterValue(str nonLiteralFilterValue)
utcdatetime SysQueryRangeUtil.dateTimeMinValue()
str AgreementClassificationEntityHelper.salesAgreementClassificationRangeConfiguration()
str AgreementClassificationEntityHelper.purchAgreementClassificationRangeConfiguration()
str AgreementClassificationEntityHelper.agreementClassificationRangeConfiguration()
str AgreementConfirmationLineEntityHelper.assignLinesToHeadersByDateEffectiveness_SalesAgreementConfirmation()
str AgreementConfirmationLineEntityHelper.assignLinesToHeadersByDateEffectiveness_PurchaseAgreementConfirmation()
RefRecId CompanyInfoHelper.currentLegalEntity()
str CustCustomerExternalCodeClassEntityHelper.queryRangeExpressionCustTableTableId()
str EcoResDimensionGroupEntityHelper.productDimensionRangeConfiguration()
str EcoResDimensionGroupEntityHelper.productDimensionRangeSize()
str EcoResDimensionGroupEntityHelper.productDimensionRangeColor()
str EcoResDimensionGroupEntityHelper.productDimensionRangeStyle()
str EcoResDimensionGroupEntityHelper.productDimensionRangeSite()
str EcoResDimensionGroupEntityHelper.productDimensionRangeWarehouse()
str EcoResDimensionGroupEntityHelper.productDimensionRangeLocation()
str EcoResDimensionGroupEntityHelper.productDimensionRangeStatus()
str EcoResDimensionGroupEntityHelper.productDimensionRangeLicensePlate()
str EcoResDimensionGroupEntityHelper.productDimensionRangeBatch()
str EcoResDimensionGroupEntityHelper.productDimensionRangeSerial()
str EcoResDimensionGroupEntityHelper.productDimensionRangeInventoryOwner()
str EcoResDimensionGroupEntityHelper_RU.productDimensionRangeInventoryProfile()
str EcoResDimensionGroupEntityHelper_RU.productDimensionRangeGTD()
str EcoResProductEntityHelper.queryRangeExpressionNotVariant()
str EcoResProductMasterDimensionEntityHelper.productDimensionColorTableId()
str EcoResProductMasterDimensionEntityHelper.productDimensionConfigurationTableId()
str EcoResProductMasterDimensionEntityHelper.productDimensionSizeTableId()
str EcoResProductMasterDimensionEntityHelper.productDimensionStyleTableId()
str EcoResReleasedProductExternalCodeClassEntityHelper.queryRangeExpressionInventTableTableId()
str EcoResReleasedProductVariantExternalCodeClassEntityHelper.queryRangeExpressionInventDimCombinationTableId()
str FormLetterSortingParametersEntityHelper.procurementTableRangeValues()
str FormLetterSortingParametersEntityHelper.salesTableRangeValues()
str IntrastatEntityHelper.intrastatCommodityCodeEntityRangeDataAreaId()
str InventInventoryDimensionsParametersEntityHelper.tableNumInventDim()
str InventInventoryDimensionsParametersEntityHelper.includedFieldIds()
str InventLedgerPostingDefinitionEntityHelper.inventAccountTypeInventFilter()
str InventLedgerPostingDefinitionEntityHelper.inventAccountTypeProdFilter()
str InventLedgerPostingDefinitionEntityHelper.inventAccountTypePurchFilter()
str InventLedgerPostingDefinitionEntityHelper.inventAccountTypeSalesFilter()
str InventLedgerPostingDefinitionEntityHelper.inventAccountTypeStdCostVarianceFilter()
FieldId InventSysQueryRangeUtil.inventBatchIdFieldNum()
FieldId InventSysQueryRangeUtil.wMSLocationIdFieldNum()
str PmfSysQueryRun.pmfInventTableIsBOMFormula()
str ProdStatusSysQueryRangeUtil.prodStatusBetweenScheduledAndStartedUp()
str ProdStatusSysQueryRangeUtil.prodStatusBetweenScheduledAndReportedFinished()
str ProdStatusSysQueryRangeUtil.prodStatusBetweenCostEstimatedAndStartedUp()
str ProdStatusSysQueryRangeUtil.prodStatusBetweenStartedUpAndReportedFinished()
str ProdStatusSysQueryRangeUtil.prodStatusBetweenCostEstimatedAndReportedFinished()
str ProdStatusSysQueryRangeUtil.prodStatusBetweenCreatedAndStartedUp()
str ProdStatusSysQueryRangeUtil.prodStatusBetweenCreatedAndReportedFinished()
str PurchaseRequisitionEntityHelper.getPurchaseRequsitionHeaders()
str PurchPurchaseOrderUpdateLinesParametersEntityHelper.tableNumPurchTable()
str PurchPurchaseOrderUpdateLinesParametersEntityHelper.includedFieldIds()
str PurchPurchasingPolicyEntityHelper.purchasingPolicyType()
str PurchPurchasingPolicyEntityHelper.purchReqLineFilterQueryRangeValue()
str PurchPurchasingPolicyEntityHelper.purchaseRequisitionProcurementCatalogPolicyRuleQueryRangeValue()
str PurchPurchasingPolicyEntityHelper.purchaseRequisitionConsumptionCategoryAccessPolicyRuleQueryRangeValue()
str PurchPurchasingPolicyEntityHelper.purchaseCategoryPolicyRuleQueryRangeValue()
str PurchPurchasingPolicyEntityHelper.purchaseRequistionControlRFQPolicyRuleQueryRangeValue()
str PurchPurchasingPolicyEntityHelper.purchaseRequistionConsumptionControlPolicyRuleQueryRangeValue()
str PurchPurchasingPolicyEntityHelper.purchaseRequistionPurposePolicyRuleQueryRangeValue()
str PurchPurchasingPolicyEntityHelper.purchaseRequistionReplenishmentCategoryAccessPolicyRuleQueryRangeValue()
str PurchPurchasingPolicyEntityHelper.purchaseRequistionReplenishmentControlPolicyRuleQueryRangeValue()
str PurchPurchasingPolicyEntityHelper.purchaseOrderCreationAndDemandConsolidationPolicyRuleQueryRangeValue()
str PurchPurchasingPolicyEntityHelper.purchReapprovalPolicyRuleQueryRangeValue()
str ReqDemPlanHistoricalExternalDemandEntityHelper.queryRangeVersionForecastedExternally()
str ReqDemPlanHistoricalExternalDemandEntityHelper.queryRangeDataSourceOriginForecastedExternally()
str ReqRoutePlannedOrderRouteOperationEntityHelper.wrkCtrDateFromEffectiveness()
str ReqRoutePlannedOrderRouteOperationEntityHelper.wrkCtrDateToEffectiveness()
str RetailPeriodicDiscountQueriesHelper.getDiscountOfferTypes()
str RetailPeriodicDiscountQueriesHelper.getPriceOfferTypes()
str SalesOrderUpdateLinesParametersEntityHelper.tableNumSalesTable()
str SalesOrderUpdateLinesParametersEntityHelper.includedFieldIds()
str SalesQueryRangeUtil.salesStatusCanBeInvoiced()
str SalesQueryRangeUtil.salesTypeCustomerDemand()
str SysQueryRangeUtilProject.projActiveAll(ProjActiveAll _projActiveAll)
str SysQueryRangeUtilProject.projLevels(ProjLevels _projLevels)
str SysQueryRangeUtil_Extension.validToMaxValueRange()
str SysQueryRangeUtil_Extension.validToMaxValueRangeDate()
str TMSTransportationRouteScheduleEntityHelper.getRoutePlan()
str TrvExpenseTransHelper.currentLegalEntity()
str TSQueryRangeUtil.validTimesheetFrequency()
TableId TSTimesheetHelper.getTSTimesheetTableId()
str VendVendorExternalCodeClassEntityHelper.queryRangeExpressionVendTableTableId()
str WHSCustomerGroupProductFilterEntityHelper.getCustomerGroups()
str WHSCustomerProductFilterEntityHelper.getCustomers()
str WHSGenerallyAvailableProductFilterEntityHelper.getGenerallyAvailableProducts()
str WHSProductFilterGroupDetailEntityHelper.getProductFilterGroupsQueryRange()
str WHSQueryHelper_BR.getRefTableIdsFromWhsFiscalDocument()
str WHSReleaseLoadToWarehouseSysQueryRangeUtil.loadStatus()
str WHSSysQueryRangeUtil.workStatusOpenOrInProcess()
str WHSSysQueryRangeUtil.no()
str WHSVendorGroupProductFilterEntityHelper.getVendorGroups()
str WHSVendorProductFilterEntityHelper.getVendors()
str WMSQueryRangeUtil.shipmentsInProgress()
TableId FinancialReportingGeneralJournalReversals.tableName2Id(str _tableName)
str AssetWorkspaceQueryHelper.currentFiscalYearRange()
str BudgetPlanningWorkspaceQueryRangeHelper.budgetPlanningProcess()
str BudgetPlanningWorkspaceQueryRangeHelper.currentDate()
str BudgetPlanningWorkspaceQueryRangeHelper.emptyValue()
str BudgetTrackingWorkspaceQueryRangeHelper.overThreshold()
str BudgetTrackingWorkspaceQueryRangeHelper.underThreshold()
str BudgetTrackingWorkspaceQueryRangeHelper.budgetPlanningProcess()
str BudgetTrackingWorkspaceQueryRangeHelper.currentLedger()
str DirRelationshipTypeHelper.getUserDefinedRelationshipTypeRange(DataSourceName _dataSourceName = ”, FieldName _systemTypeFieldName = fieldStr(DirRelationshipTypeTable, SystemType)
boolean DirUtility.currentRoleHasAccessToPrivate(boolean _useCache = true)
DirPartyRecId DirUtility.currentParty()
boolean DirPartyLocation.currentRoleHasAccessToPrivate(boolean _useCache = true)
DirPartyRecId DirPartyTable.currentParty()
str DOMConfigurationManager.notUtcNull()
str DOMConfigurationManager.domBatchTimeGreaterThanBatchTime()
str DOMConfigurationManager.getDOMClassId()
str DOMQueryHelper.getQueryNotValueForExcludedModesOfDelivery()
str EntAssetSysQueryRangeUtil.greaterThanUtcDateCompanyTimezone(int relativeDays = 0)
RecId HcmWorkerLookup.currentPerson()
HcmWorkerRecId HcmWorkerLookup.currentWorker()
boolean EssPersonIdentificationNumberRangeUtil.skipSelfServiceReadPolicy()
boolean EssPersonIdentificationNumberRangeUtil.skipSelfServiceInsertUpdateDeletePolicy()
RefRecId HcmCompanyInfoHelper.currentLegalEntity()
boolean HcmPersonIdentificationNumberRangeUtil.skipSelfServiceReadPolicy()
boolean HcmPersonIdentificationNumberRangeUtil.skipSelfServiceInsertUpdateDeletePolicy()
str HcmQueryRangeUtil.getAotNameHcmHumanResourceManager()
str HcmQueryRangeUtil.getAotNameHcmManager()
HcmPositionHierarchyTypeRecId HcmQueryRangeUtil.findPositionHierarchyLineType()
str HcmQueryRangeUtil.lessThanCompanyDate(int _relativeDays = 0)
str HcmQueryRangeUtil.greaterThanCompanyDate(int _relativeDays = 0)
str HcmQueryRangeUtil.dateTimeRangeTodayToEndOfYearInCompanyTimezone()
str HcmQueryRangeUtil.currentWorkerPositionRange()
str HcmQueryRangeUtil.greaterThanOrEqualToUtcNow()
str HcmQueryRangeUtil.lessThanOrEqualToUtcNow()
boolean HcmWorkerActionHireRangeUtil.skipSelfServiceReadPolicy()
boolean HcmWorkerActionHireRangeUtil.skipSelfServiceInsertUpdateDeletePolicy()
boolean HcmWorkerBankAccountRangeUtil.skipSelfServiceReadPolicy()
boolean HcmWorkerBankAccountRangeUtil.skipSelfServiceInsertUpdateDeletePolicy()
str MssExitingWorkerQueryRangeUtil.dateTimeRangeExiting()
str MssExitingWorkerQueryRangeUtil.numberOfHierarchyResultLevelRange()
str HcmBenefitEligibilityPolicyEntity.hcmBenefitEligibilityPolicyType()
str SysPolicyEntityHelper.sysPolicyRuleTypeTableId()