@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

Leave A Comment...

@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.









No comments :

Post a Comment

Leave A Comment...