Builtin Functions
A builtin function returns a value calculated from one or more value parameters.
The following Builtin functions can be used within 1Integrate.
Note: You can add your own builtin functions by writing Java classes. For more information see the 1Integrate Builtin Function Programmer Guide.
Note: Builtin Functions for measured geometries are not applicable until import and export for measured geometries is added in a subsequent release.
Function  Description  Parameter(s) 

angle 
Angles are calculated between two line segments, which do not need to converge or touch. Returns an acute angle in either degrees or radians. A negative value is returned for errors. 

area 
Returns the area of a geometry in dataset units. If the geometry is a point or a line the result will be 0. If the geometry is a complex geometry, the result will be the sum of the areas of each simple area in the complex geometry. Note: This function does not currently fully support 3D or measured geometries. Any 3D or measured geometries will be projected down to 2 dimensions. 

boundary 
Returns the boundary of a line or area.
This function supports 3D and 2D geometries. For point geometries, a Null value is returned. 

buffer 
Returns an area geometry representing a buffer zone of a fixed distance from the boundary of a geometry. 

convex_hull 
Returns the smallest convex area geometry that contains the input geometry. The return value will be a simple area geometry with no inner rings. Note: This function does not currently fully support 3D or measured geometries. Any 3D or measured geometries will be projected down to 2 dimensions. 

count_ inner_rings 
Counts the clockwise digitised rings of a simple or complex geometry.


count_parts 
Returns the number of parts in a geometry.


count_vertices 
Returns the total number of vertices in a simple or complex geometry. The number of points in a ring does not include a duplicate point that closes the ring.


create_ geometry_ from_wkt 
Creates a geometry from a geometric wellknown text string (WKT). Supported types are:
Empty geometries, or those which specify their dimension as Z, M or ZM, are not supported. 

difference 
Returns the difference between two geometries; all the parts of the first geometry that are not in the second geometry. Note: This function does not currently fully support 3D or measured geometries. Any 3D or measured geometries will be projected down to 2 dimensions. 

difference_ between_ bearings 
Returns an angle in degrees between 0 and 90, representing the difference between two bearings. 

difference_ by_dimension 
A geometry equal to geometry1 AND NOT geometry2. Note: This function does not currently fully support 3D or measured geometries. Any 3D or measured geometries will be projected down to 2 dimensions. 

dimension 
Returns the dimension (geometry type) of the input geometry: 0 for a point, 1 for lines, 2 for polygons or 1 if the input is null. This is independent of whether a geometry is heighted, measured or contains multiple parts. If geometry contains a mixture of types then it will return the largest dimension. 

distance 
Returns the distance in dataset units at the closest point of approach of two geometries. Note: This function does not currently fully support 3D or measured geometries. Any 3D or measured geometries will be projected down to 2 dimensions. 

douglas_ peucker 
Returns a simplified version of a geometry formed by applying the DouglasPeucker smoothing algorithm to each piece of linework in the geometry. The result will be a geometry which approximates the original geometry using fewer vertices. The linework of the resulting geometry will lie entirely within the specified tolerance of the original geometry's linework. 

drag_ vertex 
Returns a geometry formed by moving a specified vertex on a simple line geometry to a new location. It uses a scale and rotate algorithm to try to preserve the shape of the geometry on either side of the vertex being moved. Note: This function does not currently fully support 3D or measured geometries. Any 3D or measured geometries will be projected down to 2 dimensions. 

end_of  Returns a point geometry at the location of the end of a simple line geometry. 

ends_of 
Returns the endpoints of a simple line geometry. If the line is closed, the result will be a simple point geometry. Otherwise the result will be a complex geometry containing two points. Note: This function does not currently fully support 3D or measured geometries. Any 3D or measured geometries will be projected down to 2 dimensions. 

find_ duplicates 
Returns a collection of point geometries, representing any duplicate points within a geometry. Note: This function does not currently fully support 3D or measured geometries. Any 3D or measured geometries will be projected down to 2 dimensions. 

