Query range functions are a feature of F&O which enables specifying a criteria without knowing the exact value or having to do the calculation yourself.  This could be used to filter a form, or when specifying ‘records to include’ on a scheduled batch (very handy).
Examples:
  • (currentDate())
  • (anyUserIdNotCurrent())
  • (day(-2))
  • (greaterThanDate(-2))
In 2012 you would overlayer the SysQueryRangeUtil class to add new functions, however in F&O you can create a new class and decorate a public static method with QueryRangeFunctionAttribute to make it available.  However this causes a challenge when someone asked me what other functions are available, or is there a function for me to get X or Y.

Finding More Functions

I wrote a PowerShell script which will print all of the available methods with the QueryRangeFunctionAttribute.  Download it on GitHub.

You get a bunch of results.  Pictured here is the first page.

For a quick tutorial on how to make your own, check out Joris’s post.

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()

This post was written against Dynamics 365 for Finance, Supply Chain Management (Operations) version 10.0.9.