• 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.

  • 相关阅读:
    STM32 端口复用配置
    stm32 新建文件记得添加到工程
    keil解决SYSTEMsysstm32f10x.h(298): error: #67: expected a "}"
    解决Keil复制中文乱码
    STM32 MPU6050 源码
    STM32 PWM输出
    STM32定时器
    STM32 看门狗操作姿势
    开课博客
    第二周学习进度
  • 原文地址:https://www.cnblogs.com/xiangliqi/p/4651469.html
Copyright © 2020-2023  润新知