find_ kickbacks 
Returns a collection of point geometries, representing the locations of any kickbacks within a geometry. Kickbacks are a type of geometric error where a line segment changes direction twice by approximately 180 degrees (like a z shape) to repeat part of the line. They are usually detected with larger angles than spikes which is why there is a separate builtin to find them. 

find_ self_ intersections 
Returns a multipoint geometry representing the points at which a line, or the rings of an area, selfintersect. 

find_small_ rings 
Returns a descriptor for the complex line geometry containing small rings. One or more of the following criteria may be used to determine if a ring is to be considered small:
Note: This function does not currently fully support 3D or measured geometries. Any 3D or measured geometries will be projected down to 2 dimensions. 
Note: If any of these parameters is negative it is ignored. 
find_spikes 
Returns a descriptor for the point complex geometry containing spike points. A spike is defined to be three consecutive points (A, B, C) such that:


get_job_ extent 
Obtains the extent of the current session. Note: This does not calculate the minimum bounding rectangle (MBR) of the loaded data. This is calculated from the following (in order of priority):


get_point 
Returns a point guaranteed to lie on the specified geometry. The point is not necessarily near to the centre of the geometry, but is guaranteed to lie inside it. Note: This function does not currently fully support 3D or measured geometries. Any 3D or measured geometries will be projected down to 2 dimensions. 

get_x 
Returns the x coordinate of a point on a simple or complex geometry. For a point geometry the return will be the x coordinate of that geometry. For other types of geometry the return will be the x coordinate of an arbitrary point on the input geometry. Note: This function does not currently fully support 3D or measured geometries. Any 3D or measured geometries will be projected down to 2 dimensions. 

get_y 
Returns the y coordinate of a point on a simple or complex geometry. For a point geometry the return will be the y coordinate of that geometry. For other types of geometry the return will be the y coordinate of an arbitrary point on the input geometry. Note: This function does not currently fully support 3D or measured geometries. Any 3D or measured geometries will be projected down to 2 dimensions. 

has_ duplicates 
Tests to see if a geometry has any consecutive coincident vertices. Returns a Boolean value, true if the geometry has any consecutive coincident vertices and false if it does not. 

has_ kickbacks 
Checks whether a geometry has any kickbacks (a type of geometric error where a line segment changes direction twice by approximately 180 degrees to repeat part of the line). Kickbacks are also known as snapbacks. Note: This function does not currently fully support 3D or measured geometries. Any 3D or measured geometries will be projected down to 2 dimensions. 

has_ small_ rings 
Checks whether a geometry has any small rings (pig tails). Returns true if the geometry has small rings and false if it does not. One or more of the following criteria may be used to determine if a ring is to be considered small:
Note: This function does not currently fully support 3D or measured geometries. Any 3D or measured geometries will be projected down to 2 dimensions. 
Note: If any of these parameters is negative it is ignored. 
has_spikes 
Checks whether a geometry has any spikes. Returns true if the geometry has spikes and false if it does not. A spike is defined to be three consecutive points (A, B, C) such that:
Note: This function does not currently fully support 3D or measured geometries. Any 3D or measured geometries will be projected down to 2 dimensions. 

height 
Returns the height of the nearest vertex for a 3D geometry. Note: If the point does not coincide with a vertex on the 3D feometry, then the nearest vertex is chosen. 

inner_ rings 
Returns the inner rings of a simple area geometry, or the inner rings of all areas in a complex geometry. If there is only one inner ring, that ring is returned as a simple line. If there are several, they are returned as components of a complex line geometry. Returns null if applied to a null geometry, a nonarea geometry, an area geometry without inner rings or a complex geometry containing areas with no inner rings. The result has the same dimensionality (2D or 2.5D) as the input geometry. 

intersection 
Returns the intersection of two or more geometries  the parts in common between all of them. Note: This function does not currently fully support 3D or measured geometries. Any 3D or measured geometries will be projected down to 2 dimensions. 

