Tag Archives: advanced query

AX2012 Use functions in queries and filters

Posted on by

These functions can be used in any query or filter. The functions need to put in brackets.

  • currentUserId()
  • currentEmployeeId()
  • currentBusinessRelationsAccount()
  • currentContactPersonId()
  • currentCustomerAccount()
  • currentVendorAccount()
  • 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)
  • currentStaticMasterPlan()
  • 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)

15