Skip to content

System Methods

Call Methods

System

System.LogLocation()

call System.LogLocation("Work order started");  

Logs the users GPS location with a comment. Logging will only happen if the user accepts location usage in the device and the application parameters allow it. The actual logging of the users location will happen asynchronously after the procedure successfully completes. This makes sure the client database is not locked for long periods of time.

System.CreateGuid()

call System.CreateGuid() into MyGuid;  

Generates and returns a new GUID that contains 32 alphanumeric characters. For example, 86DFA50C48F64A30918D76DC81B16E97.

System.GetParameter()

call System.GetParameter("MyParameter") into MyVariable;  

Gets an application parameter value for a parameter defined in the app model. The parameter value can be changed in the Application Parameters screen in the Aurena client.

Lists

List.Add(List list, T item);

// variable Steps List<Structure(SurveyStep)>;  
// variable Item Structure(SurveyStep);  
call List.Add(Steps, Item);  

Adds an item to a list variable.

List.Remove(List list, T item);

// variable Steps List<Structure(SurveyStep)>;  
// variable Item Structure(SurveyStep);  
call List.Remove(Steps, Item);  

Removes an item from a list variable.

List.Clear(List list);

// variable Steps List<Structure(SurveyStep)>;  
call List.Add(Steps);  

Removes all items from a list variable.

List.Count(List list): Integer;

// variable Steps List<Structure(SurveyStep)>;  
// variable ListCount Integer;  
call List.Count(Steps) into ListCount;  

Adds an item to a list variable.

List.Get(List list, Integer index): T;

// variable Names List<Text>;  
// variable Name Text;  
call List.Get(Names, 5) into Name;  

Returns an item at the specified zero based index in the list.

List.IndexOf(List list, T item): Integer;

// variable Names List<Text>;  
// variable Index Integer;  
call List.IndexOf(Names, "John") into Index;  

Returns the zero based index of an item within a list. Returns < 0 if the item is not found.

Dates and Times

DateTime.Timestamp(): Timestamp

call DateTime.Timestamp() into Result;  

Gets the current timestamp.

DateTime.Timestamp( Integer year, Integer month, Integer day, Integer hours, Integer mins, Integer secs): Timestamp

call DateTime.Timestamp(2018, 4, 18, 12, 10, 0) into Result;  

Creates a timestamp from the supplied parameters.

DateTime.Date(): Date

call DateTime.Date() into Result;  

Gets the current date.

DateTime.Date(Timestamp ts): Date

call DateTime.Date(Attrib) into Result;  

Returns the timestamp with the time portion set to 00:00:00.

DateTime.Date(Integer year, Integer month, Integer day): Date

call DateTime.Date(2018, 4, 18) into Result;  

Creates a date from the supplied parameters.

DateTime.Time(Timestamp ts): Time

call DateTime.Time(Attrib) into Result;  

Returns the time from a timestamp.

DateTime.Time(Integer hours, Integer mins, Integer secs): Time

call DateTime.Time(12, 10, 0) into Result;  

Creates a time from the supplied parameters.

DateTime.AddYears(Timestamp ts, Integer years): Timestamp

call DateTime.AddYears(Attrib, 2) into Result;  

Adds years to the supplied timestamp.

DateTime.AddMonths(Timestamp ts, Integer months): Timestamp

call DateTime.AddMonths(Attrib, 3) into Result;  

Adds months to the supplied timestamp.

DateTime.AddDays(Timestamp ts, Number days): Timestamp

call DateTime.AddDays(Attrib, 3) into Result;  
call DateTime.AddDays(Attrib, 3.4) into Result;  

Adds days to the supplied timestamp. Fractional days are supported.

DateTime.AddHours(Timestamp ts, Number hours): Timestamp

call DateTime.AddHours(Attrib, 3) into Result;  
call DateTime.AddHours(Attrib, 3.4) into Result;  

Adds hours to the supplied timestamp. Fractional hours are supported.

DateTime.AddMinutes(Timestamp ts, Number minutes): Timestamp

call DateTime.AddMinutes(Attrib, 3) into Result;  
call DateTime.AddMinutes(Attrib, 3.4) into Result;  

Adds minutes to the supplied timestamp. Fractional minutes are supported.

DateTime.AddSeconds(Timestamp ts, Integer seconds): Timestamp

call DateTime.AddMinutes(Attrib, 30) into Result;  

Adds seconds to the supplied timestamp.

DateTime.DifferenceInDays(Timestamp a, Timestamp a): Number

call DateTime.DifferenceInDays(AttribA, AttribB) into Result;  

Calculated the difference between two timestamps in days as a fractional number.

DateTime.DifferenceInHours(Timestamp a, Timestamp a): Number

call DateTime.DifferenceInHours(AttribA, AttribB) into Result;  

Calculated the difference between two timestamps in hours as a fractional number.

DateTime.ToFormattedString(Timestamp input, Text format): Text

call DateTime.ToFormattedString(TimestampVar, "dd/mm/yyyy hh:mm") into Result;

Converts a given timestamp to a string using the .NET formatting options.

DateTime.ToOracleFormat(Timestamp input, Text format): Text

