AX2012 Use functions in queries and filters

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

Advertisements

AX2012 Client access log

There is option to keep track of user activities in AX2012. AX2012 will flush all details about the forms that are opened or closed to the table SysClientAccessLog.

Details that can be found in this table:  what part of the form users are in, what events are triggered in the form, at what time, computer name, duration in milliseconds.

You can find the full post on the blog of the AX performance team.