thwidmer: Functions to use in Queries, Filters (2021

[Blog bot]

Источник: https://thwidmer.wordpress.com/2021/...-filters-2021/
==============

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-q...in-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 $rootDirectoryls "*.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]))" } }}

Источник: https://thwidmer.wordpress.com/2021/...-filters-2021/