call DateTime.ToOracleFormat(TimestampVar, "DD-MON-YYYY HH24:MI:SS") into Result;

Converts a given timestamp to a string using the Oracle TO_CHAR formatting options.

String

String.Length(string): Number

call String.Length("abcde") into Result; // "5"  

Returns the length of a string

String.Trim(string): Text

String.Trim(string, char): Text

String.TrimStart(string): Text

String.TrimStart(string, char): Text

String.TrimEnd(string): Text

String.TrimEnd(string, char): Text

call String.Trim(" MyValue ") into Result; // "MyValue"  
call String.Trim("#MyValue ", "#") into Result; // "MyValue "  
call String.Trim("MyValue ", null) into Result; // null  
call String.Trim("MyValue ", "") into Result; // null  
call String.TrimEnd("#MyValue#", "#") into Result; // "#MyValue"  

Removes characters from the start or end of strings Note: if the char parameter is null or empty the Trim functions will return null.

String.ToUpper(string): Text

call String.ToUpper("MyValue") into Result; // "MYVALUE"  

Converts a string to upper case

String.ToLower(string): Text

call String.ToLower("MyValue") into Result; // "myvalue"  

Converts a string to lower case

String.Like(string, pattern): Boolean

call String.Like("123456", "12_45") into Result; // true  
call String.Like("023456", "12_45") into Result; // false  
call String.Like("023456", "%45")   into Result; // true  
call String.Like("cat house dog", "%house%") into Result; // true  
call String.Like("cat HOUSE dog", "%house%") into Result; // true  
call String.Like("123456", null) into Result; // false  

Compares two strings. % will match any number of characters, _ will match any single character. Strings are compared case-insensitive. Note: if the pattern is null or empty, the method will return false

String.Replace(string, searchString, replacementString): Text

call String.Replace("123456", "34", "##") into Result; // "12##56"  
call String.Replace("abABab", "b", "#") into Result; // "a#ABa#"  
call String.Replace("12345", null, "#") into Result; // 12345  
call String.Replace("123456", "34", null) into Result; // 1256  

Replaces all occurrences of searchString with replacementString. Note: - If searchString is null, the original string is returned - If replacementString is null, the searchString is removed from the original string

String.RegexLike(string, pattern): Boolean

String.RegexLike(string, pattern, options): Boolean

call String.RegexLike("abcde", "ab[ch]de") into Result; // true  
call String.RegexLike("abhde", "ab[ch]de") into Result; // true  
call String.RegexLike("abab", "ABAB") into Result; // false  
call String.RegexLike("abab", null) into Result; // false  
call String.RegexLike("abab", "ABAB", "i") into Result; // true  

Compares two strings using regular expressions. Note: if the pattern is null, the result is false.

String.RegexReplace(string, pattern, replacementString): Text

String.RegexReplace(string, pattern, replacementString, options): Text

call String.RegexReplace("abcac", "c", "d",) into Result; // "abdad"  
call String.RegexReplace("abcac", null, "d",) into Result; // "abcac"  
call String.RegexReplace("abCac", "c", "d",) into Result; // "abCad"  
call String.RegexReplace("abCac", "c", "d", "i") into Result; // "abdad"  

Replaces all occurrences of pattern with replacementString. Note:

  • If the pattern is null or empty, the original string is returned
  • If the replacementString is null or empty, the characters in the regexPattern are removed.

String.RegexSubString(string, pattern): Text

String.RegexSubString(string, pattern, position, occurence): Text

String.RegexSubString(string, pattern, position, occurence, options): Text

call String.RegexSubString("a,b,c", "[^,]+") into Result; // "a"  
call String.RegexSubString("a,b,c", null) into Result; // null  
call String.RegexSubString("a,b,c", "[^,]+", 0, 1) into Result; // "b"  
call String.RegexSubString("a,b,c", "[^,]+", 2, 0) into Result; // "b"  

Finds a substring of string that matches the regex pattern.

  • position = ZERO based position to start the search in string
  • occurrence = ZERO based occurrence to find

Note:

  • If the pattern is null or empty, null is returned
  • If the position or occurrence are out of bounds, null is returned
  • If no match is found, null is returned

String.RegexCount(string, pattern): Number

String.RegexCount(string, pattern, position): Number

String.RegexCount(string, pattern, position, options): Number

call String.RegexCount("a,b,c", "[^,]+") into Result; // 3  
call String.RegexCount("a,b,c", "[^,]+", 2) into Result; // 2  

Count the occurrences of the regex pattern in the string.

  • position = ZERO based position to start the search in string

Regular Expression Options

  • "i" = Case-insensitive match
  • "n" = Allows "." to match the newline character
  • "m" = Multiline mode. Changes the meaning of ^ and $ so they match at the beginning and end of any line, not just the beginning and end of the entire string.

Note:

  • If pattern is null or empty, null is returned
  • If the position is greater than the string input, 0 is returned

#### String.Tokenize(string, delimiter): List\