intersection_ by_dimension 
Returns a geometry equal to the intersection of all the input geometries, or null if the intersection is empty. Note: This function does not currently fully support 3D or measured geometries. Any 3D or measured geometries will be projected down to 2 dimensions. 

is_aligned 
Tests whether two line geometries are aligned. Returns true if the geometries are aligned and false otherwise. Note: This function does not currently fully support 3D or measured geometries. Any 3D or measured geometries will be projected down to 2 dimensions. 

is_boundary_ left 
Tests whether a point, line or area geometry is to the left of a line geometry with respect to the direction of the line geometry. Returns true if the boundary left relationship holds and false otherwise. Note: This function does not currently fully support 3D or measured geometries. Any 3D or measured geometries will be projected down to 2 dimensions. 

is_boundary_ right 
Tests whether a point, line or area geometry is to the right of a line geometry with respect to the direction of the line geometry. Returns true if the boundary right relationship holds and false otherwise. Note: This function does not currently fully support 3D or measured geometries. Any 3D or measured geometries will be projected down to 2 dimensions. 

is_closed  Tests whether a geometry is closed. Returns true if the geometry is a simple area or if it is a simple line with coincident end points. 

is_downhill 
Tests whether a 3D line geometry is digitised in a downhill direction. Returns a Boolean value, true if the geometry is a 3D line that slopes downwards and false otherwise. Returns null if parameter 1 is not a 3D simple line geometry. An optional tolerance may be supplied to use when comparing the heights of vertices on the line. The line is considered to be downhill if each vertex is lower than all the preceding vertices, to within the specified tolerance. 

is_level 
Tests whether a 3D line geometry has a constant height along its length. Returns a Boolean value, true if the geometry is a 3D line is level and false otherwise. Returns null if parameter 1 is not a 3D simple line geometry. An optional tolerance may be supplied for use when comparing the heights of vertices on the line. The line is considered to be level if the maximum height minus the minimum height along the line is less than or equal to the specified tolerance. 

is_noded 
Tests if two line geometries intersect at common vertices. Returns true if the geometries are noded and false otherwise. 

is_simple 
Tests to see if a geometry is simple according to the OGC definition. Returns a Boolean value, true if the geometry is simple according to the OGC definition and false if it is not. Note: This function does not currently fully support 3D or measured geometries. Any 3D or measured geometries will be projected down to 2 dimensions. 

is_uphill 
Returns true if a 3D line slopes upwards, with an optional tolerance for comparing the heights of vertices on the line. The line is considered to be uphill if each vertex is higher than all the preceding vertices, to within tolerance. 

is_valid 
Tests to see if a geometry is valid according to the OGC definition. Returns a Boolean value, true if the geometry is valid according to the OGC definition and false if it is not. 

line 
Returns a line geometry constructed from points supplied in parameters. Note: This function does not currently fully support 3D or measured geometries. Any 3D or measured geometries will be projected down to 2 dimensions. 

line_bearing 
Returns the angle of the line at a point between pi and pi, measured in radians anticlockwise from east (positive x axis). 

line_ length 
Returns the length of a geometry in dataset units. The length of a point or an area is 0. The length of a complex geometry is the sum of the lengths of its component simple line geometries. Note: This function does not currently fully support 3D geometries. Any 3D geometries will be projected down to 2 dimensions. 

line_segment 
Returns a segment cut out of a simple line geometry, or null if the distance parameters are out of range. The start and end points of the segment are specified by distances along the line, measured from its start. A negative value indicates a distance from the line end instead of the start. With a 3D line geometry, distances are in plan; if the start or end of the segment is between two vertices with height values, the segment endvertex is given an interpolated height. 

make_2d 
Returns a 2D geometry. If the argument is not valid, then null is returned. 

make_3d 
Returns a 3D geometry. If the argument is not valid, then null is returned. 

