The following functions can be used in any query. Note that the functions are case sensitive and need to be put in brackets.
currentUserId()
currentEmployeeId()
currentBusinessRelationsAccount()
currentContactPersonId()
currentCustomerAccount()
currentVendorAccount()
--------------------------------------------------------------------------------------------------------------------
Date (x and y in the below functions denote integer value for the parameter)
day(int relativeDays = x)
dayRange(int relativeDaysFrom = x, int relativeDaysTo = y)
greaterThanDate(int relativeDays = x)
lessThanDate(int relativeDays = x)
monthRange(int relativeMonthsFrom = x, int relativeMonthsTo = x)
yearRange(int relativeYearsFrom = x, int relativeYearsTo = y)
Range of date
dateRange(date startDate, date endDate)
currentSessionDate()
currentSessionDateTime()
------------------------------------------------------------------------------------------------------------------
The below given functions are specific to Axapta 2012
advancedLedgerEntryCurrentUserFilter(boolean _createdBy)
advancedLedgerEntryTxtOpenDraftAll(anytype _advancedLedgerEntryTransactionStatus)
currentRoleHasAccessToPrivate(boolean _useCache = true)
currentStaticMasterPlanVersion()
lessThanUtcDate(int relativeDays = 0)
lessThanUtcNow()
greaterThanUtcDate(int relativeDays = 0)
greaterThanUtcNow()
documentStatusPurchOrderOrGreater()
getActiveMasterPlanVersionByPlanId(ReqPlanId _planId)
isDirAddressPolicyOff()
isPrivate()
sessionGuid()
currentDate()
currentLanguageId()
currentUserLanguage()
currentWorker()
currentWorkerRecId()
currentLegalEntity()
currentParty()
Comments