@Formulas not used in xPages


Formulas not used in xPages -

Many of us know that xPages supports formulas language for rapid application development and that is good.
But some formulas are not yet ready to use on xPages , So I have categorized below formula list which is categorized on the basic of their use.

One interesting facts on below formulas, if you want to use below formulas in xPages then you can.
How? Yes its one Lotus Script WebQuerySave event. You can use lotus script WebQuerySave lotus Script on xPages and use these formulas using Evaluate Statements.

For example – if you want to calculate business day so use @business days in Query Save event (if your are logic is on save calculation)
@BusinessDays using evaluate statement in WebQuerySave agent. But use is very limited as we can use this on only webQuerySave. i.e. on server side.

Categories : 

View, Field, Document & Workspace Formulas

@DocChildren
@DocDescendants
@DeleteDocument
@DocFields
@DeleteField
@DocLength
@DocLevel
@DocLock
@DocMark
@DocNumber
@DocOmmittedLength
@DocParentNumber
@DocSiblings
@AllChildren
@AllDescendants
@DialogBox
@PickList
@DocumentUniqueID
@GetFocusTable
@GetHTTPHeader
@InheritedDocumentUniqueID
@HardDeleteDocument
@Responses
@Prompt
@GetViewInfo
@PostedCommand
@RefreshECL
@Power
@ViewShowThisUnread
@ViewTitle
@AddToFolder
@UndeleteDocument
@UpdateFormulaContext
@WhichFolders
@AdminECLIsLocked
@EditECL
@EditUserECL
@EnableAlarms
@Set
@SetViewInfo
@StatusBar
@Doc Fields
@GetDocField
@GetProfileField
@SetProfileField
@SetDocField

@isFormulas

@IsAgentEnabled
@IsAppInstalled
@IsCategory
@IsDB2
@IsDocBeingEdited
@IsDocBeingMailed
@IsDocBeingRecalculated
@IsDocTruncated
@IsEmbeddedInsideWCT
@IsExpandable
@IsInCompositeApp
@IsModalHelp
@IsUsingJavaElement
@IsValid
@IsVirtualizedDirectory

Date & Time:

@Locale
@Zone
@GetCurrentTimeZone
@TimeMerge
@BusinessDays

DB & Server Formulas  

@Log
@MailDbName
@MailEncryptSavedPreference
@MailEncryptSentPreference
@MailSavePreference
@MailSend
@MailSignPreference
@Matches
@NameLookup
@Narrow
@NoteID
@ServerAccess
@ServerName
@Environment
@SetEnvironment
@Command
@GetIMContactListGroupNames
@GetPortsList
@LDAPServer
@TemplateVersion
@Platform
@HashPassword
@Password
@PasswordQuality
@PolicyIsFieldLocked
@DB2Schema
@DbCommand(Domino data source)
@DbCommand(ODBC data source)
@DbExists
@DbManager
@Version

Sting ,Converters & Others

@Ascii
@ToTime
@TimeToTextInZone
@TimeZoneToText
@ToNumber
@Keywords
@Eval
@ThisName
@ThisValue
@Sort

Web & URLS Functions

@URLDecode
@URLEncode
@URLGetHeader
@URLHistory
@URLOpen
@UrlQueryString
@WebDbName
@SetHTTPHeader
@BrowserInfo
@Domain

Address Book Functions

@UserAccess
@UserNameLanguage
@UserNamesList
@UserPrivileges
@UserRoles
@V2If
@V3UserName
@V4UserAccess
@ValidateInternetAddress
@VerifyPassword
@GetAddressBooks

Maths
@Sin
@Tan
@Cos
@ACos
@ASin
@Sqrt
@Sign
@Soundex
@ATan
@ATan2

Looping Statements

@Transform
@While
@DoWhile
@Nothing
@For



Other Formulas

@All
@Certificate
@CheckAlarms
@CheckFormulaSyntax
@Compare
@AbstractSimple
@ConfigFile
@Accessed
@DDEExecute
@DDEInitiate
@DDEPoke
@DDETerminate
@Exp
@FileDir
@FloatEq
@FontList
@FormLanguage
@LanguagePreference
@LaunchApp
@Like
@Ln
@OpenInNewWindow
@OptimizeMailAddress
@OrgDir
@Pi
@RegQueryValue
@SetTargetFrame
@ShowParentPreview
@Wide



,

No comments :

Post a comment

Subscribe to: Post Comments ( Atom )