max_ deflection_ angle 
Returns the maximum deflection angle (in degrees) between adjacent line segments in a geometry.


max_ height 
Returns the maximum height of a 3D geometry. 

mbr 
Returns the minimum bounding rectangle (MBR) of one or more geometries. The result is the smallest rectangle, with sides parallel to the X and Y axes, that contains all the input geometries. Note: This function does not currently fully support 3D or measured geometries. Any 3D or measured geometries will be projected down to 2 dimensions. 

min_height  Returns the minimum height of a 3D geometry. 

min_ intersection_ angle 
Returns the minimum intersection angle between two geometries. Returns 1 if the two geometries do not intersect. Note: This function does not currently fully support 3D or measured geometries. Any 3D or measured geometries will be projected down to 2 dimensions. 

move_ vertex 
Returns a geometry formed by moving a vertex on a simple line geometry. This function will only move one vertex on the geometry and so may leave a spike. For smoother results, consider the drag_vertex function. Note: For heighted or measured geometries: If the new point has a height/measure then the height/measure from the point will be applied. If the new location point is 2D then the height/measure value on the original vertex is retained. 

nearest_ point 
Returns a geometry representing the nearest point(s) on a provided geometry from an originating point geometry. This will be complex if multiple points are equally close to the originating point. If neither parameter is a geometry an exception is thrown. Note: This function does not currently fully support 3D or measured geometries. Any 3D or measured geometries will be projected down to 2 dimensions. 

nearest_ vertex 
Returns a point geometry at the nearest vertex on a geometry, described by the nearest known X and Y positions. Note: This function does not currently fully support 3D or measured geometries. Any 3D or measured geometries will be projected down to 2 dimensions. 

offset  Offsets (translates) a geometry by a fixed distance without changing its shape, size or orientation. 

outer_ring  Returns the outer ring of a simple area geometry. The result will be a closed simple line geometry. 

perimeter 
Returns the perimeter of an area geometry. If the geometry is a point or a line, the result will be 0. If the geometry is a complex geometry, the result will be the sum of the perimeters of each simple area geometry in the complex geometry. Note: This function does not currently fully support 3D or measured geometries. Any 3D or measured geometries will be projected down to 2 dimensions. 

point 
Builds a 2D point (if passing x and y values) or a 2.5D point (if passing x, y and z values). 

point_ along_line 
Returns a point on a line geometry at a distance along it expressed as a proportion of the total length of the line. 

point_ at_ projection 
Returns a new point, the specified bearing and distance from the origin point. 

point_ on_line 
Finds a point on a line geometry, a given distance along it from its start or end point. Returns null if the distance parameter is out of range. With a 3D line, the height will be interpolated between vertices. 

polygon 
Forms an area geometry from a simple closed line geometry, a complex line geometry containing one or more rings, a simple area, or a complex area geometry. Returns null if the rings do not form a valid area geometry. 

proportion_ along_line 
Finds the nearest position on a line to a given point, and calculates its distance along the line, expressed as a proportion of the total length of the line (a real number in the range between 0 and 1). 

remove_ duplicates 
Removes any duplicate vertices from a geometry. Any occurrence of consecutive, coincident vertices is replaced with a single vertex at the same location. 

remove_ kickbacks 
Removes any kickbacks (a type of geometric error where a line segment changes direction twice by approximately 180 degrees to repeat part of the line) from a geometry. Note: This function does not currently fully support 3D or measured geometries. Any 3D or measured geometries will be projected down to 2 dimensions. 

remove_ small_rings 
Removes any small rings from a geometry. Returns null if all of the rings are too small. Note: This function does not currently fully support 3D or measured geometries. Any 3D or measured geometries will be projected down to 2 dimensions. 

remove_ spikes 
Removes any spikes from a geometry. A spike is defined to be three consecutive points (A, B, C) such that:
Note: This function does not currently fully support 3D or measured geometries. Any 3D or measured geometries will be projected down to 2 dimensions. 

