Functions and Actions
$$IsRepeatColumnContext
The function IsRepeatColumnContext validates whether the report is in columnar mode or not.
Syntax
$$IsRepeatColumnContext
Example
[Report: FLT Range Value]
Set : ReportFilterObjType: If $$NumSets = 1 Then @@FLTSingleSetObj Else If NOT $$IsRepeatColumnContext Then $$GetFilterObjType:@@RangeFilter Else $$GetFilterObjType:@@ValueFilter
$$ExtractPatternEx
The function returns the extracted values provided at the input string. The return value retains space, comma, and hyphen depending on the parameters passed.
Syntax
$$ExtractPatternEx:<Expression>:<Pattern Expression>:<Logical value 1>:<Logical value 2>:<Logical value 3>
Where,
- Expression can be any string value that needs to be extracted.
- Pattern expression can be any pattern the required string needs to be extracted.
- Logical value 1 to retain spaces. This is an optional parameter. In absence of the value the default value is set to No.
- Logical value 2 to retain comma. This is an optional parameter. In absence of the value the default value is set to No.
- Logical value 3 to retain hyphen. This is an optional parameter. In absence of the value the default value is set to No.
Example
[Field: Fld 1]
Set as : $$ExtractPatternEx:”ab-c def,12-3 45,Z”:”a-c,1-3,Z”:Yes:Yes:Yes
Output
ab-c ,12-3 ,Z
$$RemoveChar
The function allows to remove characters with an option to do removing in the leading, at the trailing or when surrounded by other characters and return the trimmed string
Syntax
$$RemoveChar:<Expression 1>:<Expression 2>[:<Logical value 1>[:<Logical value 1>[:Logical value 1>]]]
Where,
- Expression 1 can be any string that need to extracted
- Expression 2 can be any character that needs to removed from the above string
- Logical Value 1 is to remove characters from the leading. In absence of the value the default value is set to Yes.
- Logical Value 2 is to remove characters from the enclosed. In absence of the value the default value is set to Yes.
- Logical Value 3 is to remove characters from the trailing. In absence of the value the default value is set to Yes.
Example
[Field: Remove Char]
Use : Name Field
Set As : $$RemoveChar:@@StringToBeTrimmed:@@CharToBeRemoved:@@RemoveLeading:+
@@RemoveEnclosed:@@RemoveTrailing
Set Always : Yes
Read Only : Yes
[System: Formulae]
StringToBeTrimmed : ” 29AAA CP7879 D1Z0 “
CharToBeRemoved :” “
RemoveLeading : Yes
RemoveEnclosed : Yes
RemoveTrailing : Yes
$$CmpNumberFromPath
The function returns the company based on path specified as parameter.
Syntax
$$CmpNumberFromPath:<Expression>
Where,
- <Expression> can be any string that is directory path which has data.
Example
[Field: CompanyNumber]
Set as : $$CmpNumberFromPath:##SVCurrentPath
$$IsValidCompanyDir
The function determines whether the given path is of a company.
Syntax
$$IsValidCompanyDir:<Expression>
Where,
- <Expression> can be any string that is directory path which has data.
Example
[Field : CmpValidPath]
Set as : If $$IsValidCompanyDir:##SVCurrentPath then ##SVCurrentPath else “”
$$ColumnNumber
This function returns the column number in a columnar report. If it is not a columnar report it will return zero.
Syntax
$$ColumnNumber
Example
[System: Formula]
IsFilterNAInColumn : $$ColumnNumber > 0 AND @@FLTIsRemoteCompany
Action – CopyToClipboard
The action would take input expression that evaluates to a string which needs to be copied to the clipboard and perform the copying.
Syntax
CopyToClipboard:<StringToBeCopied>
Example
[Key: CopyToClipBoard]
Key : Ctrl + C
Title : $$LocaleString:”Copy”
Action : Copy To Clipboard : ##InputToClipBoard
