«

»

List of Formula Not Supported in XPages

Categories:

March 25, 2010

by

As you may know, @Formula are available
for use with Server Side Javascript in XPages.  There are 274 @functions
listed in the help file, 97 of those are listed as available for use in
XPages.  Here is a list of the @Formula not available in XPages,
in case you might find it useful.

@AbstractSimple

@DocSiblings

@LanguagePreference

@Sign

@Accessed

@DocumentUniqueID

@LaunchApp

@Sin

@ACos

@Domain

@LDAPServer

@Sort

@AddToFolder

@DoWhile

@Like

@Soundex

@AdminECLIsLocked

@EditECL

@Ln

@Sqrt

@All

@EditUserECL

@Locale

@StatusBar

@AllChildren

@EnableAlarms

@Log

@Tan

@AllDescendants

@Environment

@MailDbName

@TemplateVersion

@Ascii

@Eval

@MailEncryptSavedPreference

@ThisName

@ASin

@Exp

@MailEncryptSentPreference

@ThisValue

@ATan

@FileDir

@MailSavePreference

@TimeMerge

@ATan2

@FloatEq

@MailSend

@TimeToTextInZone

@BrowserInfo

@FontList

@MailSignPreference

@TimeZoneToText

@BusinessDays

@For

@Matches

@ToNumber

@Certificate

@FormLanguage

@NameLookup

@ToTime

@CheckAlarms

@GetAddressBooks

@Narrow

@Transform

@CheckFormulaSyntax

@GetCurrentTimeZone

@NoteID

@Unavailable

@Command

@GetDocField

@Nothing

@UndeleteDocument

@Compare

@GetFocusTable

@OpenInNewWindow

@UpdateFormulaContext

@ConfigFile

@GetHTTPHeader

@OptimizeMailAddress

@URLDecode

@Cos

@GetIMContactListGroupNames

@OrgDir

@URLEncode

@DB2Schema

@GetPortsList

@Password

@URLGetHeader

@DbCommand(Domino)

@GetProfileField

@PasswordQuality

@URLHistory

@DbCommand(ODBC)

@GetViewInfo

@Pi

@URLOpen

@DbExists

@HardDeleteDocument

@PickList

@UrlQueryString

@DbManager

@HashPassword

@Platform

@UserAccess

@DDEExecute

@InheritedDocumentUniqueID

@PolicyIsFieldLocked

@UserNameLanguage

@DDEInitiate

@IsAgentEnabled

@PostedCommand

@UserNamesList

@DDEPoke

@IsAppInstalled

@Power

@UserPrivileges

@DDETerminate

@IsCategory

@Prompt

@UserRoles

@DeleteDocument

@IsDB2

@RefreshECL

@V2If

@DeleteField

@IsDocBeingEdited

@RegQueryValue

@V3UserName

@DialogBox

@IsDocBeingMailed

@Responses

@V4UserAccess

@DocChildren

@IsDocBeingRecalculated

@ServerAccess

@ValidateInternetAddress

@DocDescendants

@IsDocTruncated

@ServerName

@VerifyPassword

@DocFields

@IsEmbeddedInsideWCT

@Set

@Version

@DocLength

@IsExpandable

@SetDocField

@ViewShowThisUnread

@DocLevel

@IsInCompositeApp

@SetEnvironment

@ViewTitle

@DocLock

@IsModalHelp

@SetHTTPHeader

@WebDbName

@DocMark

@IsUsingJavaElement

@SetProfileField

@WhichFolders

@DocNumber

@IsValid

@SetTargetFrame

@While

@DocOmmittedLength

@IsVirtualizedDirectory

@SetViewInfo

@Wide

@DocParentNumber

@Keywords

@ShowParentPreview

@Zone

Tags: ,

  • http://www.timtripcony.com Tim Tripcony

    So… how long until you’ve implemented all of these in SSJS? Emoticon

  • http://notesin9.com David Leedy

    Great post Kathy!!!

    Some of these MIGHT be able to be used inside a session.evaluate() call. That what I use to get the tradational @Unique.

    Also there might be native JavaScript replacements for some of these functions as well.

  • Roy Rumaner

    Great post Kathy.

  • http://www.recondite2.com John Turnbow

    Great post Kathy… Now I have a list of what is there and what is not.

  • http://jonvon.net John Vaughan

    aw man, u mean i can’t get in the @zone in xpages?

    great post, very helpful. Emoticon

  • http://www.runningnotes.net Kathy Brown

    @Jonvon – Right no @Zone. Sorry man. But what is weird is @Contains == yes. @Matches == no. Other @functions that work on lists, but not @Transform. Anyway, that’s why I made the list, since it didn’t seem to follow set logic about what would work and what wouldn’t.

  • http://quintessens.wordpress.com Patrick Kwinten

    any known server side @sort function equivalent known?Emoticon