call String.Tokenize("TASK_SEQ=20267^&TASK_SEQ=20268^", "&") into Result;   
// List<Text> { "TASK_SEQ=20267^", "TASK_SEQ=20268^" }  
call String.Tokenize("foo=bar^;test=value^", ";") into Result;   
// List<Text> { "foo=bar^", "test=value^" }  
call String.Tokenize("test1^test2^^test3", "^") into Result;   
// List<Text> { "test1", "test2", "test3" }  

Note:

  • Strips empty entries such as "A^B^^C" becomes "A", "B", "C"

Convert.ToNumber(value): Number

call Convert.ToNumber("505") into Result; // 505  
call Convert.ToNumber("505.7") into Result; // 505.7  

Converts a value to a number Note: if an incorrect value is passed, the default value of null will be returned

Convert.ToInteger(value): Number

call Convert.ToInteger("505") into Result; // 505  
call Convert.ToInteger("505.7") into Result; // 505  
call Convert.ToInteger("2015-09-15T07:00:00") into Result; // null  
call Convert.ToInteger(true) into Result; // 1  
call Convert.ToInteger(false) into Result; // 0  
Converts a value to an integer  

Note: if an incorrect string value is passed, null will be returned

Convert.ToBoolean(value): Boolean

call Convert.ToBoolean("true") into Result; // true  
call Convert.ToBoolean("True") into Result; // true  
call Convert.ToBoolean("TRUE") into Result; // true  
call Convert.ToBoolean("false") into Result; // false  
call Convert.ToBoolean(0) into Result; // false  
call Convert.ToBoolean(1) into Result; // true  
call Convert.ToBoolean("HelloWorld") into Result; // null  

Converts a value to a boolean. Note: if an incorrect value is passed, the default value of null will be returned

Convert.ToTimestamp(value): Timestamp

call Convert.ToTimestamp("2018-06-28T13:01:46") into Result;   
    // Result = 2018/06/28 13:01:46.000000  
call Convert.ToTimestamp("2018-06-28T13:01:46.0000000") into Result;   
    // Result = 2018/06/28 13:01:46.000000  
call Convert.ToTimestamp("2018/06/28 13:01:46") into Result;   
    // null  

Converts a value to a timestamp Note: if an incorrect Timestamp format is passed to this method, the result will be null

Convert.ToString(value): Text

call Convert.ToString(NumberVariable) into Result; // Result "505.7"  
call Convert.ToString(IntegerVariable) into Result; // Result "505"  
call Convert.ToString(BooleanVariable) into Result; // Result "True"  
call Convert.ToString(TimestampVariable) into Result; // Result "2018-06-28T13:01:46.0000000"  

Converts a value to a string

Attachment

Attachment.CreateAndConnectDoc(string LuName, string KeyRef)

Attachment.CreateAndConnectDoc(string LuName, string KeyRef, string Title)

// variable Keys Structure(FndDocumentKeys);  
call Attachment.CreateAndConnectDoc("WorkOrder", "WO_NO=3323^", "My Document Title")  
    into Keys;   

Creates a new document with Title and connects it to the specified record by LuName and KeyRef. This call will return the keys of the document (DocClass, DocNo, DocSheet and DocRev) which can later be used in the upload statement of a command.

Attachment.GetDocFileExtensions()

// variable FileExts Text  
call Attachment.GetDocFileExtensions() into FileExts;  

Returns a comma separated list of file extensions that can be used when attaching files to a document created by CreateAndConnectDoc.

Attachment.CreateAndConnectMedia(string LuName, string KeyRef)

Attachment.CreateAndConnectMedia(string LuName, string KeyRef, string Name)

// variable Keys Structure(FndMediaKeys);  
call Attachment.CreateAndConnectMedia("WorkOrder", "WO_NO=3323^", "My Media Name")  
    into Keys;   

Creates a new media item with Name and connects it to the specified record by LuName and KeyRef. This call will return the keys of the media item (ItemId) which can later be used in the upload statement of a command.

Attachment.GetMediaFileExtensions()

// variable FileExts Text  
call Attachment.GetMediaFileExtensions() into FileExts;  

Returns a comma separated list of file extensions that can be used when attaching files to a media item created by CreateAndConnectMedia.

Where Expression Methods

A limited subset of the system calls that can be used in procedures can also be used in where expressions. E.g.: using the current timestamp within a count query or an offline filter:

offlinefilter = [DateTime.Timestamp() < ExpiresAt];  

count Reports where [DateTime.Timestamp() < ExpiresAt] into ReportCount;  

The following calls can be made in where expressions:

DateTime.Timestamp(): Timestamp  
DateTime.Date() : Date  
DateTime.Date(Timestamp ts) : Date  
DateTime.Time(Timestamp ts) : Time  
DateTime.AddYears(Timestamp ts, Integer years) : Timestamp  
DateTime.AddMonths(Timestamp ts, Integer months) : Timestamp  
DateTime.AddDays(Timestamp ts, Number days) : Timestamp  
DateTime.AddHours(Timestamp ts, Number hours) : Timestamp  
DateTime.AddMinutes(Timestamp ts, Number minutes) : Timestamp  
DateTime.AddSeconds(Timestamp ts, Integer seconds) : Timestamp  
String.Like(string, pattern) : Boolean