Function to use in Queries, Filters

Current user (or roles thereof)

  • currentUserId()
  • currentEmployeeId()
  • currentBusinessRelationsAccount()
  • currentContactPersonId()
  • currentCustomerAccount()
  • currentVendorAccount()

Dates (all but dateRange are relate to the current date and time)

    • currentSessionDate()
    • currentSessionDateTime()
    • day(int relativeDays = 0)
    • dayRange(int relativeDaysFrom = 0, int relativeDaysTo = 0)
    • greaterThanDate(int relativeDays = 0)
    • lessThanDate(int relativeDays = 0)
    • monthRange(int relativeMonthsFrom = 0, int relativeMonthsTo = 0)
    • yearRange(int relativeYearsFrom = 0, int relativeYearsTo = 0)
  • dateRange(date startDate, date endDate)

Constants

  • currentStaticMasterPlan()

AX2012 only

    • currentDate()
    • currentLanguageId()
    • currentUserLanguage();
    • currentWorker()
    • currentWorkerRecId()
    • currentLegalEntity()
    • currentParty()
    • advancedLedgerEntryCurrentUserFilter(boolean _createdBy)
    • advancedLedgerEntryTxtOpenDraftAll(anytype _advancedLedgerEntryTransactionStatus)
    • currentRoleHasAccessToPrivate(boolean _useCache = true)
    • currentStaticMasterPlanVersion()
    • dateRange(date startDate, date endDate)
    • lessThanUtcDate(int relativeDays = 0)
    • lessThanUtcNow()
    • greaterThanUtcDate(int relativeDays = 0)
    • greaterThanUtcNow()
  • documentStatusPurchOrderOrGreater()
  • getActiveMasterPlanVersionByPlanId(ReqPlanId _planId)
  • isDirAddressPolicyOff()
  • isPrivate()
  • pmfInventTableIsBOM()
  • pmfInventTableIsBOMFormula()
  • projActiveAll(ProjActiveAll _projActiveAll)
  • projActiveAllWIPEliminated(anytype _ProjTableActiveAll)
  • projLevels(ProjLevels _projLevels)
  • projPostedTransType(ProjPostTransViewType _projPostedTransViewType)
  • projUnpostedTransType(ProjUnpostedTransViewType _projUnpostedTransViewType)
  • salesQuotationTemplateGroupFilter(SalesQuotationFilter _salesQuotationFilter)
  • salesQuotationTypeListPageFilter(SalesQuotationTypeListPage _salesQuotationTypeListPage)
  • sessionGuid()
  • workflowDelegationFilter(WorkflowDelegationView _filter)

As you see AX 2012 has many more predefined special ranges, many of which are not very self explanatory. These are used in the filters of the pre-filtered list pages.

原文地址:https://www.cnblogs.com/xiangliqi/p/4651469.html