Functions to use in Queries, Filters (2021)

Written by

Update to my old Blog post Functions to use in Queries, Filters

There are many new functions that can be used in Queries. In the code they are marked with [QueryRangeFunction()] or [QueryRangeFunctionAttribute()]

see https://calafell.me/the-utility-of-query-range-functions-dynamics-365-for-finance-operations-supply-chain-management/ for a comprehensive list and a script to compile a new list your current list.

Use by providing the full class and method e.g. UserExternalQueryRangeFunction::currentUserExternalParty()

Current list as of 10.0.22

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::productDimensionRangeVersion()
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 EcoResProductDimensionQueryRangeHelper::productDimensionRangeColor(DataSourceName _dataSource1Name, DataSourceName _d
ataSource2Name, boolean _allowEmptyDimension = true)
str EcoResProductDimensionQueryRangeHelper::productDimensionRangeSize(DataSourceName _dataSource1Name, DataSourceName _da
taSource2Name, boolean _allowEmptyDimension = true)
str EcoResProductDimensionQueryRangeHelper::productDimensionRangeStyle(DataSourceName _dataSource1Name, DataSourceName _d
ataSource2Name, boolean _allowEmptyDimension = true)
str EcoResProductDimensionQueryRangeHelper::productDimensionRangeConfiguration(DataSourceName _dataSource1Name, DataSourc
eName _dataSource2Name, boolean _allowEmptyDimension = true)
str EcoResProductDimensionQueryRangeHelper::productDimensionRangeVersion(DataSourceName _dataSource1Name, DataSourceName
_dataSource2Name, boolean _allowEmptyDimension = true)
str EcoResProductEntityHelper::queryRangeExpressionNotVariant()
str EcoResProductMasterDimensionEntityHelper::productDimensionColorTableId()
str EcoResProductMasterDimensionEntityHelper::productDimensionConfigurationTableId()
str EcoResProductMasterDimensionEntityHelper::productDimensionSizeTableId()
str EcoResProductMasterDimensionEntityHelper::productDimensionStyleTableId()
str EcoResProductMasterDimensionEntityHelper::productDimensionVersionTableId()
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 RetailProductWarehouseInventoryQueryHelper::getReservationHierarchyFieldIds()
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 TaxCodeExternalCodeClassEntityHelper::queryRangeExpressionTaxTableTableId()
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 _system
TypeFieldName = fieldStr(DirRelationshipTypeTable, SystemType)
boolean DirUtility::currentRoleHasAccessToPrivate(boolean _useCache = true)
DirPartyRecId DirUtility::currentParty()
boolean DirPartyLocation::currentRoleHasAccessToPrivate(boolean _useCache = true)
DirPartyRecId DirPartyTable::currentParty()
str DocQueryRangeUtil::isRunningInBatch()
str DocQueryRangeUtil::isNotRunningInBatch()
str DOMConfigurationManager::notUtcNull()
str DOMConfigurationManager::domBatchTimeGreaterThanBatchTime()
str DOMConfigurationManager::getDOMClassId()
str DOMQueryHelper::getQueryNotValueForExcludedModesOfDelivery()
str EngChgTools::productDimensionRangeVersion()
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()

$rootDirectory = "C:\AOSService\PackagesLocalDirectory"

cd $rootDirectory
ls "*.xml" -Recurse | % {
    $matches = (gc $_.FullName -ReadCount 0 | Select-String '\[QueryRangeFunction(?:Attribute)?\(?\)?\]\s+?public static ([^\r\n ]+) ([^\r\n)]+)' -AllMatches).Matches

    if ($matches.Count -ne 0)
    {
        $file = $_.Name.Substring(0, $_.Name.Length -4)
        #$fullName = $_.FullName

        foreach ($m in $matches) {
            Write-Host "$($m.Groups[1]) " -NoNewline
            Write-Host "$($file)." -NoNewline -ForegroundColor Gray
            Write-Host "$($m.Groups[2]))"
        }
    }
}

Functions to use in Queries, Filters (2021)

Comments