reverse_ line 
Reverses the order of the vertices in a simple line geometry. Returns a copy of the line geometry, with the same vertices but running in the opposite direction. Returns null if parameter is not a simple line geometry. 

round_ geom 
Returns a rounded geometry. 

rule_ 
A collection geometry containing the hotspots from this feature for the triggering Rule, or null. If an optional default is provided, will return the default instead of null. 

scale_ and_rotate 
Returns a 2D copy of the input geometry scaled and rotated. 

segment 
Returns a segment from a line as two consecutive vertices. Note: This function does not currently fully support 3D or measured geometries. Any 3D or measured geometries will be projected down to 2 dimensions. 

segments 
Obtains the segments from a geometry, returning as a Complex Line. If no segments are present, this geometry will be clear. Note: This function does not currently fully support measured geometries. Any measured geometries will be projected down to 2 dimensions. 

start_of  Returns a point geometry at the location of the start of a simple line geometry. 

symmetric_ difference 
Returns a geometry equal to geometry1 XOR geometry2. Note: This function does not currently fully support 3D or measured geometries. Any 3D or measured geometries will be projected down to 2 dimensions. 

symmetric_ 
Returns a geometry equal to geometry1 XOR geometry2. Note: This function does not currently fully support 3D or measured geometries. Any 3D or measured geometries will be projected down to 2 dimensions. 

true_ distance 
Returns the distance along the surface of the earth between the 2 points. 

union 
Returns the union of two or more geometries. Note: This function does not currently fully support 3D or measured geometries. Any 3D or measured geometries will be projected down to 2 dimensions. 

union_ by_ dimension 
Returns a geometry equal to the union of all the input geometries. Note: This function does not currently fully support 3D or measured geometries. Any 3D or measured geometries will be projected down to 2 dimensions. 

vertices 
Obtains the vertices of a geometry, returned as a Complex Point. If no vertices are present, this geometry will be clear. Note: This function does not currently fully support measured geometries. Any measured geometries will be projected down to 2 dimensions. 

Function  Description  Parameter(s) 

get_ measure_ maximum 
Returns the maximum measure value of a geometry. The maximum value may not necessarily be found at the start/end of the geometry. Measures can be null so the maximum may be null. If the input parameter is null, the value returned will be null. If the input geometry is not a measured geometry, an exception will be thrown. 

get_ measure_ minimum 
Returns the minimum measure value of a geometry. The minimum value may not necessarily be found at the start/end of the geometry. Measures can be null so the minimum may be null. If the input parameter is null, the value returned will be null. If the input geometry is not a measured geometry, an exception will be thrown. 

is_measured _line_ monotonic_ increasing 
Returns a boolean to indicate if the input measured geometry is a simple line and measured with values increasing in the digitised direction along its length. If the input geometry is not a simple measured line, an exception will be thrown. 

line_ segment_ from_ measures 
Returns the segment of linework between 2 particular measure values. The returned line geometry will be in direction based on the order of the specified measure values, rather than the geometric order of the input line. 

measure_ from_point 
Returns the measure value located at the nearest position on the input line to the point geometry. Linear interpolation between stored measure values (located at vertices) will be used to identify the exact measure value along the input line where the nearest location (in 2D plan form) to the point is found. If the measure value at the specified vertex is null or if either of the measure values adjacent to the point geometry are null, the return value will be null. If the input geometry is not a simple measured line, an exception will be thrown. 

measured_ point 
Builds a measured point from x, y and m values. 

point_ from_ measure 
Returns a point geometry located at the first position on the input line where the measure value is found. Linear interpolation between stored measure values (located at vertices) will be used to identify the exact position along the line where the specified measure value is found. If the input geometry is not a simple measured line, an exception will be thrown. If the measure value is not found in the input geometry, an exception will be thrown. 

