@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
@DocDescendants
@DeleteDocument
@DocFields
@DocFields
@DeleteField
@DocLength
@DocLevel
@DocLock
@DocMark
@DocNumber
@DocOmmittedLength
@DocParentNumber
@DocSiblings
@DocLength
@DocLevel
@DocLock
@DocMark
@DocNumber
@DocOmmittedLength
@DocParentNumber
@DocSiblings
@AllChildren
@AllDescendants
@AllDescendants
@DialogBox
@PickList
@DocumentUniqueID
@GetFocusTable
@GetHTTPHeader
@GetFocusTable
@GetHTTPHeader
@InheritedDocumentUniqueID
@HardDeleteDocument
@Responses
@Prompt
@Prompt
@GetViewInfo
@PostedCommand
@RefreshECL
@Power
@RefreshECL
@Power
@ViewShowThisUnread
@ViewTitle
@ViewTitle
@AddToFolder
@UndeleteDocument
@UpdateFormulaContext
@UndeleteDocument
@UpdateFormulaContext
@WhichFolders
@AdminECLIsLocked
@EditECL
@EditUserECL
@EnableAlarms
@Set
@EditUserECL
@EnableAlarms
@Set
@SetViewInfo
@StatusBar
@Doc Fields
@StatusBar
@Doc Fields
@GetDocField
@GetProfileField
@SetProfileField
@SetDocField
@isFormulas
@IsAgentEnabled
@IsAppInstalled
@IsCategory
@IsDB2
@IsDocBeingEdited
@IsDocBeingMailed
@IsDocBeingRecalculated
@IsDocTruncated
@IsEmbeddedInsideWCT
@IsExpandable
@IsInCompositeApp
@IsModalHelp
@IsUsingJavaElement
@IsValid
@IsVirtualizedDirectory
@IsAppInstalled
@IsCategory
@IsDB2
@IsDocBeingEdited
@IsDocBeingMailed
@IsDocBeingRecalculated
@IsDocTruncated
@IsEmbeddedInsideWCT
@IsExpandable
@IsInCompositeApp
@IsModalHelp
@IsUsingJavaElement
@IsValid
@IsVirtualizedDirectory
Date & Time:
@Locale
@Zone
@GetCurrentTimeZone
@TimeMerge
@BusinessDays
@BusinessDays
DB
& Server Formulas
@Log
@MailDbName
@MailEncryptSavedPreference
@MailEncryptSentPreference
@MailSavePreference
@MailSend
@MailSignPreference
@Matches
@NameLookup
@Narrow
@NoteID
@ServerAccess
@ServerName
@MailDbName
@MailEncryptSavedPreference
@MailEncryptSentPreference
@MailSavePreference
@MailSend
@MailSignPreference
@Matches
@NameLookup
@Narrow
@NoteID
@ServerAccess
@ServerName
@Environment
@SetEnvironment
@Command
@GetIMContactListGroupNames
@GetPortsList
@LDAPServer
@GetPortsList
@LDAPServer
@TemplateVersion
@Platform
@Platform
@HashPassword
@Password
@PasswordQuality
@PasswordQuality
@PolicyIsFieldLocked
@DB2Schema
@DbCommand(Domino data source)
@DbCommand(ODBC data source)
@DbExists
@DbManager
@Version
@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
@TimeZoneToText
@ToNumber
@Keywords
@Eval
@ThisName
@ThisValue
@Sort
Web
& URLS Functions
@URLDecode
@URLEncode
@URLGetHeader
@URLHistory
@URLOpen
@UrlQueryString
@WebDbName
@SetHTTPHeader
@BrowserInfo
@Domain
@URLEncode
@URLGetHeader
@URLHistory
@URLOpen
@UrlQueryString
@WebDbName
@SetHTTPHeader
@BrowserInfo
@Domain
Address Book Functions
@UserAccess
@UserNameLanguage
@UserNamesList
@UserPrivileges
@UserRoles
@V2If
@V3UserName
@V4UserAccess
@ValidateInternetAddress
@VerifyPassword
@GetAddressBooks
@UserNameLanguage
@UserNamesList
@UserPrivileges
@UserRoles
@V2If
@V3UserName
@V4UserAccess
@ValidateInternetAddress
@VerifyPassword
@GetAddressBooks
Maths
@Sin
@Tan
@Cos
@Tan
@Cos
@ACos
@ASin
@Sqrt
@ASin
@Sqrt
@Sign
@Soundex
@ATan
@ATan2
@Soundex
@ATan
@ATan2
Looping
Statements
@Transform
@While
@DoWhile
@Nothing
@For
@Nothing
@For
Other Formulas
@All
@Certificate
@CheckAlarms
@CheckFormulaSyntax
@Compare
@All
@Certificate
@CheckAlarms
@CheckFormulaSyntax
@Compare
@AbstractSimple
@ConfigFile
@ConfigFile
@Accessed
@DDEExecute
@DDEInitiate
@DDEPoke
@DDETerminate
@Exp
@FileDir
@FloatEq
@FontList
@FormLanguage
@LanguagePreference
@LaunchApp
@Like
@Ln
@OpenInNewWindow
@OptimizeMailAddress
@OrgDir
@Pi
@RegQueryValue
@SetTargetFrame
@ShowParentPreview
@DDEExecute
@DDEInitiate
@DDEPoke
@DDETerminate
@Exp
@FileDir
@FloatEq
@FontList
@FormLanguage
@LanguagePreference
@LaunchApp
@Like
@Ln
@OpenInNewWindow
@OptimizeMailAddress
@OrgDir
@Pi
@RegQueryValue
@SetTargetFrame
@ShowParentPreview
@Wide
@Formulas In xPages
Formula used in xPages: Many
of we know how @formulas works on tradition lotus Notes and also the power of
formula language & performance, so as a result formula language still alive
in newly added design element “xPages”.
Formula in xPages performs very good roles for the
execution of complex logic.
xPages uses three type of language , in which we have
"Server Side Java Script" , "Client side Java
Script".
The best part of xPages is we can use formula languages
without doing immense changes, the difference is in its structure not Syntax ,
so we don’t need to worry about syntax. One small change in formula language
will help to achieve your goal in xPages
-
Formula in xPages. The only difference is in its "Separator",
we use ";" as separator in our traditional lotus notes formula
language. For example
@Contains("xPage Domino";"Domino")
Use the syntax in xPage JavaScript. I.e.
@Contains("xPage Domino","Domino")
As I said we made the difference is in delimiter. We
used. "," instead ";" . So the same you can apply to all
formula used in xPage. but do you know how many formulas we used in xPages, or
how many @formulas supports to xPages JavaScript?
We have list of all formulas used in xPages. Let’s find
below –
DB Functions
@DbColumn
|
@DbLookup
|
@DbTitle
|
@DbName
|
@ReplicaID
|
Document Functions
@AttachmentModifiedTimes
|
@AttachmentNames
|
@Attachments
|
@Author
|
@IsDocBeingSaved
|
@AttachmentLengths
|
@Created
|
@Modified
|
@Name
|
@Success
|
@SetField
|
@UserName
|
@Failure
|
@GetField
|
@IsNewDoc
|
@True
|
Date & Time Functions
@Yesterday
|
@Weekday
|
@Year
|
@Date
|
@Day
|
@Hour
|
@Month
|
@Minute
|
@Tomorrow
|
@Today
|
@Now
|
@Time
|
@Adjust
|
DataTypes , Convertors & Other
@Contains
@IsMember
@IsNotMember
@Member
@Text
@TextToNumber
@TextToTime
@Unique
@Modulo
@Yes
@Integer
@Elements
@Count
@Second
@Return
@Repeat
@Select
@Null
@No
@False
@If
@Element
@Char
@Do
@Ends
@Error
String Functions
@Right
@RightBack
@Left
@LeftBack
@Middle
@MiddleBack
@UpperCase
@LowerCase
@ProperCase
@Trim
@ReplaceSubstring
@Replace
@Length
@Word
@Implode
@Explode
@NewLine
@Begins
'@isFormulas
@IsAvailable
@IsDocBeingLoaded
@Left
@List
@IsDocBeingSaved
@IsError
@IsNewDoc
@IsNull
@IsNumber
@IsResponseDoc
@IsText
@IsTime
@IsUnavailable
Thanks for reading this article, hope you like it, if you have any difficulty please contact us on ‘admin@xpagedomino.com’ or click here to contact us.
Subscribe to:
Posts
(
Atom
)
No comments :
Post a comment