set_ measure 
Returns a copy of the input geometry with a measure set at the specified location. Note: This will overwrite any existing measure value at that location. Setting a null measure value is supported. 

Function  Description  Parameter(s) 

to_degrees  Converts an angle specified in radians to degrees. 

to_integer 
Converts a numerical, boolean or string value to an integer. Any decimal digits present in the number after the decimal point are removed. The boolean values true and false are converted into 1 and 0 respectively. 

to_radians  Converts an angle specified in degrees to radians. 

to_real  Converts a numerical, boolean or string value to a real (floating point) number. 

to_string  Converts any value to a string. 

Function  Description  Parameter(s) 

abs 
Returns the absolute value of the input parameter. If the parameter is negative, it is returned with its sign reversed so that it becomes positive. Otherwise it is returned unchanged. 

acos  Returns the inverse cosine in radians (0.0 to pi). 

asin  Returns the inverse sine in radians. The result will be an angle in the range between pi/2 and pi/2. 

atan  Returns the inverse tangent in radians. The result will be an angle in the range between –pi/2 and pi/2. 

atan2 
Converts Cartesian x and y coordinates to polar coordinates and returns the polar angle, measured counterclockwise from the positive xaxis. The result will be an angle in radians in the range between pi and pi. 

ceil  Rounds a numerical value up to the nearest integer value greater than or equal to the input value. 

cos  Returns the cosine of an angle in radians (in the range [1,1]). 

exp  Returns the inverse natural logarithm of a number (i.e Euler's number raised to the power of the input parameter, e^{x}). 

floor  Rounds a numerical value down to the nearest integer value less than or equal to the input value. 

is_infinite 
Tests if a number is infinite in magnitude. Returns true if the number is positive or negative infinity, and false otherwise. 

is_NaN 
The special numerical value "not a number" results from certain mathematical operations such as dividing 0.0 by 0.0, which cannot be computed. Returns true if the number has the special value "not a number" and false if it is a valid (finite or infinite) number. 

log  Returns the natural logarithm (base e) of a number. 

log10  Returns the logarithm to base 10 of a number. 

max  Returns the largest of 2 or more values. 

min  Returns the smallest of 2 or more values. 

pow  Returns the value of one number raised to the power of another number (a^{b}). 

round  Returns a number rounded to the nearest integer value. 

sin  Returns the sine of an angle in radians (in the range [1,1]). 

sqrt  Returns the (positive) square root of a number. 

tan  Returns the tangent of an angle (specified in radians). 

Function  Description  Parameter(s) 

bit_and 
Returns the bitwise AND of two integers. Each bit in the binary expansion of the result will only be set if both of the corresponding bits in the two input numbers are also set. 

bit_not 
Returns the bitwise complement of an integer. Each bit in the binary expansion of the result will be the opposite of the corresponding bit in the input number. 

bit_or 
Returns the bitwise OR of two integers. Each bit in the binary expansion of the result will be set if either of the corresponding bits in the two input numbers is set. 

bit_shift  Returns an integer value computed by shifting the binary bits of the input value. Note: Positive values shift it to the left and negative values shift it to the right. 

bit_xor 
Returns the bitwise XOR of two integers. Each bit in the binary expansion of the result will be set if the corresponding bits in the two input numbers are different from one another. 

Function  Description  Parameter(s) 

index_of 
Searches in a string for occurrences of another string and returns the index of the first match found (where the first character is at index 0). Returns 1 if the string could not be found. 

jaro_ winkler_ similarity 
Returns a double value representing the JaroWinkler similarity score between two words. If both strings are null or empty then they are considered an exact match. 

length  Returns the length of a string (number of characters). 

levenshtein_ distance 
Returns an integer for the difference, 0 if identical. 

re_search 
Performs a regular expression search for a Javastyle regular expression inside a string. If a match is found, the matching string (a substring of the first string) is returned. Otherwise null is returned. 

re_subs_all  Replaces all occurrences of patterns matching a Javastyle regular expression in a string with the specified replacement string. 

re_subs_first  Replaces the first occurrence of a pattern matching a Javastyle regular expression in a string with the specified replacement string. 

soundex  Returns the soundex code for the word, or null if the word cannot be mapped to a soundex. 

substring  Returns substring of the input string between the specified character indexes (where the first character is at index 0). 

to_lowercase  Converts a string to lower case. 

to_uppercase  Converts a string to upper case (capital letters). 

trim  Returns a trimmed String, or null if a null object was passed in . 

Function  Description  Parameter(s) 

count  Returns the number of elements in a collection. 

Function  Description  Parameter(s) 

generate_ uuid 
Generates a (version 4) random UUID string in lowercase 844412 hexadecimal format (e.g. 125d4167c85b43d4b416523625244020). 
None 
read_ sequence 
Returns the next value in the sequence (as an integer). 

rule_ name 
Returns the name (and optionally the path) of the currently running rule, or of the rule which triggered the current action if running an action map. Note: Paths are returned without a type prefix, for example: 

Function  Description  Parameter(s) 

get_session_parameter_value  Returns the value of a named parameter in a session. 
Name of the parameter to retrieve. 
metadata_ store_ lookup 
Looks up the value of a key in a specific table within in a metadata store. The query will match all keys in the table that equals the input value. If there are multiple matches, the first value found in the table is returned. Note: The returned value is the same as a Constant Value using the same metadata store, table and key. Note: This builtin function is the reverse of metadata_store_reverse_lookup. 

metadata_ store_ reverse_ lookup 
Look up the key of a value in a specific table within in a metadata store. The query will match all values in the table that equals the input value. If there are multiple matches, the first key found in the table is returned. Note: This builtin function is the reverse of metadata_store_lookup. 

Function  Description  Parameter(s) 

shift_ geometry 
A shifted version of the geometry This will be a geometry of the same type as the input geometry with the same number of vertices. Note: Ensure that the name used for the register_shift_vector builtin operation is used here. 

Note: The tsort_* functions are used to implement iterating through objects in dependency order. Please contact 1Spatial Support for further guidance on their use.
Function  Parameter(s) 

tsort_ blocked_ objects 

tsort_ blocked_ predecessors 

tsort_ blocked_ successors 

tsort_ ordered_ objects 

Function  Description  Parameter(s) 

add_date 
Adds a date and time in the TIMESTAMP date format yyyyMMdd HH:mm:ss.SSS. Note: Some data stores may not hold the same precision levels for time data as the TIMESTAMP. For example, if the TIMESTAMP value is exported to a data store with less accurate time, the TIMESTAMP value in will reflect that in the target data store. 

current_ datetime 
Returns the current date and time as a string. 

get_ current_ date 
Returns the current date and time in the TIMESTAMP date format yyyyMMdd HH:mm:ss.SSS. 
None 
to_ timestamp 
Converts a date/time formatted string, or time in milliseconds, into a timestamp datatype. The default date/time format is "yyyyMMdd hh:mm:ss.SSS z". The default format allows just the date with no time to be specified. For example 20170317 14:25:03 GMT or 20170317. The time specified in milliseconds is from January 1, 1970, 00:00:00 GMT. Note: For more information about the format rules, refer to the Oracle documentation. 

Function  Description  Parameter(s) 

is_structured 
Tests if an object is topologically structured. Returns true if the object is structured and false otherwise. 

Function  Description  Parameter(s) 

class_get_attributes 
Return a collection of strings containing the attributes on a class. This function returns the attributes from the 1Integrate schema based on the studio class name. This function should be used in conjunction with functions:


class_get_attribute_type 
Return the type of an attribute given an object and the attribute name. This function should be used in conjunction with functions:


class_get_attribute_value  Return the value of an attribute of an object 

class_is_attribute_null 
Return TRUE if an attribute is NULL, otherwise return FALSE. This function should be used in conjunction with functions:

